| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Gregory Wood" <gregw(at)com-stock(dot)com> |
| Cc: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: Deferred NOT NULL? |
| Date: | 2001-02-21 17:52:38 |
| Message-ID: | 10826.982777958@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Gregory Wood" <gregw(at)com-stock(dot)com> writes:
> Hmmmm, I just found a clearer grammar description in the docs and it appears
> that only REFERENCES constraints are deferrable in PostgreSQL. I suppose
> I'll have to handle this via a trigger for now.
> The book mentions that SQL92 allows for deferrable NOT NULL constraints. Is
> this planned for anytime soon?
This is (or should be) on the TODO list, but I don't know of anyone with
near-term plans to fix it. The whole area of constraints could use an
overhaul, see past discussions in pghackers.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-21 17:53:49 | Re: AllocSetAlloc() |
| Previous Message | Stephan Szabo | 2001-02-21 17:38:09 | Re: Weird indices |