Referential Integrity problem

Поиск
Список
Период
Сортировка
Искать
От
Herb Blacker
Тема
Referential Integrity problem
Дата
Msg-id
3C9B6A05.7060308@isgenesis.com
Список
Дерево обсуждения
Referential Integrity problem Herb Blacker <herbblacker@isgenesis.com>
Re: Referential Integrity problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Referential Integrity problem Jan Wieck <janwieck@yahoo.com> 
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
В списке pgsql-general по дате отправления
Предыдущее
От: Bruce Momjian
Дата:
Следующее
От: Nigel J. Andrews
Дата:
FAQ