Re: BUG #15936: user defined data type isn't picking default value

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "shiwangini(dot)shishulkar(at)webgility(dot)com" <shiwangini(dot)shishulkar(at)webgility(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15936: user defined data type isn't picking default value
Date: 2019-08-01 10:42:29
Message-ID: 6765691564656149@iva8-32d39461b495.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-08-01 12:51:49 BUG #15937: Partitioning
Previous Message Andrey Borodin 2019-08-01 09:42:11 Re: Logging corruption error codes