Hi. Hard to find this command in the documentation - how should I alter a
table to REMOVE the on delete cascade constraint from a table? Thanks.
Phoenix Kiula wrote:
Hi. Hard to find this command in the documentation - how should I alter a
table to REMOVE the on
delete cascade constraint from a table? Thanks.
Unless you want to mess with the catalogs directly, I believe that
you have to create a new constraint and delete the old one,
You can do all that in a single sql command.
ALTER TABLE b DROP CONSTRAINT b_a_id_fkey, ADD CONSTRAINT b_a_id FOREIGN
KEY (a_id) REFERENCES a(a_id);
On Fri, Jun 28, 2013 at 5:55 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Phoenix Kiula wrote:
Hi. Hard to find this command in the