Table Update Systems (was: chosing a database name)

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: Richard_D_Levine(at)raytheon(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Table Update Systems (was: chosing a database name)
Date: 2005-07-13 22:23:06
Message-ID: 42D5944A.8090607@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I think a better approach is to handle configuration management with a
> table in each schema. Update the schema, update the table. This works
> well with automating database upgrades as well, where upgrades are written
> as scripts, and applied in a given order to upgrade a database from release
> A to C, or A to X, depending on when it was archived. A script naming
> convention (e.g. numerical) can determine order, and each script can
> register in (write a line to) the configuration management table. This
> allows for error analysis, among other things.
>
> Rick

I'm currently looking at implementing a system almost exactly like this,
and I was wondering if there is anything around that does this.

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Miller 2005-07-13 22:33:42 Re: Standalone Parser for PL/pgSQL
Previous Message Mark Morgan Lloyd 2005-07-13 22:17:41 Re: Nulls in timestamps