Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gBssR-0005gO-92
	for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 02:45:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gBssO-0007wz-8D
	for pgsql-admin@arkaria.postgresql.org; Mon, 15 Oct 2018 02:45:00 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <evanbauer@mac.com>)
	id 1gBssN-0007ws-TA
	for pgsql-admin@lists.postgresql.org; Mon, 15 Oct 2018 02:45:00 +0000
Received: from st11p00im-asmtp003.me.com ([17.172.80.97])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <evanbauer@mac.com>)
	id 1gBssG-0002HM-9g
	for pgsql-admin@postgresql.org; Mon, 15 Oct 2018 02:44:58 +0000
Received: from process-dkim-sign-daemon.st11p00im-asmtp003.me.com by
 st11p00im-asmtp003.me.com
 (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31
 2018)) id <0PGM00800CWKW800@st11p00im-asmtp003.me.com> for
 pgsql-admin@postgresql.org; Mon, 15 Oct 2018 02:44:16 +0000 (GMT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=04042017;
	t=1539571456; bh=Q5n7l0sgeeUevKEHsnxKpen5NLiXGlpwQAfFnB+5K7Q=;
	h=Content-type:MIME-version:Subject:From:Date:Message-id:To;
	b=NlF9jnkbnPmClIQnsl8dUiLa3pDFdmTmIElrOu/1rr+EfZ+yLb/LtQ3Sbd8grTW3s
 o6DaXU231iJm/jJHYPnr4/dQI5zSvApBxjAiVcgNYXvQqIdZ6aZbLPnB7HMpDxiZAm
 FB29xTU1GKQ9xdJ09J8EU2S4yb/b6fWILxGMOhs9VizntPvURQxZEB8O31jeU04J8x
 GWnl6mYt3XrSwqYphJUoB5cNs+YAFRUzB6XsgjBswq8Jc424X1xuNBdbEGEfF/WHQt
 v8tWsNcAaqEqdn2OE29kDmfe6fvIWIbNTqZ2BGqqzaOrOEyDX+D3iNgAUhf24Gt5VE
 h/LHAYgZ1IJ8w==
Received: from icloud.com ([127.0.0.1]) by st11p00im-asmtp003.me.com
 (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31
 2018)) with ESMTPSA id <0PGM00KP3CXQ0J10@st11p00im-asmtp003.me.com>; Mon,
 15 Oct 2018 02:44:16 +0000 (GMT)
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 suspectscore=0
 malwarescore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 mlxscore=0
 mlxlogscore=994 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.0.1-1807170000 definitions=main-1810150025
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,,
 definitions=2018-10-15_02:,, signatures=0
Content-type: text/plain; charset=us-ascii
MIME-version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\))
Subject: Re: Commit not required for update statement
From: Evan Bauer <evanbauer@mac.com>
In-reply-to: 
 <CADzxCadxXc8s-8Kv3V0gTx17M6OY2npQihqsR8RO=4xPo05XZA@mail.gmail.com>
Date: Sun, 14 Oct 2018 22:44:14 -0400
Cc: pgsql-admin@postgresql.org
Content-transfer-encoding: quoted-printable
Message-id: <000EB813-E3AC-46A8-9F5B-1B13410909C6@mac.com>
References: 
 <CADzxCadxXc8s-8Kv3V0gTx17M6OY2npQihqsR8RO=4xPo05XZA@mail.gmail.com>
To: prasanna rk <prasanna2mail@gmail.com>
X-Mailer: Apple Mail (2.3445.9.1)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

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:
>=20
> Hi all
>=20
> We are running posters 10.4 version, wanted to know if commit =
statement is not required for update.