Postgres Pro
Downloads
Home   >   mailing lists

Adding ON UPDATE CASCADE to an existing foreign key constraint - Mailing list pgsql-general

From Rich Doughty
Subject Adding ON UPDATE CASCADE to an existing foreign key constraint
Date
Msg-id 445A1B29.8010803@opusvl.com
Whole thread Raw
Responses Re: Adding ON UPDATE CASCADE to an existing foreign key  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view 
I have a foreign key constraint that I'd like to alter. I'd rather not
drop and re-create it due to the size of the table involved. All I need
to do is add an ON UPDATE CASCADE.

Is it ok to set confupdtype to 'c' in pg_constraint (and will this be
all that's needed) or is it safer to drop and recreate the constraint?

PG Version 8.0.3


Thanks a lot


   - Rich Doughty

pgsql-general by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: Segfaults with 8.1.3 on amd64
Next
From: Stephan Szabo
Date:
Subject: Re: Adding ON UPDATE CASCADE to an existing foreign key