AUTO COMMIT

From: Atif Jung <atifjung(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: AUTO COMMIT
Date: 2010-06-28 14:56:51
Message-ID: AANLkTimy-_cwNMYVZas3vUUh9Yp3iaG_Zu17FbGPoz4-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

The postgres manual states:

"In the default mode, statements are committed only when EXEC SQL COMMIT is
issued. The embedded SQL interface also supports autocommit of transactions
(similar to libpq behavior) via the -t command-line option to ecpg (see
below) or via the EXEC SQL SET AUTOCOMMIT TO ON statement. In autocommit
mode, each command is automatically committed unless it is inside an
explicit transaction block. This mode can be explicitly turned off using EXEC
SQL SET AUTOCOMMIT TO OFF."

I've used the -t command-line option when compiling my code, and AUTOCOMMIT
is set, but I still get the following error message when declaring a cursor:

DECLARE CURSOR can only be used in transaction blocks.

What am I doing wrong?

Thanks

Atif

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Atif Jung 2010-06-28 15:45:32 Re: DECLARE CURSOR
Previous Message Tom Lane 2010-06-28 14:00:17 Re: DECLARE CURSOR