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

From tomas@tuxteam.de
Subject Re: Can i see server SQL commands ?
Date
Msg-id 20060928070522.GA31054@www.trapp.net
Whole thread Raw
In response to Can i see server SQL commands ?  ("Adnan DURSUN" <a_dursun@hotmail.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Sep 28, 2006 at 04:27:36AM +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..."

Adnan,

this mailing list is not the right one for such questions. More
appropriate would be <pgsql-novice@postgresql.org> or maybe
<pgsql-general@postgresql.org>.

Having said that, you may set the log level of the server in the
configuration file (whose location depends on your OS and PostgreSQL
version. Look there for a line log_statements = XXX and set XXX to
'all'. Don't forget to restart your server afterwards.

HTH
- -- tomas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFG3QyBcgs9XrR2kYRAgdqAJ0VnUw5+Q79HiIwHocHIw4TWHePaQCffBBK
ASn3Z6XpKG91NTrmEaBtz08=
=Ibh3
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Transaction is read-only in auto commit mode
Next
From: Csaba Nagy
Date:
Subject: Re: [OT]DROP FUNCTION IF EXISTS