NYCPHP Meetup

NYPHP.org

[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