Odd behavior with domains

From: "Joshua D(dot) Drake" <linuxhiker(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Odd behavior with domains
Date: 2016-06-24 02:04:30
Message-ID: 576C952E.3090404@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2016-06-24 02:08:59 tuplesort.c's copytup_index() is dead code
Previous Message Amit Kapila 2016-06-24 02:04:22 Re: Reviewing freeze map code