Re: Temparary disable constraint

----- Original Message ----- 
From: "Richard Huxton" <dev@archonet.com>
To: "Bruce Momjian" <bruce@momjian.us>
Cc: "Adnan DURSUN" <a_dursun@hotmail.com>; <pgsql-hackers@postgresql.org>
Sent: Thursday, January 18, 2007 5:57 PM
Subject: Re: [HACKERS] Temparary disable constraint


>> Not easily, because the view are bound to the object id of the tables
>> involved.
>
> The trick would be I think to bind them to individual columns, so if view 
> V doesn't mention column C then dropping C has no effect on it.
>
> That's a lot more dependencies to track of course.
>  Is that not possible that all objects have a column that says whether 
object state is ok or not.
When any session wants to try to execute any DML on object, then the 
Postgres checks that state column.
If object state is not ok then Postgres raises an exception.

Best Regards

Adnan DURSUN
ASRIN Bilisim Ltd.