Re: Debugging SQL queries

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: Debugging SQL queries
Дата
Msg-id e431ff4c0605110608w6041cfcbrc51656e49d9f5a52@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Debugging SQL queries  (Douglas McNaught <doug@mcnaught.org>)
Ответы Re: Debugging SQL queries  ("chris smith" <dmagick@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Berend Tober
Дата:
Сообщение: Re: Feature-Request: Login-Procedure
Следующее
От: "chris smith"
Дата:
Сообщение: Re: Debugging SQL queries