Re: [pgadmin-hackers] Debugging SQL queries - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: [pgadmin-hackers] Debugging SQL queries
Date
Msg-id 20060523231127.GN64371@pervasive.com
Whole thread Raw
In response to Re: Debugging SQL queries  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
On Thu, May 11, 2006 at 09:39:59AM -0500, Tony Caduto wrote:
> Tom Lane wrote:
> >
> >We have actually removed the "at character N" bit from the default message
> >format in CVS
> >
> Tom,
> What will the error format be for 8.2?   Since the char number has been
> removed, what will it show?
> Line number?

bench=# SELECT blah
bench-# FROMx;
ERROR:  parse error at or near "FROMx"
LINE 2: FROMx;
        ^
bench=#

Note that it's still there in the server logs, though...

ERROR:  parse error at or near "FROMx" at character 13
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: assymetry updating a boolean (=FALSE faster than =TRUE)
Next
From: "Ed L."
Date:
Subject: Re: Why won't it index scan?