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
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 |