Re: Nested Transactions

cbroussard(at)liquiddatainc(dot)com (Chris) writes:

> i'm trying to accomplish the following task:
>
> begin transaction;
> begin work;
> create table xyz(
> id int
> );
> commit work;
> select * from xyz;
> rollback transaction;
> select * from xyz; // should say database object doesn't exist

PostgreSQL currently doesn't have nested transactions. They have been
discussed for a future version.

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...