Postgres Pro
Downloads
Home   >   mailing lists

Thread: Referential Integrity problem

Referential Integrity problem

From
Herb Blacker
Date:
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

Re: Referential Integrity problem

From
Stephan Szabo
Date:
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?

Re: Referential Integrity problem

From
Jan Wieck
Date:
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