From: | "Sergiy Vyshnevetskiy" <serg(at)vostok(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2948: default null values for not-null domains |
Date: | 2007-01-31 17:59:21 |
Message-ID: | 200701311759.l0VHxLtZ028718@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: 2948
Logged by: Sergiy Vyshnevetskiy
Email address: serg(at)vostok(dot)net
PostgreSQL version: 8.2.1
Operating system: FreeBSD-6 stable
Description: default null values for not-null domains
Details:
create domain "DInt4" as int not null;
CREATE DOMAIN
#psql = serg(at)[local]:5432 test
create or replace function test() returns "DInt4" immutable strict language
plpgsql as $F$declare t "DInt4"; begin return t; end$F$;
CREATE FUNCTION
#psql = serg(at)[local]:5432 test
select test() is null;
?column?
----------
t
(1 )
#psql = serg(at)[local]:5432 test
Last select should have risen an exception:
ERROR: variable "t" declared NOT NULL cannot default to NULL
From | Date | Subject | |
---|---|---|---|
Next Message | Sergiy Vyshnevetskiy | 2007-01-31 18:07:25 | Re: BUG #2948: default null values for not-null domains |
Previous Message | Sergiy Vyshnevetskiy | 2007-01-31 15:49:45 | Re: BUG #2945: possibly forgotten SPI_push()/SPI_pop() |