Re: Logging prepared statements in 8.1?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Logging prepared statements in 8.1?
Дата
Msg-id 200511261824.jAQIOlj02260@candle.pha.pa.us
обсуждение исходный текст
Ответ на Logging prepared statements in 8.1?  (Bjørn T Johansen <btj@havleik.no>)
Список pgsql-general
Bj�rn T Johansen wrote:
> I am upgrading from 7.4 to 8.1 and there seems to have been a change
> in how postgresql log prepared sql statements.. Before I could see the
> actual statements (i.e. after every parameters had been changed with
> real values) but now I see the sql statements before the change (i.e
> with $1, $2 as parameters)..
>
> Is there a way to see the actual statements in 8.1?

Uh, not sure.  Perhaps the interface wasn't using real prepared
statements, but now it is.  I am not aware we ever output the query with
the parameters in place.  8.1 logs prepared statements while in previous
releases it didn't properly.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: Resend: Question about PostgreSQL, pgpool, and Postfix
Следующее
От: Gregory Youngblood
Дата:
Сообщение: Re: Resend: Question about PostgreSQL, pgpool, and