So it's not a problem to drop and recreate the FOREIGN KEYs? And can I use START TRANSACTION while doing it? On Fri, Apr 27, 2012 at 9:30 PM, Raymond O'Donnell <rod@xxxxxx> wrote: > On 27/04/2012 19:59, Alexander Farber wrote: >> in 8.4.9 is it please possible to add "on delete cascades" to >> the both foreign keys in the following table w/o dropping the table? > > I think you will have to drop the foreign key and re-create it, but > certainly not the table. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
