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.