Forum OpenACS Development: Response to Undescriptive postgresql error

Collapse
Posted by Dan Wickstrom on
This will happen if the add_child method is called more than once within a transaction.  Look at packages/acs-kernel/sql/postgresql/acs-create.sql for example of a work-around.  If this work-around doesn't fix your problem, post more information, and I'll see if I can come up with a better suggestion.  I might need to take a look a rewriting that trigger procedure to see if I can avoid the data-change violation error.

If you're interested, Don can explain the root cause of the problem in more detail, but my understanding is that it has something to do with restrictions that pg places on the number of times a primary key can be updated during a transaction.  This is something that will be addressed in a future release of pg as the current implementation seems to be incorrect in some cases.