| From: | "John Supplee" <john(at)supplee(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2144: Domain NOT NULL constraints ignored in rules |
| Date: | 2006-01-04 15:16:38 |
| Message-ID: | 20060104151638.BC984F0AC6@svr2.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2144
Logged by: John Supplee
Email address: john(at)supplee(dot)com
PostgreSQL version: 8.1.1
Operating system: Fedore Core 4
Description: Domain NOT NULL constraints ignored in rules
Details:
I have a database with some views which have rules for insertion. One of
the views (view_a) inserts data into another view (view_b) with an insert
rule. The data inserted into view_b by view_a insert rule does not have
domain NOT NULL constraints enforced. That is, it is possible to insert a
NULL into a column whose domain forbids NULLs. NOT NULL constraints
attached directly to columns continue to forbid NULL data in the second view
(b).
If this requires more explanation let me know.
I have observed this behavior on versions 8.0.5 and 8.1.1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glenn Gentry | 2006-01-04 16:10:31 | BUG #2145: FTP Mirror to download is not found |
| Previous Message | Tom Lane | 2006-01-04 15:14:06 | Re: BUG #2143: Indexes incorrectly created from database dump |