Обсуждение: Odd behavior with domains

Поиск
Список
Период
Сортировка

Odd behavior with domains

От
"Joshua D. Drake"
Дата:
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)