Re: [HACKERS] Odd behavior with domains

2016-06-24 Thread Robert Haas
On Thu, Jun 23, 2016 at 11:00 PM, Alvaro Herrera wrote: > Well, it's not specifically related to domains -- it's related to the > fact that pg_catalog objects mask the domain you created in the public > schema, because pg_catalog is by default in front of all other schemas > unless you explicitely

Re: [HACKERS] Odd behavior with domains

2016-06-24 Thread Alvaro Herrera
Joshua D. Drake wrote: > Yes but what makes it weird is this: > > postgres=# create domain text char(3); > CREATE DOMAIN > > -- cool, no problem > > postgres=# create domain text char(2); > ERROR: type "text" already exists > > -- as expected > > postgres=# \dD > List of domains

Re: [HACKERS] Odd behavior with domains

2016-06-24 Thread David G. Johnston
On Fri, Jun 24, 2016 at 1:08 PM, Joshua D. Drake wrote: > On 06/23/2016 08:00 PM, Alvaro Herrera wrote: > >> Joshua D. Drake wrote: >> >>> Hey, >>> >>> So this came across my twitter feed: >>> >>> https://pbs.twimg.com/media/ClqIJtmXEAA5IGt.png >>> >>> I have verified the oddness with a newer ver

Re: [HACKERS] Odd behavior with domains

2016-06-24 Thread Joshua D. Drake
On 06/23/2016 08:00 PM, Alvaro Herrera wrote: Joshua D. Drake 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: Well, it's not specifically related to domains -- it's related to the fact that pg

Re: [HACKERS] Odd behavior with domains

2016-06-23 Thread Justin Dearing
I was the one that reported that on twitter. I have a more detailed message on the general list that I sent before subscribing and probably needs to be moderated (or if it went to /dev/null let me know). On Thu, Jun 23, 2016 at 11:01 PM Tom Lane wrote: > "Joshua D. Drake" writes: > > So this ca

Re: [HACKERS] Odd behavior with domains

2016-06-23 Thread Tom Lane
"Joshua D. Drake" writes: > So this came across my twitter feed: > https://pbs.twimg.com/media/ClqIJtmXEAA5IGt.png public.text can exist in parallel with pg_catalog.text. Nothing to see here, move along. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-

Re: [HACKERS] Odd behavior with domains

2016-06-23 Thread Alvaro Herrera
Joshua D. Drake 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: Well, it's not specifically related to domains -- it's related to the fact that pg_catalog objects mask the domain you

Re: [HACKERS] Odd behavior with domains

2016-06-23 Thread Corey Huinker
On Thu, Jun 23, 2016 at 10:16 PM, Joshua D. Drake 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 doma