Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-23 Thread Jim C. Nasby
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? >

Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-17 Thread Tony Caduto
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? Thanks, -- Tony Caduto AM Software Design http://www.amsoftwared

Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-11 Thread Wayne Conrad
On Thu, May 11, 2006 at 10:56:20AM -0400, Tom Lane wrote: > 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. Will the text returned by PQerrorMessage still includ

Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-11 Thread Tom Lane
Tony Caduto <[EMAIL PROTECTED]> 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: selec

Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-11 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 11 May 2006 15:00 > To: Anastasios Hatzis > Cc: pgsql-general@postgresql.org; pgadmin-hackers@postgresql.org > Subject: Re: [GENERAL] Debugging SQL queries > > pgAdmin needs to cat

Re: [pgadmin-hackers] [GENERAL] Debugging SQL queries

2006-05-11 Thread Tom Lane
Anastasios Hatzis <[EMAIL PROTECTED]> writes: > I have sometimes very long queries, for example in setup-purposed sql > file where plenty of tables of a new database are created in a single > transaction. 600 lines of code or more is common. Sometimes, while > developing, an error may appear aft