Skip site navigation (1) Skip section navigation (2)

Re: Transaction vs. Savepoints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Transaction vs. Savepoints
Date: 2007-02-09 14:43:49
Message-ID: 24405.1171032229@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas <maps(dot)on(at)gmx(dot)net> writes:
> As far as I know, PG handles 1 transaction per connection an several 
> savepoints boxed within.

One transaction *at a time*, not one for the whole life of the session.

A good general design rule is that no transaction should stay open for
very long: do what you need to do and commit.  So the scenarios you're
envisioning are not relevant to a well-designed application.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: AndreasDate: 2007-02-09 15:58:30
Subject: Re: Transaction vs. Savepoints
Previous:From: Johannes BruegmannDate: 2007-02-09 09:38:13
Subject: Re: relation 12345 is still open

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group