Search Postgresql Archives

Re: Nested transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 12, 2009 at 5:18 PM, Bill Todd <pg@xxxxxxxxxx> wrote:
> Scott Marlowe wrote:
>
> On Sun, Oct 11, 2009 at 8:41 PM, Bill Todd <pg@xxxxxxxxxx> 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

Yes they do.  There was a REALLY long discussion on the subject in the
hackers list I believe that led to pgsql supporting savepoints  but
not nested transactions

> or parallel transactions

That's something entirely different and a question you did not ask

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux