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 <[EMAIL PROTECTED]> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
