Re: Adding "on delete cascade" after table creation ?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Adding "on delete cascade" after table creation ?
Дата
Msg-id 20020926071349.L23362-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: Adding "on delete cascade" after table creation ?  ("Peter Alberer" <h9351252@obelix.wu-wien.ac.at>)
Список pgsql-general
On Thu, 26 Sep 2002, Peter Alberer wrote:

> From looking at the techdocs document i got the impression that I simply
> need to change the value of "tgfoid" in pg_trigger from "1654"
> (RI_FKey_noaction_del) to "1646" (RI_FKey_cascade_del). Is this correct?

Technically, yes I believe so (well, check to make sure the oids are those
values on your system). I usually don't suggest manual surgery to the
system tables as messing up is somewhat painful (even in dropping the
triggers I'd suggest using drop trigger "<name>")


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

Предыдущее
От: Manfred Koizar
Дата:
Сообщение: Re: Nicer dump files?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance while loading data and indexing