Re: Database modelling question for version management - Mailing list pgsql-general

From Ron Johnson
Subject Re: Database modelling question for version management
Date
Msg-id 1061123868.18259.18.camel@haggis
Whole thread Raw
In response to Database modelling question for version management of data  (Gianni Mariani <gianni@mariani.ws>)
List pgsql-general
On Sun, 2003-08-17 at 04:05, Gianni Mariani wrote:
> I'm sure this problem has been solved by someone.
>
> I am designing a retail product database and I need to "version control"
> the contents of the database.  The requirements include rollback,
> branching, merging etc.
>
> I can think of some fairly expensive techniques to manage the data but I
> was wondering if someone has some insights into some optimizations.

triggers and history tables?

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+



pgsql-general by date:

Previous
From: stephane parenton
Date:
Subject: insert and heritage...
Next
From: stephane parenton
Date:
Subject: Re: insert and heritage...