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

Re: Can i see server SQL commands ?

From: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can i see server SQL commands ?
Date: 2006-09-29 02:17:30
Message-ID: BAY106-DAV58E76BEB6EA5DE5A035D7FA180@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-general
----- Original Message ----- 
From: "Jim C. Nasby" <jim(at)nasby(dot)net>

> Didn't someone just ask this yesterday?

    Yes. i did it :-)

> 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.

    I set it that but none of them effect the result :-( I think, answer to 
this question is no !
Things that i want to see is what SQL commands run by backend while ;

    * Inserting a row (how checks FKs)
    * Updating row (how checks FKs and unique constrains)
    * deleting row (how checks FKs)

Best Regards


In response to


pgsql-general by date

Next:From: Tom LaneDate: 2006-09-29 03:13:24
Subject: Re: Row versions and indexes
Previous:From: Jim C. NasbyDate: 2006-09-29 01:00:11
Subject: Re: Expected accuracy of planner statistics

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