Use BEGIN to open a transaction ( that's the difference to Oracle )
and COMMIT or ROLLBACK to close it.
Antony Paul schrieb:
> Hi all
> How to set autocommit off. I want transactions which requires
> explicit
> commit and after commit a new transaction is started as in Oracle sql
> plus.
> When using start transaction it requires to type start transaction every
> time.
>
> Antony Paul
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org