Re: Can i see server SQL commands ?
От | tomas@tuxteam.de |
---|---|
Тема | Re: Can i see server SQL commands ? |
Дата | |
Msg-id | 20060928070522.GA31054@www.trapp.net обсуждение исходный текст |
Ответ на | Can i see server SQL commands ? ("Adnan DURSUN" <a_dursun@hotmail.com>) |
Список | 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 по дате отправления: