| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Olivier Hubaut <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> |
| Cc: | PgSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Is it possible to set a NOT NULL constraint deferrable? |
| Date: | 2003-12-06 23:54:27 |
| Message-ID: | 200312062354.hB6NsRi08699@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2003-12-07 00:36:40 | Re: Index not recognized |
| Previous Message | Robert Treat | 2003-12-06 23:45:54 | Re: Help converting Oracle instead of triggers to PostgreSQL |