> No, they developed it for marketing.
Perhaps, but towards whom? PostgreSQL wouldn't hurt if a lot of developers and
DBA's was lured into the trap by this new feature.
> Keep in mind that Oracle has six thousand full-time developers and an
> already extremely mature database. Stuff that they s
On Tue, Jul 15, 2008 at 2:17 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> I agree such improvements would be welcomed. I'm pretty sure they sat
> around saying we can already do that some other way at first, until the
> requests started to pile up.
Agreed.
>
>> > Stuff that they see fit to add is
On Mon, 2008-07-14 at 22:54 -0400, Jonah H. Harris wrote:
> On Mon, Jul 14, 2008 at 9:18 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > Kaare Rasmussen <[EMAIL PROTECTED]> writes:
> >> But yes, it has to be enabled, and yes it has to have a performance cost
> >> somehow, but people are requesting it,
On Mon, Jul 14, 2008 at 9:18 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Kaare Rasmussen <[EMAIL PROTECTED]> writes:
>> But yes, it has to be enabled, and yes it has to have a performance cost
>> somehow, but people are requesting it, and somehow I don't think Oracle
>> developed the feature just for
Kaare Rasmussen <[EMAIL PROTECTED]> writes:
> But yes, it has to be enabled, and yes it has to have a performance cost
> somehow, but people are requesting it, and somehow I don't think Oracle
> developed the feature just for fun.
No, they developed it for marketing.
Keep in mind that Oracle ha
On Mon, 2008-07-14 at 22:38 +0200, Kaare Rasmussen wrote:
> > This sounds a lot like the functionality that a temporal data model
> > would give you. In this model you never delete tuples from your
> > database, your only insert and update tuples that are valid for
> > specific periods of time.
>
Lewis Cunningham wrote:
> --- On Mon, 7/14/08, Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
>
> > But yes, it has to be enabled, and yes it has to have a
> > performance cost
> > somehow, but people are requesting it, and somehow I
>
> AFAIK, It is built from undo so there is no ADDITIONAL overhea
--- On Mon, 7/14/08, Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
> But yes, it has to be enabled, and yes it has to have a
> performance cost
> somehow, but people are requesting it, and somehow I
AFAIK, It is built from undo so there is no ADDITIONAL overhead. It just saves
the undo that is cr
On Mon, Jul 14, 2008 at 1:38 PM, Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
> Isn't this exactly what Alvaro describes? The time travel feature that was
> removed because it made Postgres too slow to use in production?
No, I imagine that time travel was built into the Postgresql
architecture and w
> This sounds a lot like the functionality that a temporal data model
> would give you. In this model you never delete tuples from your
> database, your only insert and update tuples that are valid for
> specific periods of time.
Isn't this exactly what Alvaro describes? The time travel feature t
> which "it would come in handy" wouldn't have enabled it. (FWIW this
> feature used to exist in the Berkeley code, under the cool name "time
> travel", and was removed a long time ago.)
No, it didn't AFAIK. Timetravel kept all tuples in the database with all
indexes and constraints active at al
On Mon, 2008-07-14 at 21:59 +0200, Kaare Rasmussen wrote:
> > I just lost a months worth of stats data myself, so join the club. It
> > wasn't critical data, but it would have been nice to have kept
> > around...
>
> I also think there could be a TODO item in it. If vacuum instead of removing
>
Kaare Rasmussen escribió:
> I don't say it's an important feature, but it would come in handy for people
> who really really need it. And perhaps a developer wouldn't mind scratching
> this itch some time in the future.
It would need to be enabled beforehand, and most people I've seen for
which
On Mon, Jul 14, 2008 at 12:59 PM, Kaare Rasmussen <[EMAIL PROTECTED]> wrote:
> I also think there could be a TODO item in it. If vacuum instead of removing
> items, somehow stashed them away in a storage limited archive it would be
> possible to do a SELECT...AS OF TIMESTAMP.
This sounds a lot lik
> I just lost a months worth of stats data myself, so join the club. It
> wasn't critical data, but it would have been nice to have kept
> around...
I also think there could be a TODO item in it. If vacuum instead of removing
items, somehow stashed them away in a storage limited archive it would
On Mon, Jul 14, 2008 at 9:20 AM, samantha mahindrakar
<[EMAIL PROTECTED]> wrote:
> 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
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 compa
--- On Sat, 7/12/08, Scott Marlowe <[EMAIL PROTECTED]> 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
>
> Please don't put links to copyrighted material on our
> lists.
>
Postgres docs are copyrighted. The oracle docs are free to access just like
the postgres docs. What is the issue?
LewisC
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription
On Sat, Jul 12, 2008 at 3:20 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> On Sat, 2008-07-12 at 09:40 +0100, Dave Page wrote:
>> On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>> >
>> > Please don't put links to copyrighted material on our lists.
>>
>> That's an odd thing
On Sat, 2008-07-12 at 09:40 +0100, Dave Page wrote:
> On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> >
> > Please don't put links to copyrighted material on our lists.
>
> That's an odd thing to say, given that virtually every link on our
> lists probably points to mate
On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> Please don't put links to copyrighted material on our lists.
That's an odd thing to say, given that virtually every link on our
lists probably points to material copyrighted in some way.
--
Dave Page
EnterpriseDB UK: htt
On Fri, 2008-07-11 at 18:56 -0700, Lewis Cunningham wrote:
> In addition to allowing you to read old data, Flashback will allow you
> to rollback to a point in time, including returning a single table to
> a specific state. Flashback database is like PITR without the log
> files.
Like I said: y
http://postgres.enterprisedb.com/forum.do
--- On Fri, 7/11/08, Simon Riggs <[EMAIL PROTECTED]> wrote:
> From: Simon Riggs <[EMAIL PROTECTED]>
> Subject: Re: [SQL] Rollback in Postgres
> To: "Scott Marlowe" <[EMAIL PROTECTED]>
> Cc: "samantha mahindrakar&quo
On Fri, 2008-07-11 at 11:21 -0600, Scott Marlowe wrote:
> rollback after commit
Are you sure?
Personally I don't think its viable. If it really does that it will
would also need to rollback all transactions whose changes depend upon
the earlier transaction. It would also need to track transacti
On Fri, Jul 11, 2008 at 9:43 AM, samantha mahindrakar
<[EMAIL PROTECTED]> 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
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
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 r
Yes, Tom,
it looks like this:
Locked Transaction:458553
I misread that. Sorry for that, I am actually a Geographer and just "using" the
tools at hand. So I was not clear enough, it is a lock, but it's just the one
of the transaction, right. That still does not explain why the Query Editor
loc
Hm,
Tom, your're right, it works in the console, but not in the editor window,
strange...
--
Pt! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your s
Hello Tom,
> so the problem must be in something you didn't show us. What exactly
> are you doing to decide that you need to roll back? Also, none of these
> statements (except the CREATE) would take an exclusive lock on test, so
> there must be something else going on that you didn't show us.
"Jan Peters" <[EMAIL PROTECTED]> writes:
> If I run the transaction block from above again I get first a unique
> key violation (that is ok, because that's what I trying to check for)
> but there is NO rollback to sp1, only the "Unique Key" error message
> and after that I get the dreaded "current
Hello Craig,
>
> Maybe you should tell the readers of this list a little more about what
> you're trying to do and why?
> --
ok, so I'll do that: I am programming a small economic Java simulation/serious
game that has to calculate the GDP after 12 rounds. For doing this, I need the
capital of
Jan Peters wrote:
Yes, you are correct: I just want to issue an insertion of a row at the very beginning of an
application start. So, when the table "test" is empty, the row with "runde =
0" should be inserted. If this row is already present, it should be updated.
This is quite common - yo
Hello Craig,
> Jan Peters wrote:
> > If I run the transaction block from above again I get first a unique key
> violation (that is ok, because that's what I trying to check for) but
> there is NO rollback to sp1, only the "Unique Key" error message and after
> that
> I get the dreaded "current tr
Jan Peters wrote:
If I run the transaction block from above again I get first a unique key violation (that is ok, because
that's what I trying to check for) but there is NO rollback to sp1, only the "Unique Key" error
message and after that I get the dreaded "current transaction is aborted" err
Hello list,
I am a bit confused. See the code below:
BEGIN;
SAVEPOINT sp1;
INSERT INTO test(id,runde) VALUES(2, 0);
--if there is a unique key violstion:
ROLLBACK TO sp1;
UPDATE test SET id = 1000 WHERE runde = 0;
COMMIT;
When I first run this statement, I do not get any error message, but also
Hello list,
I am a bit confused. See the code below:
BEGIN;
SAVEPOINT sp1;
INSERT INTO test(id,runde) VALUES(2, 0);
--if there is a unique key violstion:
ROLLBACK TO sp1;
UPDATE test SET id = 1000 WHERE runde = 0;
COMMIT;
When I first run this statement, I do not get any error message, but also
Thanks for replyin buddy
I had a partial backup and recovered from that
will take care next time
thanks again
> You can not rollback a committed transaction.
>
> Time to restore some backups - what kind of backup are you using?
>
> ~p
>
> On Sat, 2007-03-17 at 16:19 +0530, Hetal Patel wrote:
>
>> H
You can not rollback a committed transaction.
Time to restore some backups - what kind of backup are you using?
~p
On Sat, 2007-03-17 at 16:19 +0530, Hetal Patel wrote:
> Hello Friends
> New to postgresql
> I m in trouble
> I fired a query a "DELETE" query from a PGADMIN III postgresql tool
> W
Hello Friends
New to postgresql
I m in trouble
I fired a query a "DELETE" query from a PGADMIN III postgresql tool
Which have deleted some rows which shud ve not been deleted
How do i get it rollback
I mean i want all the rows back
Please help me
Its urgent
Thanks in advance for Help
Hetal Patel
> Hi everybody,
> I was playing with psql and accidently deleted a couple of records from
> my database. I am wondering if there is any way to restore them. I know
> that in Oracle you can do 'rollback work' from SQLPlus interface and it
> would rollback all the updates done to the database.
That
Hi everybody,
I was playing with psql and accidently deleted a couple of records from
my database. I am wondering if there is any way to restore them. I know
that in Oracle you can do 'rollback work' from SQLPlus interface and it
would rollback all the updates done to the database.
I am pretty sur
Fredrik Eriksson wrote:
> I have been trying the following SQL code :
> BEGIN;
> INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' );
> ROLLBACK;
> And the insert function is rolled back but the serial sequence isn't. Hav I
> misunderstood the functionality of rollback or is this a bug? Is
Fredrik,
> I have been trying the following SQL code :
>
> BEGIN;
> INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' );
> ROLLBACK;
>
> And the insert function is rolled back but the serial sequence isn't. Hav I
> misunderstood the functionality of rollback or is this a bug? Is there
> somew
I have been trying the following SQL code :
BEGIN;
INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' );
ROLLBACK;
And the insert function is rolled back but the serial sequence isn't. Hav I
misunderstood the functionality of rollback or is this a bug? Is there
someway to get the functionality
46 matches
Mail list logo
