Re: [SQL] thinking about versioning my database schema

From: "Dan Langille" <dan(at)langille(dot)org>
To: Janning Vygen <vygen(at)gmx(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] thinking about versioning my database schema
Date: 2002-03-04 07:51:47
Message-ID: 200203040751.g247pnk73214@lists.unixathome.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

On 4 Mar 2002 at 8:10, Janning Vygen wrote:

> So i am saving the schema version inside the databse. Is it a good
> idea? or is it nonsens and there is a much better way how to do it?

I have a system table. One of the fields is the database version. If I
change the schema, I modify the version. The applications knows what
version it can run with. If it finds an older version, it reports this ot
the user and suggests they upgrade their database.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Manuel Trujillo 2002-03-04 08:14:42 Log's stopped.
Previous Message Janning Vygen 2002-03-04 07:10:24 thinking about versioning my database schema

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas F. 2002-03-04 11:46:46 confusing inheritance
Previous Message David BOURIAUD 2002-03-04 07:49:50 Re: About persistent connections...