Re: Referential Integrity problem - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Referential Integrity problem
Date
Msg-id 20020322101053.S80898-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Referential Integrity problem  (Herb Blacker <herbblacker@isgenesis.com>)
List pgsql-general
On Fri, 22 Mar 2002, Herb Blacker wrote:

> 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?

Can you send schema and sample data?



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Small question
Next
From: Stephan Szabo
Date:
Subject: Re: Huge Performance Difference on Similar Query in Pg7.2