Referential Integrity problem - Mailing list pgsql-general

From Herb Blacker
Subject Referential Integrity problem
Date
Msg-id 3C9B6A05.7060308@isgenesis.com
Whole thread Raw
Responses Re: Referential Integrity problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Referential Integrity problem  (Jan Wieck <janwieck@yahoo.com>)
List pgsql-general
Running PG 7.1.3...
I have a table of titles and suffixes, with periods (i.e. Mr. Mrs. C.P.A.)
There is a foreign key between the title and suffix tables, and my
patient table.
When I do an insert, it fails on Referential Integrity (RI).
If I take the periods out, the insert works with RI.
If I remove the RI, then the periods work.

Is this a bug?
--
_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Have you seen these hackers: Uncle George
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Huge Performance Difference on Similar Query in Pg7.2