On Thu, Jun 23, 2016 at 10:16 PM, Joshua D. Drake <j...@commandprompt.com> wrote:
> 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) > > > It's there. # create domain text char(3); CREATE DOMAIN labels_search=# \dD public.text List of domains Schema | Name | Type | Modifier | Check --------+------+--------------+----------+------- public | text | character(3) | | (1 row) I've noticed the same thing when creating types that mask an existing catalog type.
