Re: 8.5devel: alter constraint ?

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°