Skip site navigation (1) Skip section navigation (2)

Re: Debugging PostgreSql queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vaduvoiu Tiberiu <vaduvoiutibi(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Debugging PostgreSql queries
Date: 2010-11-18 15:36:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Vaduvoiu Tiberiu <vaduvoiutibi(at)yahoo(dot)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

In response to

pgsql-novice by date

Next:From: bakkiyaDate: 2010-11-19 14:17:17
Subject: Re: Could not open relation with OID (table partitioning issue?)
Previous:From: Greg Sabino MullaneDate: 2010-11-18 15:16:31
Subject: Re: MySql week() method equivalent

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group