Re: Problem using start transaction in nested transactions.

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Sri <asrinivas(at)effigent(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem using start transaction in nested transactions.
Date: 2005-10-17 18:26:43
Message-ID: m2d5m4xan0.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:

> You can't do subtransactions in PostgreSQL, but you can use savepoints:
> http://www.postgresql.org/docs/8.0/interactive/sql-savepoint.html.
>
> Previously, you couldn't do any transactional stuff from inside
> functions. I'm not sure if you can do savepoint-related stuff from
> inside functions in 8.0 or not.

Yes, you certainly can; PL/pgSQL uses savepoints to do its exception
handling.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2005-10-17 18:28:11 Re: searching array
Previous Message Matthew Peter 2005-10-17 18:20:25 Re: searching array