Re: Can i see server SQL commands ?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Can i see server SQL commands ?
Дата
Msg-id 20060929005624.GP34238@nasby.net
обсуждение исходный текст
Ответ на Can i see server SQL commands ?  ("Adnan DURSUN" <a_dursun@hotmail.com>)
Список pgsql-general
On Thu, Sep 28, 2006 at 01:27:24PM +0300, Adnan DURSUN wrote:
>        Hi all
>
>        I wanna know what is going on while a DML command works. For example
> ;
>        Which commands are executed by the core when we send an "UPDATE tab
> SET col = val1..."
>        in case there is a foreing key or an unique constraint on table
> "tab".
>
>        How can i see that ?

Didn't someone just ask this yesterday?

I believe you can get that info by increasing client_min_messages.
What you specifically have to set it to I don't know; my guess would be
log or debug1.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: Casey Duncan
Дата:
Сообщение: Expected accuracy of planner statistics
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Expected accuracy of planner statistics