conversion problems with domains

From: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: conversion problems with domains
Date: 2003-03-22 00:14:30
Message-ID: 3E7BAAE6.6090308@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

PostgreSQL 7.3.2

CREATE DOMAIN testdom AS int4;
CREATE TABLE testtab(testcol testdom);
INSERT INTO testtab VALUES (1);
INSERT INTO testtab VALUES (2);
VACUUM ANALYZE testtab;

SELECT * FROM testtab WHERE testcol > 1;

The select will give
"ERROR: convert_numeric_to_scalar: unsupported type 3381436"

If no VACUUM ANALYZE is performed (no entry in pg_stats), the select
will work ok.
The select will also succeed, if testcol is compared to something
different from 1.

Defining a cast
CREATE CAST(testdom as int4) WITHOUT FUNCTION AS IMPLICIT
doesn't help.

If I change the datatype

UPDATE pg_attribute
SET atttypid=(select oid from pg_type where typname = 'int4')
WHERE atttypid=(select oid from pg_type where typname = 'testdom')
AND attname='testcol'

the select will work as expected.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-22 01:48:17 Re: A bad behavior under autocommit off mode
Previous Message Barry Lind 2003-03-21 23:47:47 Re: A bad behavior under autocommit off mode