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

The following bug has been logged on the website:

Bug reference:      15936
Logged by:          Shiwangini Shishulkar
Email address:      shiwangini.shishulkar@webgility.com
PostgreSQL version: 11.4
Operating system:   CentOS Linux release 7.6.1810 (Core)
Description:

We have created a user defined data type type_currency. Below is the
definition:

-- DROP DOMAIN type_currency;

CREATE DOMAIN type_currency AS numeric
    DEFAULT 0;


However, when we are not any specific value to this column ,it should by
default pick '0'. However, it isn't working in the way/not taking 0 as
default value.

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