Postgres Pro
Downloads
Home   >   mailing lists

Re: Logging statements with errors in PostgreSQL 8.1 - Mailing list pgsql-general

From John R Pierce
Subject Re: Logging statements with errors in PostgreSQL 8.1
Date
Msg-id 4AE601F0.30206@hogranch.com
Whole thread Raw
In response to Logging statements with errors in PostgreSQL 8.1  (Radcon Entec <radconentec@yahoo.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Logging statements with errors in PostgreSQL 8.1
Next
From: Tom Lane
Date:
Subject: Re: Why does pg_dump set default_with_oids to true?