BUG #2144: Domain NOT NULL constraints ignored in rules

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-bugs by date

  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