Re: A maybe-bug?

Vincenzo Romano <vincenzo.romano@notorand.it> writes:
> I tried this:
> tmp1=# CREATE DOMAIN real as numeric;
> [ and got confused between this domain and the built-in "real" ]

> It looks like to me this is a bug and also the documentation seems to confirm:
> "The domain name must be unique among the types and domains existing
> in its schema."

No bug.  The REAL keyword is treated as an alias for pg_catalog.float4,
but even if it weren't an alias, it would exist in schema pg_catalog.
Thus there is not a name conflict with your domain, which (I suppose)
was created in the "public" schema.

            regards, tom lane