[OPEN-ILS-DEV] Minor change needed in 1.4 upgrade scripts

[Mike Rylander]

Upgrade script updated.  1.4.0.5 (and later) will have this fix.

On Thu, Apr 9, 2009 at 8:48 PM, John Craig
<jc-mailinglist at alphagconsulting.com> wrote:
> Mike Rylander wrote:
>
> On Thu, Apr 9, 2009 at 2:22 PM, John Craig
> <jc-mailinglist at alphagconsulting.com> wrote:
>
>
> <snip>
>
> a problem in the 1.4 upgrade
> scripts.
>
> <snip>
>
> However, it was lazy of me to do things that way ... so, I'll suggest
> an alternative to your alternative:
>
> INSERT INTO config.circ_matrix_ruleset
> (matchpoint,duration_rule,recurring_fine_rule,max_fine_rule)
>   SELECT  d.id, f.id, m.id
>     FROM   config.rule_circ_duration d
>                 JOIN config.rule_recuring_fine f ON (f.name = d.name)
>                 JOIN config.rule_max_fine m ON (f.name = m.name)
>     WHERE m.name = 'default';
>
> Eh?
>
>
> Looks good to moi....
>
> Thanks, John, for pointing out the deficiency.
>
>
>
> If all I need to do is point out deficiencies, I'm sure I can satisfy ;-)
>
> Actually it wouldn't have been a big deal but it took way too long to figure
> out that the COMMIT of the upgrade had worked...ah, well.
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com