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;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0028149

closed

alostale

update.database tries to delete pg_stat_statments and pg_stat_statments_reset

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2017-05-24 15:16	alostale	New Issue
2017-05-24 15:16	alostale	Assigned To	=> platform
2017-05-24 15:16	alostale	OBNetwork customer	=> No
2017-05-24 15:16	alostale	Modules	=> Core
2017-05-24 15:16	alostale	Triggers an Emergency Pack	=> No
2017-05-24 15:16	alostale	Relationship added	related to 0028149
2017-05-24 15:16	alostale	Status	new => acknowledged
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base