Thread: anonymous transaction support

anonymous transaction support

From
Vano Beridze
Date:
Hello,

I've a question about pgAdmin 4.
Is it possible to open SQL editor window, issue some commands which are 
not commited automatically and then via toolbar button or some keyboard 
shortcut either commit or rollback the whole session?

This functionality exists in Oracle SQL Developer for instance and is 
very handy.

-- 
Vano Beridze
Software Developer
Silk Road Group





Re: anonymous transaction support

From
Dave Page
Date:
On Fri, Jun 10, 2016 at 5:13 PM, Vano Beridze <vano.beridze@silkroad.ge> wrote:
> Hello,
>
> I've a question about pgAdmin 4.
> Is it possible to open SQL editor window, issue some commands which are not
> commited automatically and then via toolbar button or some keyboard shortcut
> either commit or rollback the whole session?
>
> This functionality exists in Oracle SQL Developer for instance and is very
> handy.

Please see the Auto-commit and Auto-rollback options:
https://www.pgadmin.org/docs4/dev/query_tool.html

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



Re: anonymous transaction support

From
Vano Beridze
Date:
This is exactly what I've been missing

Vano Beridze
Software Developer
Silk Road Group

On 6/10/2016 8:25 PM, Dave Page wrote:
> On Fri, Jun 10, 2016 at 5:13 PM, Vano Beridze <vano.beridze@silkroad.ge> wrote:
>> Hello,
>>
>> I've a question about pgAdmin 4.
>> Is it possible to open SQL editor window, issue some commands which are not
>> commited automatically and then via toolbar button or some keyboard shortcut
>> either commit or rollback the whole session?
>>
>> This functionality exists in Oracle SQL Developer for instance and is very
>> handy.
> Please see the Auto-commit and Auto-rollback options:
> https://www.pgadmin.org/docs4/dev/query_tool.html
>