Re: [ADMIN] Tuple changes from relfilenodes

2010-08-31 Thread Bruce Momjian
Kevin Grittner wrote: *ukasz Brodziaklukasz.brodz...@hotmail.com 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

[ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Łukasz Brodziak
Hello, 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?

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Kevin Grittner
*ukasz Brodziaklukasz.brodz...@hotmail.com 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

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Łukasz Brodziak
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: [ADMIN] Tuple changes from

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Kevin Grittner
*ukasz Brodziaklukasz.brodz...@hotmail.com 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

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Craig James
...@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 (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Lukasz Brodziak
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: I'm looking for actual versions

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Bill MacArthur
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

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Łukasz Brodziak
@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 result is a kind of data change history. We just use ON DELETE rules

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Craig James
, 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 achieve as a final result is a kind of data change history

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Kevin Grittner
*ukasz Brodziaklukasz.brodz...@hotmail.com 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.

Re: [ADMIN] Tuple changes from relfilenodes

2010-08-27 Thread Bill MacArthur
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