gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] GNUmed Release 0.3.4


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] GNUmed Release 0.3.4
Date: Tue, 28 Oct 2008 16:11:15 +0100
User-agent: Mutt/1.5.18 (2008-05-17)

On Tue, Oct 28, 2008 at 07:51:44AM -0700, Jim Busser wrote:

>> Database:
>>
>> 1) if you are running a gnumed_v9 database already
>>
>> - download the v9 server tarball
>> - go to server/sql/v8-v9/fixups/
>> - edit v9-i18n-dynamic.sql:
>>        - remove the "--" before "set default_transaction_read_only to 
>> off"
>> - run the script like this:
>>        psql -d gnumed_v9 -U gm-dbo -f v9-i18n-dynamic.sql
>>        (you can safely repeat this procedure any number of times)
>
> Just wondering how the above client depends on any existing v9 database 
> to get "changed"

An error happened on the SQL side of things (function
i18n.get_curr_lang() under certain circumstances) which then
resulted in a follow-up error in the client. So, if that
error affects a certain installation it should run the fixup
script against the database.

> and why a freshly-created v9 would not need the same 
> thing to be done.
Because it includes the fixup script by default.

> Is the dependency or problem outside of the bootstrapper? IOW, was it  
> the pre-0.3.4 clients which had "done something " to existing v9  
> databases? The bootstrapper is therefore unchanged, and client 0.3.4+  
> will avoid committing the problem, but any affected (already-touched- 
> by-pre-0.3.4) v9 needs to be manually fixed using the psql script?

It wasn't the client "doing" something untoward. The client
just suffered from the SQL function inside the database
sometimes malfunctioning. The bootstrapper ran fine, too, it
just installed the sometimes-malfunctioning SQL function
into the database (as instructed to do). The fix that is now
available is that the SQL function has been corrected and
works properly now. So, existing gnumed_v9 where keeping the
data is wanted need to be fixed manually while freshly
bootstrapped gnumed_v9's will have the fix automatically.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346




reply via email to

[Prev in Thread] Current Thread [Next in Thread]