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

["Chris Travers" <..hidden..>]

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"
> Error!
>                 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 !
> http://us.rd.yahoo.com/evt=40705/*http://mrd.mail.yahoo.com/try_beta?.intl=cf
>
> -------------------------------------------------------------------------
> 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.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users