Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-29 Thread Adrian Klaver
On Tuesday, March 29, 2011 4:35:04 am tushar nehete wrote: > Yes We can use exception for each statement to restrict the rollback. > But how we can use SAVEPOINT and rollback to SAVEPOINT > in the stored function or procedure in POSTGRES? > We can only use the savepoints in transactions but not in

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-29 Thread tushar nehete
Yes We can use exception for each statement to restrict the rollback. But how we can use SAVEPOINT and rollback to SAVEPOINT in the stored function or procedure in POSTGRES? We can only use the savepoints in transactions but not in stored functions. Regards, Tushar On Tue, Mar 29, 2011 at 12:54 P

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-29 Thread Jerry Sievers
Craig Ringer writes: > On 03/14/2011 10:55 PM, Vogt, Michael wrote: > >> Hey all >> >> I have a question, using the autocommit off option in postgres. >> >> As starting position I use a table called xxx.configuration using a >> unique id constraint. >> >> Why does postgres rollback the whole tran

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-28 Thread Craig Ringer
On 03/14/2011 10:55 PM, Vogt, Michael wrote: Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? It's a PostgreSQL li

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-15 Thread Vogt, Michael
? Regards and thanks in advance michael -Ursprüngliche Nachricht- Von: Alexander Pyhalov [mailto:a...@rsu.ru] Gesendet: Montag, 14. März 2011 17:28 An: Vogt, Michael Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] Autocommit off - commits/rollbacks Hello. On 03/14/2011 12:24, Vogt

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread David Johnston
nt: Monday, March 14, 2011 5:24 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Autocommit off - commits/rollbacks Hey all Or can postgres behavior be changed to a "commit whatever is possible" mode? Regards michu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Andrew Sullivan
On Mon, Mar 14, 2011 at 03:55:37PM +0100, Vogt, Michael wrote: > Why does postgres rollback the whole transaction after an error? I > compared the behavior with oracle/hsql - those dbms commit whats > possible. A transaction is supposed to commit or rollback. If you want to hold on to something t

Re: [GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Alexander Pyhalov
Hello. On 03/14/2011 12:24, Vogt, Michael wrote: I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? I compared the behavior wit

[GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Vogt, Michael
Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? I compared the behavior with oracle/hsql - those dbms commit whats po

[GENERAL] Autocommit off - commits/rollbacks

2011-03-14 Thread Vogt, Michael
Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole transaction after an error? I compared the behavior with oracle/hsql - those dbms commit whats po