Bruno Wolff III <[EMAIL PROTECTED]> writes:
> It does look like you can only ADD and DROP constraints, not directly
> alter or replace them. So making a reference deferable is go to require
> a DROP and ADD which will need to recheck the constraint.
I asked the same question a few days ago on pgs
On Wed, Mar 30, 2005 at 10:52:42 -0700,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Mar 30, 2005 at 11:52:32AM -0600, Bruno Wolff III wrote:
> >
> > What version of Postgres are you running? I think ALTER CONSTRAINT is a
> > relatively recent addition.
>
> Where are you seeing ALTER CONST
On Wed, Mar 30, 2005 at 11:52:32AM -0600, Bruno Wolff III wrote:
>
> What version of Postgres are you running? I think ALTER CONSTRAINT is a
> relatively recent addition.
Where are you seeing ALTER CONSTRAINT? I don't see it in gram.y
even in HEAD.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
On Wed, Mar 30, 2005 at 12:33:11 +0200,
[EMAIL PROTECTED] wrote:
> On Wed, Mar 30, 2005 at 11:48:31AM +0200, PFC wrote:
> >
> > Checks the docs on ALTER TABLE ... ALTER CONSTRAINT ...
>
> ALTER CONSTRAINT? I did check for that, and it does not appear to
> exist?! That's why I asked ...
Wha
On Wed, Mar 30, 2005 at 11:48:31AM +0200, PFC wrote:
>
> Checks the docs on ALTER TABLE ... ALTER CONSTRAINT ...
ALTER CONSTRAINT? I did check for that, and it does not appear to
exist?! That's why I asked ...
Rgds, Frank
---(end of broadcast)--
Checks the docs on ALTER TABLE ... ALTER CONSTRAINT ...
On Wed, 30 Mar 2005 11:07:32 +0200, <[EMAIL PROTECTED]> wrote:
Hello. Is it possible to change an FK constraint from NOT DEFERRABLE
(the default) to DEFERRABLE without dropping and re-creating it? One idea
that came up was to create a para
Hello. Is it possible to change an FK constraint from NOT DEFERRABLE
(the default) to DEFERRABLE without dropping and re-creating it? One idea
that came up was to create a parallel set of constraints which perform
the same checks as the existing ones as DEFERRABLE (and then drop the
old set), but t
