471181 - upgrade from 3.0.5 to 3.2 raise database error on longdescs table with PostgreSQL backend

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[alex]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.0.1) Gecko/2008072523 (Gentoo) Firefox/3.0.1
Build Identifier: Bugzilla 3.2

I'm upgrading my Bugzilla installation 3.0.5 to the 3.2.
Database backend is running on a separate server, PostgreSQL 8.1.9


Reproducible: Always

Steps to Reproduce:
1. Install the new Bugzilla on the top of old installation
2. Run perl checksetup.pl

Actual Results:  
DBD::Pg::db do failed: ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view t1 depends on column "thetext"
 at Bugzilla/DB.pm line 568
        Bugzilla::DB::bz_alter_column_raw('Bugzilla::DB::Pg=HASH(0x33c4ba0)', 'longdescs', 'thetext', 'HASH(0x31fd050)', 'HASH(0x3872650)', '') called at Bugzilla/DB.pm line 527
        Bugzilla::DB::bz_alter_column('Bugzilla::DB::Pg=HASH(0x33c4ba0)', 'longdescs', 'thetext', 'HASH(0x31fd050)', '') called at Bugzilla/Install/DB.pm line 479
        Bugzilla::Install::DB::update_table_definitions('HASH(0xb21ae0)') called at checksetup.pl line 195

Expected Results:  
A smooth database upgrade.

To let my upgrade process running and since PostgreSQL only uses TEXT as column type, I've commented out the corresponding line in Bugzilla/Install/DB.pm arround line 479 : 

#    $dbh->bz_alter_column('longdescs', 'thetext',
#        {TYPE => 'LONGTEXT', NOTNULL => 1}, '');

and 2950 :

# $dbh->bz_alter_column('longdescs', 'thetext',
#     { TYPE => 'LONGTEXT', NOTNULL => 1 });

Comment 1

[Frédéric Buclin]

(In reply to comment #0)
> DETAIL:  rule _RETURN on view t1 depends on column "thetext"

view t1?? Unless I miss something in the internals of Pg, we don't use views at all.