Re: Rollback in Postgres

From: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
To: samantha mahindrakar <sam(dot)mahindrakar(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Rollback in Postgres
Date: 2008-07-11 16:27:58
Message-ID: 1215793678.26739.121.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Fri, 2008-07-11 at 11:43 -0400, samantha mahindrakar wrote:
> Hi all....
> This is a very basic question.....can we roll back data after we run a
> query.
> I know that a delete within a transaction can be rolled back. But how
> about independent delete queries???
> If i ran a delete statement and lost data...how do i recover. I know
> that oracle has this provision of rollingback queries.
> Iam surprised iam not able to find the same in postgres.
>
> Sam

Postgres certainly can roll back queries, table creations, and many
other actions. You can find more information about rollback here:
http://www.postgresql.org/docs/8.3/interactive/sql-rollback.html

Best of luck in your endeavor :)

-Mark

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Matthew T. O'Connor 2008-07-11 17:14:57 When was my database created
Previous Message Robins Tharakan 2008-07-11 16:26:26 Unnecessary repeat condition for a self inner join