Re: Error inserting row on unique key

"Benjamin Krajmalnik"  writes:
> I have a large table which uses a sequence for column which is defined as the primary key.
> Our systems is a real time data acquisition system, so we have "insert" statements going through it wrapped inside stored procedure.

> Every once in a while I get an inserio error on a violation of a unique constraint on the primary key.

Let's see that stored procedure ...

			regards, tom lane