Error inserting row on unique key

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Error inserting row on unique key
Date: 2006-04-20 17:31:14
Message-ID: 8511B4970E0D124898E973DF496F9B4325157D@stash.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.
Could this be caused by a subsequent call to the stored procedure which took place before the sequence on the prior stored procedure fired?
If so, do you recommend taking the call to the sequence out of the columns constraint definition and manually calling it as the firs step in the SP call?

As I said, this does not happen very often, but I have seen it happen.

Regards,

Benjamin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-04-20 18:01:28 Re: Error inserting row on unique key
Previous Message Thomas F. O'Connell 2006-04-20 17:07:13 Re: Invalid Page Headers