Description: ------------ When a tables primary key is a native sequence, for postgreSQL, DB_DataObject does a 'SELECT currval(<sequence-name>)' to get the key to use when inserting a new row. (In DataObject.php line 1084) However, you cannot call currval() without first having called nextval(<sequence-name>), thus, there will be an error from postgreSQL. The correct thing to do would be 'SELECT nextval(<sequence-name>)' instead.

Added patch pgsql-sequence-patch.

It's not documented (could probably do with a note in the manual somwhere) , but you need to create your tables like this. CREATE TABLE reservations ( id integer DEFAULT nextval('reservations_seq'::text) NOT NULL sequence name is tablename with _seq at the end.

You're right - i missed that my sequences where named <tablename>_<fieldname>_seq. It seems like I could then make a sequenceKey()-method in the table's DataObject, to return the name of the sequence to use. However, the docblock for DB_DataObject::sequenceKey() say that its a private method, and the manual page doesn't say anything about this method. However, the docblock also say: 'Override this to return ....'

that's some old code ;) the config allows you to do this: sequence_{tablename} = sequencekey_name

doc comments have been fixed in SVN now.