"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> Shouldn't it be an error to create a domain that conflicts with an existing
> type?
It is, if you create it in the same schema. "money", along with all the
other built-in types, is in pg_catalog not public.
regards, tom lane
-
On Wed, May 24, 2006 at 05:29:34PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I know domain support is pretty broken, so maybe this is a known issue...
>
> What are you concerned about exactly? It looks perfectly reasonable
> to me. "money" is a base type not a domai
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I know domain support is pretty broken, so maybe this is a known issue...
What are you concerned about exactly? It looks perfectly reasonable
to me. "money" is a base type not a domain.
regards, tom lane
-
I know domain support is pretty broken, so maybe this is a known issue...
decibel=# create table test(m money);
CREATE TABLE
decibel=# insert into test values('-1.00');
INSERT 0 1
decibel=# alter domain money add check(money>0);
ERROR: "money" is not a domain
decibel=# drop domain money;
ERRO
