[OPEN-ILS-DEV] Proposed modification to 1.6.0.4-1.6.1.0-upgrade-db.sql

[Joe Atzberger]

On Wed, Nov 10, 2010 at 9:40 AM, Mike Rylander <mrylander at gmail.com> wrote:

> On Mon, Nov 8, 2010 at 3:07 PM, Peters, Michael <MRPeters at library.in.gov>
> wrote:
> > Hi all,
> >
> > In working through the process of updating a 1.6.0.0 test server to 2.0
> > Alpha 5 I ran across a problem with this particular upgrade.  It was
> > impossible for me to excute line 531 of the old script:
> >
> > ALTER TABLE acq.purchase_order ADD COLUMN name TEXT NOT NULL;
> >
> > I modified line 531 to first give the name column an empty string for a
> > name, then later added the “NOT NULL” constraint on this column via the
> new
> > line 532.
> >
>
> Because the acq schema is entirely non-authoritative until 2.0, I
> suggest we simply delete any data from this table (and others that may
> suffer similar issues) during upgrade.
>
> Thoughts, folks?
>
>
Even if the data is "premature", I don't see the point of destroying it when
a workaround exists.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20101115/f7923bf7/attachment.htm