> -----Original Message----- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 19 November 2003 14:57 > To: Dave Page > Cc: Michael Shapiro; [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings