"Florian G. Pflug" <fgp(at)phlo(dot)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