Re: Adding "on delete cascade" after table creation ? - Mailing list pgsql-general

From Peter Alberer
Subject Re: Adding "on delete cascade" after table creation ?
Date
Msg-id 002101c26545$92c0c190$5be0d089@ekelhardt
Whole thread Raw
In response to Re: Adding "on delete cascade" after table creation ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Adding "on delete cascade" after table creation ?
Re: Adding "on delete cascade" after table creation ?
Re: Adding "on delete cascade" after table creation ?
List 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 by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: two databases
Next
From: Tino Wildenhain
Date:
Subject: Re: Adding "on delete cascade" after table creation ?