Re: Unique constraint violation on serial column

Tom,

This is not the EXACT command (don't have that since
this a client site and they did not have logging
turned on) but the insert command would have looked
something like:

INSERT INTO EVENT_TBL VALUES(1039850293991, 'X.Y.Z',
1039110343000, '10.25', 1, 739950991)

For what its worth, the command is being issued via
JDBC app.

If the exact command is important I could have them
turn on logging and I could get that for you.

Bill

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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
>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com