Hi Greg,
Instead of using psql to get the NOTICES, when I program in PL/pgSQL, I
start the database with -d 2 (debug level of 2) and this forces the
NOTICES into the PostgreSQL log file.
Then, I just have a telnet/ssh/etc session on the server running :
tail -f postgresql.log
So I constantly have access to the NOTICES which PostgreSQL generates,
regardless of how I'm hitting it.
Would this be useful to you?
:-)
Regards and best wishes,
Justin Clift
Gregory Wood wrote:
>
> I'm partial to the ZEOS Database Explorer myself. I don't have experience
> with a multitude of tools, so the best I can offer is that I have no
> problems with the latest version :) Actually, I can tell you that it has the
> advantage of a native interface (rather than relying on ODBC). And it's
> free, that's always an advantage.
>
> Oh, and it does have the disadvantage of not showing NOTICEs, which is a
> pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to
> use psql. There were some problems in older versions (specifically it was
> having trouble stripping out spaces on newlines and with quoting on
> triggers), but those problems seem to be resolved with the latest version.
> It's not the most stable program, but most people don't use Windows for
> stability...
>
> Address is http://www.zeoslib.org/ but it appears to be down at the moment.
>
> Greg
>
> ----- Original Message -----
> From: "Walter Chong" <mail2walter@yahoo.com>
> To: <pgsql-general@postgresql.org>
> Sent: Friday, May 11, 2001 11:03 PM
> Subject: What's the best front end/client under MS Windows?
>
> > Kindly list the advantages/disadvantages for me, THX!
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi