Re: Adding "on delete cascade" after table creation ?
От | Peter Alberer |
---|---|
Тема | Re: Adding "on delete cascade" after table creation ? |
Дата | |
Msg-id | 002101c26545$92c0c190$5be0d089@ekelhardt обсуждение исходный текст |
Ответ на | Re: Adding "on delete cascade" after table creation ? (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: Adding "on delete cascade" after table creation ?
Re: Adding "on delete cascade" after table creation ? Re: Adding "on delete cascade" after table creation ? |
Список | pgsql-general |
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? >-----Ursprüngliche Nachricht----- >Von: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com] >Gesendet: Donnerstag, 19. September 2002 17:06 >An: Peter Alberer >Cc: pgsql-general@postgresql.org >Betreff: Re: [GENERAL] Adding "on delete cascade" after table creation ? > > >On Thu, 19 Sep 2002, Peter Alberer wrote: > >> Hi there, >> >> i have a table that SHOULD look like this: >> >> create table lr_object_usage ( >> lr_object_usage_id integer >> constraint >> lr_object_usage_lr_object_usage_id_pk >> primary key, >> lr_object_id integer >> constraint lr_object_usage_lr_object_id_fk >> references lr_objects(lr_object_id) >> on delete cascade, >> access_time timestamp, >> user_id integer >> constraint lr_object_usage_user_id_fk >> references users(user_id), >> status varchar(11), >> context integer >> constraint lr_object_usage_context_fk >> references >> lr_object_usage(lr_object_usage_id) >> ___ON DELETE CASCADE___ >> ); >> >> unfortunately i think that the table was created without the delete >> cascade in the last line (for the constraint >> lr_object_usage_context_fk). Is it somehow possible to add the delete >> cascade without recreating the table? > >You'll probably have to manually remove the triggers for the foreign >key constraint (see techdocs.postgresql.org's fk primers for info) and >then use alter table add constraint. >
В списке pgsql-general по дате отправления: