Re: Debugging SQL queries

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(at)mcnaught(dot)org> wrote:
> Anastasios Hatzis <ahatzis(at)gmx(dot)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