database not enforcing unqiue constriant - Mailing list pgsql-general

From Merlin Moncure
Subject database not enforcing unqiue constriant
Date
Msg-id b42b73150610261900g73725e25m15f018397eb83b5a@mail.gmail.com
Whole thread Raw
Responses Re: database not enforcing unqiue constriant  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
My previous employer contacted me today.  Apparently they are having
an increasing frequency of occurances where they disocover violations
of the primary key constraint not being caught by the database.  This
system is an ISAM emulation system, and it relies heavily on the
database throwing unique constraint violations to approximately
provide a cobol rewrite statement.

These errors are never caught when they occur.  One way they are
caught is during a dump/reload, the record fails to reinsert.

I brought this up around a year ago, and the issue was never
successfully resolved.  These are windows systems running PostgreSQL
8.0.x.

any thoughts?

merlin

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Possible problem with PQescapeStringConn and
Next
From: Richard Broersma Jr
Date:
Subject: Re: pg_dumpall failing from possible corrupted shared memory