pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Disable autocommit inside dbeaver
4+ messages / 3 participants
[nested] [flat]

* Disable autocommit inside dbeaver
@ 2023-12-06 17:41  arun chirappurath <arunsnmimt@gmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: arun chirappurath @ 2023-12-06 17:41 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

Hi All,

Is there a way we can disable autocommit option inside query writing area?
Not by choosing auto commit from drop down menu.

Thanks,
Arun

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Disable autocommit inside dbeaver
@ 2023-12-06 18:22  Holger Jakobs <holger@jakobs.com>
  parent: arun chirappurath <arunsnmimt@gmail.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Holger Jakobs @ 2023-12-06 18:22 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org; +Cc: arunsnmimt@gmail.com

Am 06.12.23 um 18:41 schrieb arun chirappurath:
> Hi All,
>
> Is there a way we can disable autocommit option inside query writing 
> area? Not by choosing auto commit from drop down menu.
>
> Thanks,
> Arun

No, and there is a reason why:

https://www.cybertec-postgresql.com/en/disabling-autocommit-in-postgresql-can-damage-your-health/

and here: 
https://dba.stackexchange.com/questions/303155/how-to-turn-off-autocommit-in-postgresql

Whenever you want several commands being executed in a transaction, 
start the transaction yourself, using BEGIN or START TRANSACTION. If you 
want transactions, you probably also want to set the isolation level, 
which defaults to READ COMMITTED, even though the SQL standard would 
prefer SERIALIZABLE.

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



Attachments:

  [application/pgp-signature] OpenPGP_signature (202B, ../../384f0e2f-d398-5bbd-5501-8b22ea49bbc6@jakobs.com/2-OpenPGP_signature)
  download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Fwd: Disable autocommit inside dbeaver
@ 2023-12-07 03:45  arun chirappurath <arunsnmimt@gmail.com>
  parent: arun chirappurath <arunsnmimt@gmail.com>
  1 sibling, 1 reply; 4+ messages in thread

From: arun chirappurath @ 2023-12-07 03:45 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

Hi All,

Is there a way we can disable autocommit option inside query writing area?
Not by choosing auto commit from drop down menu.

Thanks,
Arun

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Fwd: Disable autocommit inside dbeaver
@ 2023-12-07 03:49  Rob Sargent <robjsargent@gmail.com>
  parent: arun chirappurath <arunsnmimt@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Rob Sargent @ 2023-12-07 03:49 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 12/6/23 20:45, arun chirappurath wrote:
>
>
>
> Hi All,
>
> Is there a way we can disable autocommit option inside query writing 
> area? Not by choosing auto commit from drop down menu.
>
> Thanks,
> Arun
maybe "begin; <your sql statements>; commit;"

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2023-12-07 03:49 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-12-06 17:41 Disable autocommit inside dbeaver arun chirappurath <arunsnmimt@gmail.com>
2023-12-06 18:22 ` Holger Jakobs <holger@jakobs.com>
2023-12-07 03:45 ` arun chirappurath <arunsnmimt@gmail.com>
2023-12-07 03:49   ` Rob Sargent <robjsargent@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