Re: ERROR: type "i" does not exist

On Tue, Nov 14, 2006 at 01:20:38PM -0800, Don Laurine wrote:
> In the postgres log I am getting the following:
>
> ERROR: type "i" does not exist
>
> What is the cause of this error and/or how do I track it down?

One possibility is that a query is trying to cast a value to the
"i" type, either intentionally or due to a syntax error. Maybe the
word "integer" is being truncated or maybe bit of code from a
language other than SQL is sneaking into a query. Example:

test=> SELECT 1::i;
ERROR: type "i" does not exist

See "Error Reporting and Logging" in the documentation for information
about logging. One way to identify the offending query would be
to set log_min_error_statement = error in postgresql.conf and reload
the server.

http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html

--
Michael Fuhr