Re: Database modelling question for version management

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database modelling question for version management
Date: 2003-08-17 12:37:48
Message-ID: 1061123868.18259.18.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stephane parenton 2003-08-17 12:51:34 Re: insert and heritage...
Previous Message stephane parenton 2003-08-17 11:57:29 insert and heritage...