Re: Unrecognized type error (postgres 9.1.4) - Mailing list pgsql-hackers

Rodrigo Barboza <rodrigombufrj@gmail.com> writes:
> UPDATE tm32 SET a = a + 1 WHERE a > $i;
> ERROR: unsupported type: 202886

I'm betting that's coming from scalargtsel, which doesn't know anything
about your type, but you've nominated it to be the selectivity function
for ">" anyway.
/* * Can't get here unless someone tries to use scalarltsel/scalargtsel on * an operator with one numeric and one
non-numericoperand. */elog(ERROR, "unsupported type: %u", typid);
 
        regards, tom lane