Re: Error inserting row on unique key - Mailing list pgsql-admin

From Tom Lane
Subject Re: Error inserting row on unique key
Date
Msg-id 26407.1145556088@sss.pgh.pa.us
Whole thread Raw
In response to Error inserting row on unique key  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: Error inserting row on unique key
List pgsql-admin
"Benjamin Krajmalnik" <kraj@illumen.com> 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
storedprocedure. 

> 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

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Error inserting row on unique key
Next
From: Allan Kamau
Date:
Subject: Re: Error inserting row on unique key