0042080: Views are not being taken into account in the ad_db_modified function in PostgreSQL

Description

The ad_db_modified function is used to detect if there are local changes in the database before updating it. It checks several database objects, like tables, functions, triggers, etc.

The problem is that in the postgresql version, views are not being taken into account. So, if someone creates a new view in the database, that view will be dropped the next time update.database is run, because the local changes will not be detected.

Steps To Reproduce

In an Openbravo environment that uses postgresql:
- Execute update.database to make sure there are no local changes to begin with.
- Add a new view, for instance:

    create view c_order_v as
    select * from c_order;

    ALTER TABLE public.c_order_v
      OWNER TO tad;
- Execute update.database again. It should fail because there are local changes in the database, but it does not detect them.
- Check that the view created in step 2 no longer exists:
select * from pg_class where relname ilike 'c_order_v'; (or \d c_order_v in psql)

Issue History
Date Modified	Username	Field	Change
2019-10-22 09:48	AugustoMauch	New Issue
2019-10-22 09:48	AugustoMauch	Assigned To	=> platform
2019-10-22 09:48	AugustoMauch	Modules	=> Core
2019-10-22 09:48	AugustoMauch	Triggers an Emergency Pack	=> No
2022-02-01 07:24	alostale	Assigned To	platform => Triage Platform Base

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.