Strictly speaking this is a uc_views/uc_views_marketing issue - but not sure how cross-module issues should be reported.

Upgrading from 2.6 to 2.9 I got -
warning: pg_query(): Query failed:
ERROR: cannot drop table nls_uc_order_products column qty_old because other objects depend on it
DETAIL:
view nls_uc_order_products_qty_vw depends on table nls_uc_order_products column qty_old
view nls_uc_order_products_user_vw depends on table nls_uc_order_products column qty_old
view nls_uc_order_products_pair_vw depends on table nls_uc_order_products column qty_old
HINT: Use DROP ... CASCADE to drop the dependent objects too. in /var/www/drupal-nls/includes/database.pgsql.inc on line 138.

The col rename sql updates all related objects in DB - eg views. When new qty col added - the views defnition is naturally not renamed back. If run manually with CASCADE - update succeeds but seemed to knock out the views - created in uc_views_marketing:
I recreated these manually from a dump.

Comments

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Title: update Update #6020 Postgres update fails - ALTER TABLE {uc_order_products} DROP COLUMN qty_old » Ubercart update #6020 Postgres update fails - ALTER TABLE {uc_order_products} DROP COLUMN qty_old
Project: Ubercart » Ubercart Views
Version: 6.x-2.9 » 6.x-3.x-dev
Component: Products » Code

The Ubercart update fails, but there is nothing Ubercart can or should do to protect against this.

This is yet another problem caused by the use of SQL views in uc_views_marketing, but not really sure what we can do about it here either :(

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Issue summary: View changes

Add note on uc_views/uc_views_marketing