Re: Temparary disable constraint

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Temparary disable constraint
Дата
Msg-id 200701171549.l0HFnMl22811@momjian.us
обсуждение исходный текст
Ответ на Re: Temparary disable constraint  ("Adnan DURSUN" <a_dursun@hotmail.com>)
Ответы Re: Temparary disable constraint  (Richard Huxton <dev@archonet.com>)
Список pgsql-hackers
Adnan DURSUN wrote:
>    Hi, Maybe added more further things to TODO list. Enabled /
>    disabled other objects like view/funtion. imagine a lot of
>    views that referances a table and i wanna drop a column on this
>    table that used by these views. Postgres doesnt allow this.
>    First i must drop these views then drop the column on that
>    table and then recreate these views.  Can this be resolved
>    (like oracle does) ?

Not easily, because the view are bound to the object id of the tables
involved.

-- Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Temparary disable constraint
Следующее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: fixing Makefile.shlib for solaris/gcc with -m64 flag