Thread: Re: pgAdmin bug? snapshot

Re: pgAdmin bug? snapshot

From
"Dave Page"
Date:

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 19 November 2003 14:57
> To: Dave Page
> Cc: Michael Shapiro; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] pgAdmin bug? snapshot
>
> 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?

enable_seqscan et al. spring instantly to mind given your intended use
for the tool (optimising queries). Also planner cost constants, Geqo
etc.

Regards, Dave.