Posted to the mailing list pointing at this thread.

A sequence table would create additional tables and additional space that is not needed. The OID is needed to propagate the new entry id to Serendipity Forms and Session variables and to return it via XML-RPC if asked for.

And of course it works in all other SQL systems like that :-)

Regards ...

The only thing to let us not depend on OIDs is a way to get the last insert id form a 'INSERT INTO' statement. If OIDs are deprectated by postgresql, what do they prefer instead to get the last insert id?

I'll add that 'set oid' statement to our SQL, thanks!

Regards,
Garvin If the table doesn't ...

You could also add:
to the PostgreSQL db.sql (for at least >= 8.0, but maybe 7.4 as well).

Ok, I recreated your database adding WITH OIDS to each CREATE TABLE, and it does, in fact, fix the issue.

I'm firmly of the belief that DEPENDING on OIDS is a mistake, and should be looked into.

(OID's are a "scarce" resource).

How can I assist more?

But yes, we need OIDs for tables. We need to get the last inserted ID with some way. MySQL does this via a PHP mysql_insert_id() function, SQLite does it via PHP sqlite_last_insert_rowid() function.

Surely PostgreSQL supports something similar and I only don't know about it? In your case you will ...

One thing I just thought of. I have "default_with_oids" set to FALSE, which means you
don't get an OID for every row.

Since the PostgreSQL folks are trying to move away from OID's on every row, this is a good thing.

Do you depend on OID's for each row of your tables?

If so, you may need to add ...

Works fine:


$ psql serendipity
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

serendipity=# INSERT INTO serendipity ...

the log is at:

http://www.lerctr.org/~ler/pgsql.log

this is with PHP 4.3.11-DEV and PGSQL 8.0.1

I'm a noobie, but like to help find bugs :)

Whenever I add a new entry, I get the following:



Warning: pg_query(): Query failed: ERROR: syntax error at end of input at character 46 in /home/ler/serendipity/include/db/postgres.inc.php on line 83

Warning: pg_num_rows(): supplied argument is not ...