Skip site navigation (1) Skip section navigation (2)

Re: "blah" is not a domain error

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: "blah" is not a domain error
Date: 2006-05-26 21:44:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Wed, May 24, 2006 at 05:29:34PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jnasby(at)pervasive(dot)com> 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.

Oops... I thought we'd removed it.

Shouldn't it be an error to create a domain that conflicts with an existing

bench=# create domain money as numeric(21,2);
bench=# drop domain money;
ERROR:  "money" is not a domain
bench=# create domain money as numeric(21,2);
ERROR:  type "money" already exists
bench=# select version();
 PostgreSQL 8.2devel on x86_64-unknown-freebsd6.0, compiled by GCC gcc (GCC) 3.4.4 [FreeBSD] 20050518
(1 row)

Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software    work: 512-231-6117
vcard:       cell: 512-569-9461

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2006-05-26 23:24:50
Subject: Re: "blah" is not a domain error
Previous:From: Tom LaneDate: 2006-05-26 21:11:03
Subject: Re: BUG #2455: psql failing to restore a table because of a constaint violation.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group