Re: BUG #15936: user defined data type isn't picking default value - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15936: user defined data type isn't picking default value
Date
Msg-id 6765691564656149@iva8-32d39461b495.qloud-c.yandex.net
Whole thread Raw
In response to BUG #15936: user defined data type isn't picking default value  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Hello

melkij=> CREATE DOMAIN type_currency AS numeric default 0;
CREATE DOMAIN
melkij=> create table tt ( i int, t type_currency);
CREATE TABLE
melkij=> insert into tt (i) values (1);
INSERT 0 1
melkij=> table tt;
 i | t 
---+---
 1 | 0

Works for me.
Can you provide reproducible testcase?

regards, Sergei



pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: Logging corruption error codes
Next
From: PG Bug reporting form
Date:
Subject: BUG #15937: Partitioning