Re: Debugging PostgreSql queries

Vaduvoiu Tiberiu <vaduvoiutibi@yahoo.com> writes:
> Long story short, I have a huge query in the application that throws the errror:
> "CASE types bigint and character varying cannot be matched ". I ran
> this query in pgAdmin, in phpPgAdmin, I only get the error but have no
> clue where the error actually is thrown.

This error should include a cursor position if you're working with
server version 8.4 or later.  I infer that you're not.  It'd be worth
trying to install the application on a newer Postgres server.  We
frequently improve the error detection capabilities from one release
to the next, so what was a hard problem might get easier.

            regards, tom lane