| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "PgSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | database not enforcing unqiue constriant |
| Date: | 2006-10-27 02:00:13 |
| Message-ID: | b42b73150610261900g73725e25m15f018397eb83b5a@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-10-27 02:09:12 | Re: pg_dumpall failing from possible corrupted shared memory |
| Previous Message | Jeff Davis | 2006-10-27 01:25:53 | Re: Possible problem with PQescapeStringConn and |