Postgres Pro
Downloads
Home   >   mailing lists

Re: Rollback in Postgres - Mailing list pgsql-sql

From samantha mahindrakar
Subject Re: Rollback in Postgres
Date
Msg-id f0c828c40807140820q30eba4bs364d31dab2ef7f@mail.gmail.com
Whole thread Raw
In response to Re: Rollback in Postgres  (Lewis Cunningham <lewisc@rocketmail.com>)
Responses Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view
I didnt no the thread would become a postgresVSoracle thing. I just lost couple of thousand rows and could not retrieve them back, so i wanted to know if postgres had some way to get it back. Iam just a few days expereinced in postgres hence iam still discovering its features.
No intention of comparing the two technologies......just trying find a solution and ended up comparing because i had worked in oracle before and very well knewit provide a rollback option for queries.
I dont see anything wrong in knowing what features oracle has.
 
Peace
Sam

 
On 7/12/08, Lewis Cunningham <lewisc@rocketmail.com> wrote:
--- On Sat, 7/12/08, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> What I would appreciate as regards Oracle's flashback
> technology would
> have been a link to a well written review showing the warts
> as well as
> the beauty.  I've found that Oracle stuff sounds good
> on paper, and
> turns into a giant maintenance nightmare upon deployment.
> But that's
> just what I've seen looking over Oracle DBA shoulders
> in the past.

Oracle-base is a site I trust and use.  Tim writes very good articles and this is one he did recently covering flashback in 11g.  The example on flashback transaction is the best I've seen.

http://www.oracle-base.com/articles/11g/FlashbackAndLogminerEnhancements_11gR1.php


Lewis R Cunningham

An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/

Postgres Forums
http://postgres.enterprisedb.com/forum.do






pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: how to perform minus (-) operation in a dynamic query
Next
From: "Scott Marlowe"
Date:
Subject: Re: Rollback in Postgres