Mathieu De Zutter wrote: > I have a table log_event with a primary key on an integer 'id', called > log_event_pkey. > > The tables contains a duplicate for id = 15723018. The duplicate (note that > besides the id, all data differs) doesn't seem to be known by the index at > all.
What do the INSERT lines look like? Is it a trigger, an insert called directly by the application? How is the sequence involved -- lastval(), nextval(), does the code just leave the column out for the default to fire? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
