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