[Mono-list] Adding DELETE CASCADE to an existing foreign key

[Howard Cole]

Hi,

I have a table created as:

create table test (
    id   serial8,
    foreign_id int8 not null references foreign(id)
);

What PSQL ALTER TABLE command can I use to cascade deletes, changing the 
column definition to:

   foreign_id int8 not null references foreign(id) on delete cascade

Thanks

Howard Cole
www.selestial.com