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.