PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15936
PG Version11.4
OSCentOS Linux release 7.6.1810 (Core)
Opened2019-08-01 07:39:44+00
Reported byShiwangini Shishulkar
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15936
Logged by:          Shiwangini Shishulkar
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2019-08-01 07:39:44+00PG Bug reporting formBUG #15936: user defined data type isn't picking default value
2019-08-01 10:42:29+00Sergei KornilovRe: BUG #15936: user defined data type isn't picking default value