Description: ------------ This code from "function currID()" in MDB2_Driver_pgsql is using last_value of a sequence which is not connection specific within PostgreSQL: return $this->queryOne("SELECT last_value FROM $sequence_name",'integer'); "last_value" will return the globally unique last value as the whole database sees it. return $this->queryOne("SELECT currval(<seqname>)", 'integer'); is the correct way to get the connection specific Postgres sequence value. This bug was also appearing in DataObject and fixed in this manner as seen in this pear-dev thread: http://www.codecomments.com/message1086631.html

the problem is that the cross database behaviour is to get the global last value generated for the given sequence. so the solution is to implement lastInsertID() in the sequence using drivers using currval() or similar methods.

do you already have a lastInsertID() in mind? Could this use the fix proposed for currID? function lastInsertID($table = null, $field = null) { $sequence_name = $this->quoteIdentifier($this->getSequenceName($table), true); return $this->queryOne("SELECT currval('$sequence_name')", 'integer'); } [darn 60 col textarea]

I have applied a fix for PostgreSQL, now we need a fix for Interbase and Oracle.

Added to Firebird/Interbase driver too. We probably need a testcase...

sorry, I misread the bug report. AFAIK, there's no equivalent to postgresql's currval() in firebird.

This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.