Re: unsupported types in 8.0.1 - Mailing list pgsql-general

From Tom Lane
Subject Re: unsupported types in 8.0.1
Date
Msg-id 14370.1111864486@sss.pgh.pa.us
Whole thread Raw
In response to Re: unsupported types in 8.0.1  (Michael Fuhr <mike@fuhr.org>)
Responses Re: unsupported types in 8.0.1  (Ben <bench@silentmedia.com>)
List pgsql-general
Michael Fuhr <mike@fuhr.org> writes:
> SELECT x FROM foo WHERE x < now()::abstime::integer;
> ERROR:  unsupported type: 23

It looks like examine_variable shouldn't be throwing away the
RelabelType on the now() call ... this code is all new in 8.0
IIRC, which is why you don't see the failure in prior versions
(you also do not get a good estimate ...)

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: unsupported types in 8.0.1
Next
From: Ben
Date:
Subject: Re: unsupported types in 8.0.1