finding data violating constraint

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема finding data violating constraint
Дата
Msg-id 20041019130446.M56480@narrowpathinc.com
обсуждение исходный текст
Ответы Re: finding data violating constraint  (Oliver Elphick <olly@lfix.co.uk>)
Re: finding data violating constraint  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: finding data violating constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi All,

I am trying to build a foreign key constraint.  The objective is to prevent
parts from being entered that do not have a valid sales account.  When I try
to build the constraint it fails telling me that there is a violation.  I have
looked at the data and just can't seem to find the problem.  Is there a way to
find the data that is causing the problem?  I tried deleting all the data and
building the constraint.  That of course works but then I am unable to load
the data and I have no better idea of where the problem is located.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com


В списке pgsql-novice по дате отправления:

Предыдущее
От: Paul Makepeace
Дата:
Сообщение: Finding last day in a month
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: finding data violating constraint