Re: pgAdmin bug? snapshot

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