Kevin Grittner wrote:
> *ukasz Brodziak wrote:
> > From: kevin.gritt...@wicourts.gov
>
> >> Are you looking for statistics or the actual prior versions of
> >> rows?
>
> > 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.
Are you looking for statistics or the actual prior versions of
rows?
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.
We just use ON DELETE rules on the tables where we want to maintain a history. In most
cases, we just co
*ukasz Brodziak wrote:
> I have a database from which I have to retrieve some history data
> for recovery purposes.
Ouch.
A quick search on pgfoundry shows a couple projects which might
help. (I've never used either of them.) Perhaps others will have
more ideas.
http://pgfoundry.org/proje
p.
Craig
> Date: Fri, 27 Aug 2010 10:04:39 -0700
> From: craig_ja...@emolecules.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 ac
m; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
>
> >> Are you looking for statistics or the actual prior versions of
> >> rows?
> >
> > I'm looking for actual versions of row data. What I want to
> > achieve as a final
Are you looking for statistics or the actual prior versions of
rows?
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.
We just use ON DELETE rules on the tables where we want to maintain a history. In most
cases, we just co
What do You mean by history table? Creating such table is out of the question.
> Date: Fri, 27 Aug 2010 10:04:39 -0700
> From: craig_ja...@emolecules.com
> To:
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
>
> On 8/27/10 9:48 AM, ?ukasz Brodziak wrote:
> >
kevin.gritt...@wicourts.gov
> To: lukasz.brodz...@hotmail.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
> Are you looking for statistics or the actual prior versions of rows?
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list
*ukasz Brodziak wrote:
> From: kevin.gritt...@wicourts.gov
>> Are you looking for statistics or the actual prior versions of
>> rows?
> 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.
Well, unless you are suppressing th
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.
> Date: Fri, 27 Aug 2010 08:25:26 -0500
> From: kevin.gritt...@wicourts.gov
> To: lukasz.brodz...@hotmail.com; pgsql-admin@postgresql.org
> Subject: Re: [ADM
*ukasz Brodziak wrote:
> Just want to confirm something. I heard that data files containing
> tables also keep information on tuple(row) changes so is it true
> and if so how to get this data from the files?
Are you looking for statistics or the actual prior versions of rows?
-Kevin
--
Sent
11 matches
Mail list logo
