Re: Problem with FKEYS

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: Problem with FKEYS
Дата
Msg-id 3FB3B03D.9030809@trade-india.com
обсуждение исходный текст
Ответ на Re: Problem with FKEYS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:

  Rajesh Kumar Mallah <mallah@trade-india.com> writes:


    How come pgsql7.3.4  Was allowing me to delete the master record while
referencing records were present in slave table?



The only explanation I can think of is that the referencing row shown as
being in user_services was actually in a child table --- foreign keys
don't work in inheritance hierarchies at the moment.


No, That is not the case , they are plain tables.




If that's not it, can you provide a self-contained example?

Could not replicate it with newly created tables. Only those set of
table
has the problem. I am ready to provide any required info .

Regds
Mallah.




            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

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

Предыдущее
От: Paulo Jan
Дата:
Сообщение: Re: Perfomance difference between 7.2 and 7.3
Следующее
От: "mboscia"
Дата:
Сообщение: Re: change conndeferrable in pg_constraint?