From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
---|---|
To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: unrecognized configuration parameter "autocommit" |
Date: | 2016-04-04 21:34:35 |
Message-ID: | CACjxUsMwBh_vrE5bmpY+CqWgNnd4B3ewW0o-n+oVG3bi1FnSjg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sat, Apr 2, 2016 at 6:24 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
> I am testing an upgrade to a database from version 9.3 (this version is
> working fine) to 9.5 and I am getting the following error:
>
> *** unrecognized configuration parameter "autocommit" ***
>
> I have read that I should set autocommit to off but I do not know how to do
> it. I already reviewed all of the settings in the configuration file
> (postgresql.conf) and I do not see such parameter.
>
> I, in fact, found the following information in PostgreSQL documentation:
> http://www.postgresql.org/docs/9.5/static/ecpg-sql-set-autocommit.html
That is in the documentation of the ECPG connector. The *server*
and its configuration files have no concept of autocommit, although
connectors and applications sometimes do.
Don't put an autocommit line in the server configuration file(s).
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Kurt R Marquardt | 2016-04-05 12:14:31 | Creating a limits table |
Previous Message | Merlin Moncure | 2016-04-04 15:22:33 | Re: Postgresql - Inline comment in VIEW Sql definition |