Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group