Re: savepoint and rollback queries in postgres

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Yuva Chandolu" <ychandolu(at)ebates(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: savepoint and rollback queries in postgres
Date: 2002-07-25 02:20:44
Message-ID: GNELIHDDFBOCMGBFGEFOMEFECDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> We are in the process of moving to Postgres from Oracle. We were using
> "savepoint xyz" and "rollback to savepoint xyz" with Oracle. Or these
> supported by Postgres?, if so what are the equivalent queries in postgres
> for the same.

No, they're not supported in any released version. Postgres doens't have
savepoints and hence doesn't have nested transactions. However, there are
moves afoot and such functionality may appear in 7.3 or 7.4.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2002-07-25 03:29:08 Re: RESET SESSION AUTHORIZATION
Previous Message Tatsuo Ishii 2002-07-25 02:18:54 RESET SESSION AUTHORIZATION