[nycphp-talk] PEAR::DB->nextID problems
Mitch Pirtle
mitchy at spacemonkeylabs.com
Sun Aug 1 16:35:27 EDT 2004
Hey list,
I'm experimenting with PEAR::DB's nextID method and PostgreSQL 7.4.
Everything appears to be on the up-and-up, but I keep getting stale
numbers from nextID when called. Just to catch the problem, I wrote an
echo to show what DB thinks the next number is in the sequence, and it
prints out:
UPDATE content SET content_archive_id = 18 WHERE id = 4
...but pgsql tells me the latest id in the table is 20?!?!
Any ideas on how to debug this?
-- Mitch
More information about the talk
mailing list