pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReg:Autocommit
9+ messages / 4 participants
[nested] [flat]
* Reg:Autocommit
@ 2015-07-25 05:51 Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Shreeyansh Dba @ 2015-07-25 05:51 UTC (permalink / raw)
To: pgsql-admin
Hi All,
Can u help me, Is their any option to "Autocommit to keep off " in
PostgreSQL
Any how By default "autocommit is on"
So i need to keep autocommit off, can anyone guide me to keep the
"autocommit=off"
Thanks & Regards,
Neeraj
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-25 06:10 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Shreeyansh Dba @ 2015-07-25 06:10 UTC (permalink / raw)
To: pgsql-admin
Hi All,
Sorry for keeping Repeat mail, I didn't mention the Error what i am
getting
This is the Error mentioned below.
* postgres=#*
*set autocommit to off; ERROR: SET AUTOCOMMIT TO OFF is no longer
supported*
* postgres=#*
Can u help me, Is their any option to "Autocommit to keep off " in
PostgreSQL9.4,
Anyhow By default "autocommit is on".
So i need to keep autocommit off, can anyone guide me to keep the
"autocommit=off".
Thanks & Regards,
Neeraj.
On Sat, Jul 25, 2015 at 11:21 AM, Shreeyansh Dba <shreeyansh2014@gmail.com>
wrote:
> Hi All,
>
> Can u help me, Is their any option to "Autocommit to keep off " in
> PostgreSQL
> Any how By default "autocommit is on"
>
> So i need to keep autocommit off, can anyone guide me to keep the
> "autocommit=off"
>
> Thanks & Regards,
> Neeraj
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-25 08:16 David G. Johnston <david.g.johnston@gmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: David G. Johnston @ 2015-07-25 08:16 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
> Hi All,
>
> Sorry for keeping Repeat mail, I didn't mention the Error what i am
> getting
>
> This is the Error mentioned below.
> * postgres=#*
> *set autocommit to off; ERROR: SET AUTOCOMMIT TO OFF is no longer
> supported*
> * postgres=#*
>
>
Try: "BEGIN;"
David J.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Reg:Autocommit
@ 2015-07-25 08:31 David G. Johnston <david.g.johnston@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: David G. Johnston @ 2015-07-25 08:31 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
On Saturday, July 25, 2015, David G. Johnston <david.g.johnston@gmail.com
<javascript:_e(%7B%7D,'cvml','david.g.johnston@gmail.com');>> wrote:
> On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
>
>> Hi All,
>>
>> Sorry for keeping Repeat mail, I didn't mention the Error what i am
>> getting
>>
>> This is the Error mentioned below.
>> * postgres=#*
>> *set autocommit to off; ERROR: SET AUTOCOMMIT TO OFF is no longer
>> supported*
>> * postgres=#*
>>
>>
>
> Try: "BEGIN;"
>
>
Or you can use the psql specific:
\set AUTOCOMMIT off
Auto-commit is a feature of the client, not the server.
David J.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-25 13:22 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Shreeyansh Dba @ 2015-07-25 13:22 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-admin
Hi David ,
Thanks for reply,
I tried it but the "autocommit" is showing "on" as mention below.
*postgres=# \set autocommit off;postgres=# show
autocommit; autocommit------------ on(1 row)*
I want the permanent solution without using "BEGIN".
Can you please tell me the solution.
Thanks & Regards,
Neeraj.
On Sat, Jul 25, 2015 at 2:01 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:
> On Saturday, July 25, 2015, David G. Johnston <david.g.johnston@gmail.com>
> wrote:
>
>> On Friday, July 24, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com>
>> wrote:
>>
>>> Hi All,
>>>
>>> Sorry for keeping Repeat mail, I didn't mention the Error what i am
>>> getting
>>>
>>> This is the Error mentioned below.
>>> * postgres=#*
>>> *set autocommit to off; ERROR: SET AUTOCOMMIT TO OFF is no longer
>>> supported*
>>> * postgres=#*
>>>
>>>
>>
>> Try: "BEGIN;"
>>
>>
> Or you can use the psql specific:
>
> \set AUTOCOMMIT off
>
> Auto-commit is a feature of the client, not the server.
>
> David J.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-25 13:29 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Scott Ribe @ 2015-07-25 13:29 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
On Jul 25, 2015, at 7:22 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
>
> I want the permanent solution without using "BEGIN".
> Can you please tell me the solution.
The permanent solution is to specify the boundaries of your transactions, using begin & commit. It's either that, or let your client assume that every submitted statement should be its own transaction, which is what autocommit does.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-25 14:44 David G. Johnston <david.g.johnston@gmail.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: David G. Johnston @ 2015-07-25 14:44 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin
On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
> Hi David ,
> Thanks for reply,
> I tried it but the "autocommit" is showing "on" as mention below.
>
> *postgres=# \set autocommit off;*
>
>
>
>
>
> *postgres=# show autocommit; autocommit------------ on(1 row)*
>
The first command sets a psql variable named autocommit.
The second commands show the sql guc named autocommit.
These are two different things.
Try "select :AUTOCOMMIT"
Note, in the psql variable capitalization matters. You must use all-caps.
David J.
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-27 07:03 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Raghavendra @ 2015-07-27 07:03 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; pgsql-admin
On Sat, Jul 25, 2015 at 8:14 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:
> On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com>
> wrote:
>
>> Hi David ,
>> Thanks for reply,
>> I tried it but the "autocommit" is showing "on" as mention below.
>>
>> *postgres=# \set autocommit off;*
>>
>>
>>
>>
>>
>> *postgres=# show autocommit; autocommit------------ on(1 row)*
>>
>
> The first command sets a psql variable named autocommit.
> The second commands show the sql guc named autocommit.
> These are two different things.
> Try "select :AUTOCOMMIT"
> Note, in the psql variable capitalization matters. You must use all-caps.
>
> David J.
>>
>>
+1
You can try this to check out what setting is set in psql variable.
-bash-4.2$ psql
psql.bin (9.4.4)
Type "help" for help.
postgres=# \set AUTOCOMMIT off
postgres=# \echo :AUTOCOMMIT
off
postgres=# \set AUTOCOMMIT on
postgres=# \echo :AUTOCOMMIT
on
postgres=#
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Reg:Autocommit
@ 2015-07-27 08:54 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 0 replies; 9+ messages in thread
From: Shreeyansh Dba @ 2015-07-27 08:54 UTC (permalink / raw)
To: Raghavendra <raghavendra.rao@enterprisedb.com>; +Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-admin
Hi Raghavendra,
Thank you for the solution, It is working fine.
Thanks & Regards
Neeraj
On Mon, Jul 27, 2015 at 12:33 PM, Raghavendra <
raghavendra.rao@enterprisedb.com> wrote:
> On Sat, Jul 25, 2015 at 8:14 PM, David G. Johnston <
> david.g.johnston@gmail.com> wrote:
>
>> On Saturday, July 25, 2015, Shreeyansh Dba <shreeyansh2014@gmail.com>
>> wrote:
>>
>>> Hi David ,
>>> Thanks for reply,
>>> I tried it but the "autocommit" is showing "on" as mention below.
>>>
>>> *postgres=# \set autocommit off;*
>>>
>>>
>>>
>>>
>>>
>>> *postgres=# show autocommit; autocommit------------ on(1 row)*
>>>
>>
>> The first command sets a psql variable named autocommit.
>> The second commands show the sql guc named autocommit.
>> These are two different things.
>> Try "select :AUTOCOMMIT"
>> Note, in the psql variable capitalization matters. You must use all-caps.
>>
>> David J.
>>>
>>>
> +1
>
> You can try this to check out what setting is set in psql variable.
>
> -bash-4.2$ psql
> psql.bin (9.4.4)
> Type "help" for help.
>
> postgres=# \set AUTOCOMMIT off
> postgres=# \echo :AUTOCOMMIT
> off
> postgres=# \set AUTOCOMMIT on
> postgres=# \echo :AUTOCOMMIT
> on
> postgres=#
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2015-07-27 08:54 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-07-25 05:51 Reg:Autocommit Shreeyansh Dba <shreeyansh2014@gmail.com>
2015-07-25 06:10 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2015-07-25 08:16 ` David G. Johnston <david.g.johnston@gmail.com>
2015-07-25 08:31 ` David G. Johnston <david.g.johnston@gmail.com>
2015-07-25 13:22 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2015-07-25 13:29 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-07-25 14:44 ` David G. Johnston <david.g.johnston@gmail.com>
2015-07-27 07:03 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2015-07-27 08:54 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox