Re: Rollback in Postgres

Поиск
Список
Период
Сортировка
От samantha mahindrakar
Тема Re: Rollback in Postgres
Дата
Msg-id f0c828c40807140820q30eba4bs364d31dab2ef7f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Rollback in Postgres  (Lewis Cunningham <lewisc@rocketmail.com>)
Ответы Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to perform minus (-) operation in a dynamic query
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Rollback in Postgres