| From: | "Politowicz, Phil" <philip(dot)politowicz(at)berbee(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | primary key constraint violation |
| Date: | 2005-08-05 15:20:25 |
| Message-ID: | D078DAD578D48A46A67AB71E6D232494131B4F@CTG-MSNEXC01.staff.berbee.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am running a 7.4.3 postgreSQL database on RHEL 3.
I have encountered two cases where tables have multiple key values, in
violation of a primary key constraint. I discovered this after receiving
SQL exceptions, where the primary key constraint was all of a sudden
being enforced again. This may be associated with a vacuum/analyze being
done on the table in question. Has anyone heard of such a problem with v
7.4?
Thanks.
Philip Politowicz
Database Administrator
Berbee Information Networks
5520 Research Park Drive
Fitchburg, WI 53711
philip(dot)politowicz(at)berbee(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2005-08-05 16:10:57 | Re: Replication |
| Previous Message | Dario Brignardello | 2005-08-05 13:28:55 | Re: Blocking connection and timeout problem |