pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Reg: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