- Original Message -
From: "Richard Huxton"
To: "Bruce Momjian" <[EMAIL PROTECTED]>
Cc: "Adnan DURSUN" <[EMAIL PROTECTED]>;
Sent: Thursday, January 18, 2007 5:57 PM
Subject: Re: [HACKERS] Temparary disable constraint
Not easily, because
Bruce Momjian wrote:
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.
.
Best Regards
Adnan DURSUN
ASRIN Bilisim Ltd.
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Adnan DURSUN" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 17, 2007 5:49 PM
Subject: Re: [HACKERS] Temparary disable constraint
A
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 mus
Hubert FONGARNAND wrote:
> Ok it works, but we have to write a plpgsql function that takes the
> table_name and the constraint name in parameters
>
> It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ...
> (as oracle does)
>
> it could be good to add this to the TODO LIST...
, January 17, 2007 10:36 AM
Subject: Re: [HACKERS] Temparary disable constraint
Ok it works, but we have to write a plpgsql function that takes the
table_name and the constraint name in parameters
It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ...
(as oracle does)
it
Ok it works, but we have to write a plpgsql function that takes the
table_name and the constraint name in parameters
It could be useful to have a : ALTER TABLE ... DISABLE CONSTRAINT ...
(as oracle does)
it could be good to add this to the TODO LIST...
Thanks
Le mardi 16 janvier 2007 à 22
Hubert FONGARNAND wrote:
> Hi,
>
> Is there a way to temporary disable a constraint (without drop and
> recreating it) in postgresql?
Sure, try ALTER TABLE ... DISABLE TRIGGER for the constraint trigger
name.
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
Hi,
Is there a way to temporary disable a constraint (without drop and
recreating it) in postgresql?
Thanks
___
Ce message et les éventuels documents joints peuvent contenir des informations
confidentielles.
Au cas où il ne vous serait pas destiné, nou
