BUG #2948: default null values for not-null domains

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

Responses

Browse pgsql-bugs by date

  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()