Adding "on delete cascade" after table creation ?
От | Peter Alberer |
---|---|
Тема | Adding "on delete cascade" after table creation ? |
Дата | |
Msg-id | 000401c25fbd$380255d0$5be0d089@ekelhardt обсуждение исходный текст |
Ответы |
Re: Adding "on delete cascade" after table creation ?
|
Список | pgsql-general |
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? TIA, peter
В списке pgsql-general по дате отправления: