Debugging PostgreSql queries - Mailing list pgsql-novice

From Vaduvoiu Tiberiu
Subject Debugging PostgreSql queries
Date
Msg-id 752653.85569.qm@web51301.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Debugging PostgreSql queries
Re: Debugging PostgreSql queries
List pgsql-novice
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. In mysql most of the time you get a "on line X" message in the error that can help you determine where the problem is. However in my case, since I didn't create the query( so I don't know the tables, fields, etc) and the query is very big, is there a way to find out where exactly where is this query thrown or do I have to manually start searching?

10x a lot

pgsql-novice by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Actual Table Data
Next
From: Matthew Walden
Date:
Subject: Re: Debugging PostgreSql queries