Re: Logging statements with errors in PostgreSQL 8.1

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Radcon Entec <radconentec(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Logging statements with errors in PostgreSQL 8.1
Date: 2009-10-26 20:09:20
Message-ID: 4AE601F0.30206@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Radcon Entec wrote:
> Is there any way to get a PostgreSQL 8.1 installation to report the
> statements that caused the error, as the 8.3 installation does?

see
http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
specifically, log_statement, and log_line_prefix
<http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT>

afaik, these options are just about identical from 8.1 to 8.3, so look
at your 8.3 postgresql.conf file, and you should be able to copy those
options to the 8.1 file.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-10-26 20:11:56 Re: Why does pg_dump set default_with_oids to true?
Previous Message Adrian Klaver 2009-10-26 20:08:21 Re: Logging statements with errors in PostgreSQL 8.1