Re: 8.5devel: alter constraint ?
От | Andreas Kretschmer |
---|---|
Тема | Re: 8.5devel: alter constraint ? |
Дата | |
Msg-id | 20091114204446.GA19414@tux обсуждение исходный текст |
Ответ на | Re: 8.5devel: alter constraint ? (Jeff Davis <pgsql@j-davis.com>) |
Список | 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 по дате отправления: