Re: [HACKERS] Can i see server SQL commands ?

[tomas]

-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 [EMAIL PROTECTED] 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-


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[HACKERS] Can i see server SQL commands ?

[Adnan DURSUN]

   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 ?

   Best regards

Adnan DURSUN
ASRIN Bilişim Ltd. 



---(end of broadcast)---
TIP 6: explain analyze is your friend