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

archiving or versioning data?

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: archiving or versioning data?
Date: 2008-12-17 06:51:11
Message-ID: (view raw or whole thread)
Lists: pgsql-sql

I'd like to find a way to archive versions of my data in an elegant and
extensible way.

When a user modifies certain entries I'd like the database to keep the
previous versions (or a limited, definable number of versions).

Would that be a good use of postgres' arrays? 

So I'm looking for "best practices" (tm) on that subject.

Thanks in advance for your suggestions,



pgsql-sql by date

Next:From: A. KretschmerDate: 2008-12-17 07:12:56
Subject: Re: archiving or versioning data?
Previous:From: Tom LaneDate: 2008-12-17 00:38:10
Subject: Re: pg_clog/0202 Error

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