Re: deleting the master but not the detail

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: deleting the master but not the detail
Дата
Msg-id 20080717103731.T77268@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: deleting the master but not the detail  ("Ismael ...." <ismaelpsp@hotmail.com>)
Ответы Re: deleting the master but not the detail  ("Ismael ...." <ismaelpsp@hotmail.com>)
Список pgsql-general
On Thu, 17 Jul 2008, Ismael .... wrote:

> So is there no other way to do it but to verify the integrity using triggers
> and drop the referential constraints?

Well, you could do something using a before delete trigger on the
referencing table that returns NULL to avoid the delete as well, but
making it only prevent the deletions caused by the referential constraints
might be difficult.

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

Предыдущее
От: "Rhys A.D. Stewart"
Дата:
Сообщение: in query variables....
Следующее
От: "Douglas McNaught"
Дата:
Сообщение: Re: [HACKERS] postmaster.pid not visible