Re: Upgrading OGo

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
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users