pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIs it possible to set a NOT NULL constraint deferrable?
2+ messages / 2 participants
[nested] [flat]
* Is it possible to set a NOT NULL constraint deferrable?
@ 2003-12-05 15:47 Olivier Hubaut <olivier@scmbb.ulb.ac.be>
0 siblings, 1 reply; 2+ messages in thread
From: Olivier Hubaut @ 2003-12-05 15:47 UTC (permalink / raw)
To: pgsql-sql
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?
--
Ci-git une signature avortee.
** RIP **
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Is it possible to set a NOT NULL constraint deferrable?
@ 2003-12-06 23:54 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Olivier Hubaut <olivier@scmbb.ulb.ac.be>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2003-12-06 23:54 UTC (permalink / raw)
To: Olivier Hubaut <olivier@scmbb.ulb.ac.be>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-06 23:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-05 15:47 Is it possible to set a NOT NULL constraint deferrable? Olivier Hubaut <olivier@scmbb.ulb.ac.be>
2003-12-06 23:54 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox