Odd behavior with domains - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Odd behavior with domains
Date
Msg-id 576C981A.40001@commandprompt.com
Whole thread Raw
Responses Re: Odd behavior with domains  (Corey Huinker <corey.huinker@gmail.com>)
Re: Odd behavior with domains  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Odd behavior with domains  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hey,

So this came across my twitter feed:

https://pbs.twimg.com/media/ClqIJtmXEAA5IGt.png

I have verified the oddness with a newer version:

psql -U postgres
psql (9.5.3)
Type "help" for help.

postgres=# create domain text char(3);
CREATE DOMAIN
postgres=# create domain text char(2);
ERROR:  type "text" already exists
postgres=# \dD             List of domains Schema | Name | Type | Modifier | Check
--------+------+------+----------+-------
(0 rows)

postgres=# create domain textd char(2);
CREATE DOMAIN
postgres=# \dD                 List of domains Schema | Name  |     Type     | Modifier | Check
--------+-------+--------------+----------+------- public | textd | character(2) |          |
(1 row)







pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: tuplesort.c's copytup_index() is dead code
Next
From: Craig Ringer
Date:
Subject: Re: initdb issue on 64-bit Windows - (Was: [pgsql-packagers] PG 9.6beta2 tarballs are ready)