Re: Odd behavior with domains
| От | Corey Huinker |
|---|---|
| Тема | Re: Odd behavior with domains |
| Дата | |
| Msg-id | CADkLM=eC6OEDEPg5Vw=Nm1sgKnLXf0UaM0RDDhJqb5Y3siNr6g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Odd behavior with domains ("Joshua D. Drake" <jd@commandprompt.com>) |
| Список | pgsql-hackers |
On Thu, Jun 23, 2016 at 10:16 PM, Joshua D. Drake <jd@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.
В списке pgsql-hackers по дате отправления: