From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | A maybe-bug? |
Date: | 2010-01-07 09:17:46 |
Message-ID: | 3eff28921001070117k448bdbf4kaa234e8c9af22fde@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all!
I tried this:
tmp1=# CREATE DOMAIN real as numeric;
CREATE DOMAIN
tmp1=# CREATE TABLE t1 ( r real );
CREATE TABLE
tmp1=# CREATE TABLE t2 ( r "real" );
CREATE TABLE
tmp1=# INSERT INTO t1 VALUES ( 0.000000000000000000000000000001 );
INSERT 0 1
tmp1=# INSERT INTO t1 VALUES (
0.00000000000000000000000000000000000000000000001 );
ERROR: value out of range: underflow
tmp1=# INSERT INTO t2 VALUES ( 0.000000000000000000000000000001 );
INSERT 0 1
tmp1=# INSERT INTO t2 VALUES (
0.00000000000000000000000000000000000000000000001 );
INSERT 0 1
tmp1=#
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."
Any idea?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
From | Date | Subject | |
---|---|---|---|
Next Message | Konrad Garus | 2010-01-07 10:12:24 | Rows missing from table despite FK constraint |
Previous Message | Craig Ringer | 2010-01-07 09:08:17 | Re: How many records to delete ? |