Richard, Jiang,
> I *think* you want DEBUG_PRINT_QUERY and its friends. See Ch 3.4.2 of
> the
> Administrators Guide.
Actually, Jiang need to re-start the postmaster with the command-line
options for logging set. Annoyingly, the default init.d script for
Postgres in most RPMs starts Postgres without any logging.
Unfortunately, I'm at a remote terminal right now, so I can't post an
example.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco