Skip site navigation (1) Skip section navigation (2)

Re: Can i see server SQL commands ?

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Adnan DURSUN <a_dursun(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can i see server SQL commands ?
Date: 2006-09-29 00:56:25
Message-ID: 20060929005624.GP34238@nasby.net (view raw or flat)
Thread:
Lists: 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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-general by date

Next:From: Jim C. NasbyDate: 2006-09-29 01:00:11
Subject: Re: Expected accuracy of planner statistics
Previous:From: Casey DuncanDate: 2006-09-28 22:19:46
Subject: Expected accuracy of planner statistics

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group