On Nov 17, 2010, at 12:42 PM, Richard Broersma wrote: > ALTER TABLE foo > DROP CONSTRAINT your_constraint, > ADD CONSTRAINT your_constraint FOREIGN KEY ... > ON UPDATE CASCADE ON DELETE RESTRICT; Thanks. That worked. -Aram -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general