0044901: PostgreSQL fails applying changes to columns used in views (during install.source)

Description

Running install.source having a template increasing a column length while at the same time having a view using that column fails on PostgreSQL (unknown if also oracle).

ORA fails applying changes to columns used in functional indexes

Example:
Loading config script for module from path <hidden>/modules/org.openbravo.openbravoatopenbravo.template/src-db/database/configScript.xml
SQL Command failed with: ERROR: cannot alter type of a column used by a view or rule
Detail: rule _RETURN on view obzdint_partners_v depends on column "name"
-- END
ALTER TABLE C_BPARTNER ALTER COLUMN NAME TYPE VARCHAR(150)

Steps To Reproduce

Create configScript modifying length of name column while having a view created using that column.
Example discovered in current ob@ob code (for this and several other columns).

Proposed Solution

Probably idea of 44892 which is part of fixing 44612 will fix this problem 'for free' (for the install.source part)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0044612	closed	Triage Platform Base	ORA fails applying changes to columns used in functional indexes
related to	defect	0044892	closed	alostale	On install.source config scripts are applied in two steps
related to	feature request	0050243	closed	aferraz	Increase the Column size for Product Characteristics Description

Notes
(0139720) shuehner (administrator) 2022-07-29 13:17	Adding 4 weeks SLA after chat ALO/SHU

(0142872) hgbot (developer) 2022-11-03 12:40	Repository: https://gitlab.com/openbravo/product/dbsm [^] Changeset: 7c083a878d524051d35fa2b0eb3bb68ab04de8a4 Author: Asier Lostalé <asier.lostale@openbravo.com> Date: 03-11-2022 11:24:30 URL: https://gitlab.com/openbravo/product/dbsm/-/commit/7c083a878d524051d35fa2b0eb3bb68ab04de8a4 [^] [create-db] related to BUG-44901: adds test case --- A src-test/model/configScripts/BASE_MODEL_VIEW.xml M src-test/src/org/openbravo/dbsm/test/configscript/ConfigScriptColumnSizeChange.java ---

(0142878) alostale (viewer) 2022-11-03 12:42	Fixed by 0044892

Issue History
Date Modified	Username	Field	Change
2020-08-26 14:41	shuehner	New Issue
2020-08-26 14:41	shuehner	Assigned To	=> platform
2020-08-26 14:41	shuehner	OBNetwork customer	=> No
2020-08-26 14:41	shuehner	Modules	=> Core
2020-08-26 14:41	shuehner	Triggers an Emergency Pack	=> No
2020-08-26 14:41	shuehner	Relationship added	related to 0044612
2020-08-26 14:41	shuehner	Relationship added	related to 0044892
2022-02-01 07:24	alostale	Assigned To	platform => Triage Platform Base
2022-07-29 13:17	shuehner	OBNetwork customer	No => OBPS
2022-07-29 13:17	shuehner	Note Added: 0139720
2022-11-03 12:40	hgbot	Note Added: 0142872
2022-11-03 12:42	alostale	Note Added: 0142878
2022-11-03 12:42	alostale	Status	new => closed
2022-11-03 12:42	alostale	Resolution	open => fixed
2022-11-03 12:42	alostale	Fixed in Version	=> PR23Q1
2022-11-08 17:41	aferraz	Relationship added	related to 0050243