[Spacewalk-list] Spacewalk schema upgrade 0.3 to 0.4

[Milan Zazrivec]

On Monday 19 January 2009 14:14:55 Scott Page wrote:
> Hi all
>
>      I was following the upgrade instructions on the wiki and got the
> following in my log.
>
>
> 'SPACEWALK-SCHEMA-0.3-TO-SPACEWALK-SCHEMA-0.4/156-RHNPACKAGE-COMPAT-NUMBER.
>SQ
> ---------------------------------------------------------------------------
>--
> spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.s
>ql
>
> SQL> --
> SQL> -- Copyright (c) 2008 Red Hat, Inc.
> SQL> --
> SQL> -- This software is licensed to you under the GNU General Public
> License,
> SQL> -- version 2 (GPLv2). There is NO WARRANTY for this software,
> express or
> SQL> -- implied, including the implied warranties of MERCHANTABILITY or
> FITNESS
> SQL> -- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
> SQL> -- along with this software; if not, see
> SQL> -- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
> SQL> --
> SQL> -- Red Hat trademarks are not licensed under GPLv2. No permission is
> SQL> -- granted to use or replicate Red Hat trademarks that are
> incorporated SQL> -- in this software or its documentation.
> SQL> --
> SQL> --
> SQL> -- $Id$
> SQL> --
> SQL>
> SQL> alter TABLE rhnPackage MODIFY (compat number(1));
> alter TABLE rhnPackage MODIFY (compat number(1))
>                                 *
> ERROR at line 1:
> ORA-01440: column to be modified must be empty to decrease precision or
> scale

Please see https://bugzilla.redhat.com/show_bug.cgi?id=480618

-Milan