0036089: exclude from updates all DB objects created by extensions

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036089

Openbravo ERP

Y. DBSourceManager

public

2017-05-24 15:16

2022-02-01 08:08

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0036089: exclude from updates all DB objects created by extensions

Description

Even all functions starting with PG_ are excluded by export/update database task, there are some other PostrgreSQL extensions that add DB objects starting with a different prefix.

This forces to create ad-hoc exclude filters for each of the installed extensions.

Steps To Reproduce

1. install pgstattuple extension [1]
2. execute update.database
-> log contains errors

[1] https://www.postgresql.org/docs/current/static/pgstattuple.html [^]

Proposed Solution

Exclude DB objects created by extensions, not defining exclude filters but checking in PG catalog whether they are user or extension objects.

tip: check if this query covers all cases

SELECT ext.extname, ext.extnamespace, ext.extrelocatable, pg_catalog.pg_describe_object(dep.classid, dep.objid, 0) AS "Object Description"
FROM pg_catalog.pg_depend dep JOIN pg_catalog.pg_extension ext on dep.refobjid = ext.oid
WHERE dep.refclassid = 'pg_catalog.pg_extension'::pg_catalog.regclass AND dep.deptype = 'e'
ORDER BY 1;

Additional Information