Home
The Toolkit for Online Communities
15939 Community Members, 0 members online, 2387 visitors today
Log In Register

Forum OpenACS Q&A: Response to Weirdness with composite primary keys

OpenACS Home : Forums : OpenACS Q&A : Response to Weirdness with composite primary keys : One Message

+
Posted by Dan Wickstrom on
If you did it inside a transaction, then checking in psql doesn't really tell you if the key already exists in the db.  When you get the duplicate key insertion, the whole transaction is rolled back, so you wouldn't be able to tell if a duplicate was inserted.  You need to look at all thirty inserts and make sure that you don't have a duplicate in the transaction.  A good way to check is to run aolserver inside shell mode of emacs and search backwards for the duplicate insert.