Re: I'm getting "ERROR: unsupported type: 17296"

"Florian G. Pflug" <fgp@phlo.org> writes:
> I'm running postgresql 8.0.2 on Linux.
> When I do
> select * from datagraph."MyTable" where "KC" like "TTT%"
> , postgres responds with "ERROR:  unsupported type: 17296".

If KC is a domain type, you need to update to 8.0.4.

2005-06-01 13:05  tgl

    * src/backend/utils/adt/selfuncs.c (REL8_0_STABLE): patternsel()
    was improperly stripping RelabelType from the derived expressions
    it constructed, causing scalarineqsel to become confused if the
    underlying variable was of a domain type.  Per report from Kevin
    Grittner.

            regards, tom lane