Postgres Pro
Downloads
Home   >   mailing lists

Re: Commit not required for update statement - Mailing list pgsql-admin

From Evan Bauer
Subject Re: Commit not required for update statement
Date
Msg-id 000EB813-E3AC-46A8-9F5B-1B13410909C6@mac.com
Whole thread Raw
In response to Commit not required for update statement  (prasanna rk <prasanna2mail@gmail.com>)
List pgsql-admin
Tree view 
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@evanbauer.com
+1 646 641 2973
Skype: evanbauer


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

pgsql-admin by date:

Previous
From: prasanna rk
Date:
Subject: Commit not required for update statement
Next
From: Mark Kirkwood
Date:
Subject: Re: Commit not required for update statement