Re: Referential Integrity problem - Mailing list pgsql-general

From Jan Wieck
Subject Re: Referential Integrity problem
Date
Msg-id 200203251533.g2PFXds20967@saturn.janwieck.net
Whole thread Raw
In response to Referential Integrity problem  (Herb Blacker <herbblacker@isgenesis.com>)
List pgsql-general
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.

    Cannot  reproduce  that problem here. Could you please post a
    complete SQL script that reproduces the exact problem?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From:
Date:
Subject: Re: Could someone tell me what is wrong withthis function
Next
From: "PGMailList"
Date:
Subject: Re: Could someone tell me what is wrong withthis function