[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DBD::Pg::st execute failed: ERROR

Your id sequence may be out of whack.  This error is a good thing
because to continue to o the insert might cause serious problems.

Check the maximum value of the transactions table and set the id accordingly.

On 5/29/07, Khalil Foundy <..hidden..> wrote:
Hi Guys sorry to bother you again,
But since this morning this error is causing me a real headache. Does any one knows what this is ? and how to get around it ? This error occurred  while trying to add a GL transaction.

DBD::Pg::st execute failed: ERROR:  duplicate key violates unique constraint "transactions_pkey"
                INSERT INTO gl (reference, employee_id)
                     VALUES ('Tue May 29 11:50:13 20073929', (SELECT id FROM employee
                                       WHERE login = ?))
ERROR:  duplicate key violates unique constraint "transactions_pkey"

      Essayez le Tout-nouveau Yahoo! Courriel, pour voir un aperçu du panneau de lecture de courriels !

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
Ledger-smb-users mailing list