Re: Debugging SQL queries - Mailing list pgsql-general

From Nikolay Samokhvalov
Subject Re: Debugging SQL queries
Date
Msg-id e431ff4c0605110608w6041cfcbrc51656e49d9f5a52@mail.gmail.com
Whole thread Raw
In response to Re: Debugging SQL queries  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: Debugging SQL queries  ("chris smith" <dmagick@gmail.com>)
List pgsql-general
From my point of view, more important problem is that log doesn't help
to find the query (in other words, log message doesn't show context)

On 5/11/06, Douglas McNaught <doug@mcnaught.org> wrote:
> Anastasios Hatzis <ahatzis@gmx.net> writes:
>
> > My problem is that I don't know where the given character number is
> > inside the query/file. I can search in my code editors (e.g. those of
> > Eclipse IDE) for line number + character number in given line
> > number... but I can not search for an overall character
> > number.
>
> Emacs has the "goto-char" function and runs on Windows, so you could
> use that (there are probably other editors with this feature as
> well)..
>
> -Doug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>



--
Best regards,
Nikolay

pgsql-general by date:

Previous
From: Berend Tober
Date:
Subject: Re: Feature-Request: Login-Procedure
Next
From: "chris smith"
Date:
Subject: Re: Debugging SQL queries