Re: Referential Integrity problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Herb Blacker <herbblacker(at)isgenesis(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Referential Integrity problem
Date: 2002-03-22 18:11:22
Message-ID: 20020322101053.S80898-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-03-22 18:16:27 Re: Huge Performance Difference on Similar Query in Pg7.2
Previous Message Jan Wieck 2002-03-22 18:07:02 Re: Small question