[prev in list] [next in list] [prev in thread] [next in thread] 

List:       opengroupware-users
Subject:    Re: [OGo-Users] Upgrading OGo
From:       Adam Tauno Williams <awilliam () whitemice ! org>
Date:       2009-03-13 10:24:39
Message-ID: 1236939879.9159.15.camel () linux-m3mt
[Download RAW message or body]

On Fri, 2009-03-13 at 09:39 +0000, Daniel Pocock wrote:
> > > - Should I expect issues upgrading my existing schema (svn 2077) to the 
> > > current version?
> > The only schema change is the one mentioned at
> > <http://whitemiceconsulting.blogspot.com/2009/01/opengroupware-postgresql-8.html> \
> > this change is included [I believe] in the packages on the build repository. But \
> > some are forth coming, I believe;  when they happen it will be (a) announced here \
> > (b) I'll post a BLOG entry, and (c) it will be documented in WMOGAG.
> > <http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>
> Thanks for the prompt answers. 
> - Is there any version information in the schema, or do I just have to 
> manually inspect the tables to see if they need the changes?

There is a table_version table;  but I'm not sure what uses it.  Schema
changes have been incredibly rare.   There are "upgrade" scripts,
usually installed somewhere like
"/usr/share/opengroupware.org-1.1/dbsetup/PostgreSQL/" which update the
table_versions table.  But the schema hasn't changed that I can recall
(been using OGo since late 2003).

> - Do the package scripts automatically check the schema versions (even 
> if only in the stable releases)?

No.

> - Will OGo refuse to run if started with a schema version that doesn't 
> match?

If the core tables exist it will start running;  some tables are
technically optional (you can run OGo without ACLs, and some other
bits).  But AFAIK nobody actually does so, so I don't know how tested it
is.

-- 
OpenGroupware.org Users
users@opengroupware.org
http://mail.opengroupware.org/mailman/listinfo/users


[prev in list] [next in list] [prev in thread] [next in thread]