On 02/14/2017 05:12 AM, mpomykacz wrote:
Ok, thanks for the answers. But unfortunatelly they did not solve my problem.
Still not actually sure what the issue is?:
1) Problem with pgAdmin setup
or
2) Broader issue of having Postgres rollback automatically on a error.
or
3) Patch management.
Ok, thanks for the answers. But unfortunatelly they did not solve my problem.
I will move it to the pgadmin subforum.
Thanks:)
--
View this message in context:
http://postgresql.nabble.com/Auto-Rollback-option-tp5943942p5944159.html
Sent from the PostgreSQL - general mailing list archive at Nab
On 02/13/2017 02:10 PM, mpomykacz wrote:
Yes, I'm talking about pgAdmin III - sorry...
I think that auto-commit is on on default but auto-rollback is off. But I'll
check if you say so.
Did you look here:
https://www.pgadmin.org/docs/1.22/options-query_tool.html
It seems checking it here woul
Yes, I'm talking about pgAdmin III - sorry...
I think that auto-commit is on on default but auto-rollback is off. But I'll
check if you say so.
And I know I can check the box next to Enable Auto ROLLBACK but I'm trying
to avoid it and enable auto rollback not by a manual way.
--
View this mess
On Mon, Feb 13, 2017 at 1:19 PM, Moreno Andreo
wrote:
> Il 13/02/2017 18:59, John R Pierce ha scritto:
>
>> option? query editor window? what software are you talking about?
>>
>> I'm using 1.22.1 version.
>>>
>>
>> 1.22.1 version? PostgreSQL versions currently supported are 9.2.x to
>>
Il 13/02/2017 18:59, John R Pierce ha scritto:
option? query editor window? what software are you talking about?
I'm using 1.22.1 version.
1.22.1 version? PostgreSQL versions currently supported are 9.2.x
to 9.6.x
I think he's talking about pgAdmin III
Cheers
Moreno
--
Se
On 02/13/2017 09:59 AM, John R Pierce wrote:
> On 2/13/2017 7:15 AM, mpomykacz wrote:
>> So my problem is like this:
>>
>> I start the transaction with BEGIN TRANSACTION;
>> Then I have for example some INSERTs to DB
>> and at the end COMMIT; and END TRANSACTION;
>
> COMMIT ends the transaction.
On Mon, Feb 13, 2017 at 1:10 PM, Adrian Klaver
wrote:
> On 02/13/2017 09:59 AM, John R Pierce wrote:
>
>> On 2/13/2017 7:15 AM, mpomykacz wrote:
>>
>>> So my problem is like this:
>>>
>>> I start the transaction with BEGIN TRANSACTION;
>>> Then I have for example some INSERTs to DB
>>> and at the
On 02/13/2017 09:59 AM, John R Pierce wrote:
On 2/13/2017 7:15 AM, mpomykacz wrote:
So my problem is like this:
I start the transaction with BEGIN TRANSACTION;
Then I have for example some INSERTs to DB
and at the end COMMIT; and END TRANSACTION;
COMMIT ends the transaction. In PostgreSQL,
On 2/13/2017 7:15 AM, mpomykacz wrote:
So my problem is like this:
I start the transaction with BEGIN TRANSACTION;
Then I have for example some INSERTs to DB
and at the end COMMIT; and END TRANSACTION;
COMMIT ends the transaction. In PostgreSQL, END TRANSACTION is
redundant, equivalent to C
So my problem is like this:
I start the transaction with BEGIN TRANSACTION;
Then I have for example some INSERTs to DB
and at the end COMMIT; and END TRANSACTION;
But if one of this INSERTs causes error, the transaction will stop (but it
is still open and next patch is implemented within the same
Take a look at ON_ERROR_STOP variable.
\set ON_ERROR_STOP 1
On 13/02/2017 15:55, Małgorzata Hubert wrote:
Hi,
is there any way to set Auto-Rollback : ON, automaticly during instalation
process or using query (maybe something like set autocommit = 'on')?
We need it to automaticly close the tran
On 02/13/2017 05:55 AM, Małgorzata Hubert wrote:
Hi,
is there any way to set Auto-Rollback : ON, automaticly during
instalation process or using query (maybe something like set autocommit
= 'on')?
We need it to automaticly close the transaction if an error occures
during implementing patches.
H
On Mon, Feb 13, 2017 at 02:55:03PM +0100, Małgorzata Hubert wrote:
> is there any way to set Auto-Rollback : ON, automaticly during instalation
> process or using query (maybe something like set autocommit = 'on')?
> We need it to automaticly close the transaction if an error occures during
> impl
14 matches
Mail list logo
