Re: [ADMIN] Error inserting row on unique key

2006-04-20 Thread Benjamin Krajmalnik
l.org Subject: Re: [ADMIN] Error inserting row on unique key Benjamin, Are you sure the sequence is the only source of the values of the primary key field of all records in this table, that no records may have been inserted using primary key field values generated from sources other than the seq

Re: [ADMIN] Error inserting row on unique key

2006-04-20 Thread Allan Kamau
Benjamin, Are you sure the sequence is the only source of the values of the primary key field of all records in this table, that no records may have been inserted using primary key field values generated from sources other than the sequence. Allan. --- Tom Lane <[EMAIL PROTECTED]> wrote: > "Benj

Re: [ADMIN] Error inserting row on unique key

2006-04-20 Thread Tom Lane
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> 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 i