Re: pgAdmin bug? snapshot - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAdmin bug? snapshot
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B872001E@mail.vale-housing.co.uk
Whole thread Raw
Responses Re: pgAdmin bug? snapshot
List pgadmin-support
[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.


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: pgAdmin bug? creating functions
Next
From: "Dave Page"
Date:
Subject: Re: pgAdmin bug? snapshot