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: | Raw Message | Whole Thread | 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
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 |
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... |