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

Re: [GENERAL] Debugging SQL queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: Anastasios Hatzis <ahatzis(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Debugging SQL queries
Date: 2006-05-11 14:56:20
Message-ID: 6754.1147359380@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-general
Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> Tom Lane wrote:
>> We have actually removed the "at character N" bit from the default message format in CVS
>> 
> What will the error format be for 8.2?

In CVS tip you just see

regression=# select 1 2;
ERROR:  syntax error at or near "2"
LINE 1: select 1 2;
                 ^
regression=#

We still include "at character N" if the message is written to the
server log, but the "primary message text" field of the error report
sent to the client doesn't have it any more.  This could still be
revisited if anyone's really unhappy about it, but ISTM that if the
client app is holding up its end about using the error-position field,
putting it in the text is just clutter.

			regards, tom lane

In response to

Responses

pgadmin-hackers by date

Next:From: Tony CadutoDate: 2006-05-11 15:14:23
Subject: Re: Debugging SQL queries
Previous:From: Tony CadutoDate: 2006-05-11 14:39:59
Subject: Re: [GENERAL] Debugging SQL queries

pgsql-general by date

Next:From: Scott MarloweDate: 2006-05-11 14:59:44
Subject: Re: Feature-Request: Login-Procedure
Previous:From: Shoaib MirDate: 2006-05-11 14:56:04
Subject: Re: Recovery problem with PostgreSQL

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