conversion problems with domains

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема conversion problems with domains
Дата
Msg-id 3E7BAAE6.6090308@web.de
обсуждение исходный текст
Ответы Re: conversion problems with domains  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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=(selectoid from pg_type where typname = 'testdom')           AND attname='testcol'
 

the select will work as expected.






В списке pgsql-hackers по дате отправления:

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: A bad behavior under autocommit off mode
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: A bad behavior under autocommit off mode