Adding "on delete cascade" after table creation ?

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Adding "on delete cascade" after table creation ?
Date: 2002-09-19 09:16:21
Message-ID: 000401c25fbd$380255d0$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-09-19 09:33:36 Deadlock error!?
Previous Message frbn 2002-09-19 08:56:06 Re: Database uptime?