Re: 8.5devel: alter constraint ? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: 8.5devel: alter constraint ?
Date
Msg-id 20091114204446.GA19414@tux
Whole thread Raw
In response to Re: 8.5devel: alter constraint ?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Jeff Davis <pgsql@j-davis.com> wrote:

> On Sat, 2009-11-14 at 17:42 +0100, Andreas Kretschmer wrote:
> > I'm playing with 8.5devel.
> >
> > My question: is it possible to alter a constraint without drop and
> > rebuilding it?
> >
> > For instance, i have a table test with a primary key, but i have
> > forgotten to declare the constraint as DEFERRABLE. I can drop and
> > recreate that, but the index are also dropped and recreated and i think,
> > this is not necessary.
> >
>
> Right now that is not possible.

Okay, thx for the answer and good luck for your work!


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: safelly erasing dirs/files
Next
From: Merlin Moncure
Date:
Subject: Re: all empty tables