My Deja wrote:
I am trying to get some query trees to appear in the PostgreSQL log and in order to that I have set
client_min_messages = DEBUG1 in order to use the following settings
debug_print_parse, debug_print_rewritten, or debug_print_plan which are required for the query tree to show up in the log.
pgAdmin crashes whenever I set that option. I tried a few times and I am sure of it.
I am using PostgreSQL 7.4 under Cygwin on a Windows 2000 machine, but I don't think that has any relevance.
I can confirm this problem. Apparently the flood of debug notices will kill pgAdmin3 after a while.
I'll have a deeper look into this later. Until then, do *not* set these options in postgresql.conf. Instead, set these options per user (if you want to observe a user *different* from the one you're using with pgAdmin3), or set these options in the query tool prior to executing your queries to inspect.
How are these options set in the query tool? I can see Explain Options -Verbose/Analyze on the menu. Which one of these does the trick?
Thanks for the reply
My Deja
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
