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

Started by Florian Pflugover 20 years ago2 messagesgeneral
Jump to latest
#1Florian Pflug
fgp@phlo.org

Hi

I'm running postgresql 8.0.2 on Linux.

In one of our databases we have a table (lets call it
datagraph."MyTable", the real name is german), that
includes a field (called "KC") of type datagraph."Char".
datagraph."Char" is a subtype of varchar, created with
create domain datagraph."Char" as varchar.

When I do
select * from datagraph."MyTable" where "KC" like "TT%"
everything works fine.

When I do
select * from datagraph."MyTable" where "KC" like "TTT%"
, postgres responds with "ERROR: unsupported type: 17296".
There is an index on this column, but the error still
happens, even when I drop the index.

Type 17296 is my datagraph."Char" type - it looks like this in
pg_type:

typname: Char
typnamespace: 17231
typowner: 100
typlen: -1
typbyval: f
typtype: d
typisdefined: t
typdelim: ,
typrelid: 0
typelem: 0
typinput: varcharin
typoutput: varcharout
typreceive: varcharrecv
typsend: varcharsend
typanalyze: -
typalign: i
typstorage: x
typnotnull: f
typbasetype: 1043
typtypmod: -1
typndims: 0
typdefaultbin:
typdefault:

If I try creating a similar typ, and a table containing this typ
in another database on the same host, I can't reproduce the bug.. :-(

Any ideas?

greetings, Florian Pflug

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Florian Pflug (#1)
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