[SQL] changing referential integrety action on existing table

I have a table that uses the NO ACTION action for it's referential integrity. I'd like to change it to CASCADE for the ON DELETE event. I'm using Postgres 7.2. I noticed that in the output of my pg_dump I have some triggers that look like: CREATE CONSTRAINT TRIGGER "RI_ConstraintTriger_*" Is it

Re: [SQL] changing referential integrety action on existing table

On Thu, 6 Feb 2003, Matthew Nuzum wrote: > I have a table that uses the NO ACTION action for it's referential > integrity. I'd like to change it to CASCADE for the ON DELETE event. > I'm using Postgres 7.2. I think the best way is to drop all three triggers for the constraint and use alter table