From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | "blah" is not a domain error |
Date: | 2006-05-24 21:18:24 |
Message-ID: | 20060524211823.GJ59464@pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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;
ERROR: "money" is not a domain
decibel=# \dD
List of domains
Schema | Name | Type | Modifier | Check
--------+------+------+----------+-------
(0 rows)
decibel=# \d test
Table "public.test"
Column | Type | Modifiers
--------+-------+-----------
m | money |
decibel=# create domain money as numeric(99,2);
ERROR: type "money" already exists
decibel=# select version();
version
-------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.2 on powerpc-apple-darwin8.4.0, compiled by GCC powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 20041026 (Apple Computer, Inc. build 4061)
(1 row)
decibel=#
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-24 21:21:02 | Re: BUG #2452: Error w/ pg_restore and blobs |
Previous Message | Robert Treat | 2006-05-24 13:34:52 | BUG #2452: Error w/ pg_restore and blobs |