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

Re: Tuple changes from relfilenodes

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Tuple changes from relfilenodes
Date: 2010-08-27 17:04:39
Message-ID: 4C77F027.7040508@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

>  > Date: Fri, 27 Aug 2010 08:25:26 -0500
>  > From: Kevin(dot)Grittner(at)wicourts(dot)gov
>  > To: lukasz(dot)brodziak(at)hotmail(dot)com; pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
>  > To make changes to your subscription:
>  > http://www.postgresql.org/mailpref/pgsql-admin


In response to

Responses

pgsql-admin by date

Next:From: Lukasz BrodziakDate: 2010-08-27 17:09:08
Subject: Re: Tuple changes from relfilenodes
Previous:From: Kevin GrittnerDate: 2010-08-27 16:56:20
Subject: Re: Tuple changes from relfilenodes

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