From: | "Sergiy Vyshnevetskiy" <serg(at)vostok(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2954: null is not checked against domain constraints in return clause |
Date: | 2007-02-01 15:43:55 |
Message-ID: | 200702011543.l11FhtSB071525@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2954
Logged by: Sergiy Vyshnevetskiy
Email address: serg(at)vostok(dot)net
PostgreSQL version: 8.2.1
Operating system: FreeBSD-6 stable
Description: null is not checked against domain constraints in return
clause
Details:
#psql = serg(at)[local]:5432 test
create domain "DInt" as int not null;
CREATE DOMAIN
#psql = serg(at)[local]:5432 test
create or replace function test() returns "DInt" immutable strict language
plpgsql as $F$begin return null; end$F$;
CREATE FUNCTION
#psql = serg(at)[local]:5432 test
select test() is null;
?column?
----------
t
(1 )
#psql = serg(at)[local]:5432 test
We should have gotten an error during execution of test().
From | Date | Subject | |
---|---|---|---|
Next Message | Sergiy Vyshnevetskiy | 2007-02-01 17:20:34 | Re: BUG #2954: null is not checked against domain constraints in return clause |
Previous Message | Sergiy Vyshnevetskiy | 2007-02-01 15:04:43 | Re: BUG #2948: default null values for not-null domains |