Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique constraint violation on serial column - Mailing list pgsql-general

From Tom Lane
Subject Re: Unique constraint violation on serial column
Date
Msg-id 7224.1113250735@sss.pgh.pa.us
Whole thread Raw
In response to Unique constraint violation on serial column  (Bill Chandler <billybobc1210@yahoo.com>)
List pgsql-general
Tree view 
Bill Chandler <billybobc1210@yahoo.com> writes:
> Client is getting the following error when attempting
> to do an insert on a table:

> ERROR: duplicate key violates unique constraint
> event_tbl_evt_id_key

What's the exact query (or queries) causing this?  Do you have any
triggers or rules that might be affecting the table?

            regards, tom lane

pgsql-general by date:

Previous
From: Bill Chandler
Date:
Subject: Unique constraint violation on serial column
Next
From: Kristina Magwood
Date:
Subject: pg_restore -d password athentication failed