Re: Debugging SQL queries

Поиск
Список
Период
Сортировка
От chris smith
Тема Re: Debugging SQL queries
Дата
Msg-id 3c1395330605110614r5c09030coce8768c06f32101c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Debugging SQL queries  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Список pgsql-general
On 5/11/06, Nikolay Samokhvalov <samokhvalov@gmail.com> wrote:
> 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)

Yes it does.. but it depends on your logging setup.

in psql:

test=# blah;
ERROR:  syntax error at or near "blah" at character 1

my log shows:

... [9-1] LOG:  statement: blah;
... [10-1] ERROR:  syntax error at or near "blah" at character 1

Do you have:

log_statement = true

in your postgresql.conf ?

--
Postgresql & php tutorials
http://www.designmagick.com/

В списке pgsql-general по дате отправления:

Предыдущее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: Debugging SQL queries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recovery problem with PostgreSQL