Re: Nested Transactions

cbroussard@liquiddatainc.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...