Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
