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

Re: Tuple changes from relfilenodes

From: Craig James <craig_james(at)emolecules(dot)com>
To: Lukasz Brodziak <lukasz(dot)brodziak(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Tuple changes from relfilenodes
Date: 2010-08-27 17:27:13
Message-ID: 4C77F571.40505@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 8/27/10 10:09 AM, Lukasz Brodziak wrote:
> What do You mean by history table? Creating such table is out of the question.

You asked for "actual versions of row data" and a "data change history."  How can you expect to get a history without the history being stored somewhere?  The previous answers to your question already said that the old versions of data can be erased almost immediately, so if you really need the history, you have to do it yourself.

Why is that out of the question?  Perhaps a more detailed explanation of what you are trying to achieve would help.

Craig

>
>  > Date: Fri, 27 Aug 2010 10:04:39 -0700
>  > From: craig_james(at)emolecules(dot)com
>  > To:
>  > Subject: Re: [ADMIN] Tuple changes from relfilenodes
>  >
>  > On 8/27/10 9:48 AM, ?ukasz Brodziak wrote:
>  > > I'm looking for actual versions of row data. What I want to achieve as a final result is a kind of data change history.
>  >
>  > What about a before-update trigger and an history table?
>  >
>  > Craig


In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2010-08-27 17:28:16
Subject: Re: Tuple changes from relfilenodes
Previous:From: Łukasz BrodziakDate: 2010-08-27 17:18:26
Subject: Re: Tuple changes from relfilenodes

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