Jeff Davis <pgsql@xxxxxxxxxxx> 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° -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
