Re: Can i see server SQL commands ? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Can i see server SQL commands ?
Date
Msg-id 20060929005624.GP34238@nasby.net
Whole thread Raw
In response to Can i see server SQL commands ?  ("Adnan DURSUN" <a_dursun@hotmail.com>)
List 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 by date:

Previous
From: Casey Duncan
Date:
Subject: Expected accuracy of planner statistics
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Expected accuracy of planner statistics