Re: Changing constraints to deferrable

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changing constraints to deferrable
Date: 2005-03-23 20:13:41
Message-ID: 20050323201341.GB53187@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 23, 2005 at 12:13:33PM -0500, Greg Stark wrote:
>
> Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :)

Shouldn't ALTER TABLE DROP CONSTRAINT followed by ALTER TABLE ADD
CONSTRAINT work? It does for me in simple tests. It's a little
more work than a single ALTER TABLE ALTER CONSTRAINT would be, but
it's less hackish than updating the system catalogs directly. Or
am I missing something?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2005-03-23 20:18:35 Re: debug_print_plan
Previous Message Michael Fuhr 2005-03-23 20:05:30 Re: debug_print_plan