Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin bug? snapshot

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Michael Shapiro" <mshapiro(at)ncsa(dot)uiuc(dot)edu>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin bug? snapshot
Date: 2003-11-19 10:48:55
Message-ID: 03AF4E498C591348A42FC93DEA9661B872001E@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
[Please keep messages on list]

> -----Original Message-----
> From: Michael Shapiro [mailto:mshapiro(at)ncsa(dot)uiuc(dot)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.

Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-11-19 14:57:10
Subject: Re: pgAdmin bug? snapshot
Previous:From: Dave PageDate: 2003-11-18 09:58:02
Subject: Re: pgAdmin bug? creating functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group