Referential Integrity problem

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?

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