Re: Commit not required for update statement

From: Evan Bauer <evanbauer(at)mac(dot)com>
To: prasanna rk <prasanna2mail(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Commit not required for update statement
Date: 2018-10-15 02:44:14
Message-ID: 000EB813-E3AC-46A8-9F5B-1B13410909C6@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Autocommit is, by default, off for embedded SQL programs in PostgreSQL 10. The syntax to change that is:

SET AUTOCOMMIT TO ON

Cheers,

- Evan

Evan Bauer
eb(at)evanbauer(dot)com
+1 646 641 2973
Skype: evanbauer

> On Oct 14, 2018, at 22:30, prasanna rk <prasanna2mail(at)gmail(dot)com> wrote:
>
> Hi all
>
> We are running posters 10.4 version, wanted to know if commit statement is not required for update.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Kirkwood 2018-10-15 03:49:38 Re: Commit not required for update statement
Previous Message prasanna rk 2018-10-15 02:30:25 Commit not required for update statement