Thread: Re: pgAdmin bug? snapshot

Re: pgAdmin bug? snapshot

From
"Dave Page"
Date:
[Please keep messages on list]

> -----Original Message-----
> From: Michael Shapiro [mailto:mshapiro@ncsa.uiuc.edu]
> Sent: 19 November 2003 10:23
> To: Dave Page
> Subject: Re: [pgadmin-support] pgAdmin bug? snapshot
>
> I change it from time to time. I can set it to the highest
> level and then connect and send you the log file. Would that
> be useful?

I was thinking that if you had it on full debug that would certainly
slow down the connection. I see no speed issues with CVS tip here.

> Now that you mention logging, I see that when I do a RAISE
> NOTICE in a function, PgAdmin will show the notice in the
> messages window, but if I do RAISE DEBUG, it does not. Where
> do RAISE DEBUG messages go?

By default they are hidden. Try running:

SET client_min_messages = 'DEBUG1'

Or similar at the beginning of your SQL session. See
http://www.postgresql.org/docs/7.4/static/runtime-config.html for more
details of client_min_messages.

You can also preset variables like this on a per database or per user
basis in the appropriate properties dialogue.

Regards, Dave.


Re: pgAdmin bug? snapshot

From
Andreas Pflug
Date:
Dave Page wrote:

>>E DEBUG, it does not. Where 
>>do RAISE DEBUG messages go?
>>    
>>
>
>By default they are hidden. Try running:
>
>SET client_min_messages = 'DEBUG1'
>
>Or similar at the beginning of your SQL session. See
>http://www.postgresql.org/docs/7.4/static/runtime-config.html for more
>details of client_min_messages.
>
>You can also preset variables like this on a per database or per user
>basis in the appropriate properties dialogue.
>  
>

Do we need some more query tool options to automatically set things like 
this? Are there more candidates?

Regards,
Andreas