Re: Temparary disable constraint

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Adnan DURSUN <a_dursun(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Temparary disable constraint
Date: 2007-01-17 15:49:22
Message-ID: 200701171549.l0HFnMl22811@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jignesh K. Shah 2007-01-17 16:01:19 Re: fixing Makefile.shlib for solaris/gcc with -m64 flag
Previous Message Bruce Momjian 2007-01-17 15:48:37 Re: Temparary disable constraint