X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 475D3D1B47E for ; Sat, 6 Dec 2003 23:54:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 89887-05 for ; Sat, 6 Dec 2003 19:54:29 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id C622CD1B4AE for ; Sat, 6 Dec 2003 19:54:25 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id hB6NsRi08699; Sat, 6 Dec 2003 18:54:27 -0500 (EST) From: Bruce Momjian Message-Id: <200312062354.hB6NsRi08699@candle.pha.pa.us> Subject: Re: Is it possible to set a NOT NULL constraint deferrable? In-Reply-To: <3FD0A87B.4010803@scmbb.ulb.ac.be> To: Olivier Hubaut Date: Sat, 6 Dec 2003 18:54:27 -0500 (EST) Cc: PgSQL SQL X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/54 X-Sequence-Number: 16220 Olivier Hubaut wrote: > I can put all the other constaints deferrable, but the *NOT NULL* one > seems to be undeferrable. > > Is ther a way to by-pass this or is do you know if this is planned in > the future versions? Only foreign key constraints are deferrable. Many want UNIQUE to be deferrable, but you are the first to ask for NOT NULL. Not sure when this will be done. Sorry. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073