Re: Deferrable constraints

From: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deferrable constraints
Date: 2003-06-17 21:03:38
Message-ID: 993DBE5B4D02194382EC8DF8554A5273114039@postoffice.waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmm,
I really need to disable that unqiue constraint temporarily during the
table update. I tried to mess with pg_constraint and pg_index, but
didn't figure out how to do this.
Any ideas from system schema buffs?
Thanks.

Oleg

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Tuesday, June 17, 2003 11:37 AM
To: Oleg Lebedev
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Deferrable constraints

On Tue, Jun 17, 2003 at 11:20:15 -0600,
Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org> wrote:
> Are there any plans to implement deferrable unique constraints?

It is on the TODO list (http://developer.postgresql.org/todo.php):
* Allow DEFERRABLE UNIQUE constraints

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2003-06-17 21:05:01 Re: full featured alter table?
Previous Message Kurt Roeckx 2003-06-17 20:49:00 Re: ss_family in hba.c