Re: Referential Integrity problem

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(at)Yahoo(dot)com #

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