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 <[EMAIL PROTECTED]> wrote: > Bill Chandler <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
