From: | My Deja <mydeja(at)achimota(dot)com> |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin crashes when client_min_messages is |
Date: | 2004-01-02 02:48:14 |
Message-ID: | 3FF4DBEE.9040904@achimota.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support pgsql-patches |
Andreas Pflug wrote:
> 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 majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-01-02 08:48:58 | Re: pgAdmin crashes when client_min_messages is |
Previous Message | Dave Page | 2003-12-29 08:12:01 | Re: [HELP bug] (control lost) while in create table |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-01-02 08:48:58 | Re: pgAdmin crashes when client_min_messages is |
Previous Message | Jean-Michel POURE | 2003-12-31 16:44:43 | Re: RedHat 8.0 error "Gdk-WARNING.." |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-01-02 08:48:58 | Re: pgAdmin crashes when client_min_messages is |
Previous Message | Andrew Dunstan | 2003-12-31 14:12:43 | Re: pg_usleep |