Scott Marlowe wrote:
> On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <pg(at)dbginc(dot)com> wrote:
>
>> Does PostgreSQL support nested transactions as shown below?
>>
>> BEGIN;
>> ...do some stuff...
>> BEGIN;
>> ...more stuff...
>> COMMIT;
>> COMMIT;
>>
>
> Postgresql uses savepoints.
>
>
>
Savepoints do not provide the same functionality as nested or parallel
transactions because you cannot commit a savepoint. If I need a second
transaction I can always open a second connection so it is easy to get
the behavior I need. Thanks.
Bill