Michael Meskes wrote:
>On Thu, Feb 28, 2002 at 01:18:29PM -0500, Antonio Sergio de Mello e Souza wrote:
>
>>By default, Postgres executes transactions in autocommit mode.
>>
>That of course is true.
>
>>To disable the autocommit mode you have to compile the ECPG script with
>>the -t option.
>>
>That unfortunately is not. It's just the opposite way. ecpg per default uses
>the Oracle way and issues a BEGIN after each commit automatically. Thus you
>only have to specify COMMIT every now and then to end the transaction. If
>you use "-t" or SET AUTOCOMMIT ON, then you run in the normal PostgreSQL
>environment and get each command inside its own transaction. To manually
>start and end transactions you have to use "-t" resp. EXEC SQL SET AUTOCOMMIT ON
>and then issue a BEGIN.
>
Many thanks for the explanation! Sorry for the wrong advice... :-(
Regards,
Antonio Sergio