Not all object types are listed by listOwnedObjects (M) - Githubissues

DASSL / ClassDB

An open-source system to let students experiment with relational data

https://dassl.github.io/ClassDB/

Other

8 stars 2 forks source link

Not all object types are listed by listOwnedObjects (M) #244

Open afig opened 6 years ago

afig commented 6 years ago

As was known when PR #116 was merged, not all possible object types are listed by ClassDB.listOwnedObjects(). This became an problem in Issue #221 / PR #241, where listOwnedObjects() is used to obtain a list of objects to reassign ownership of all owned objects in a schema.

Currently, listOwnedObjects() lists the following types of objects:

Tables
Indexes
Sequences
Views
Materialized Views
Composite types (incorrectly called "types")
TOASTs
Foreign Tables
Functions (without parameters)

It does not list:

Domains
Operators
Non-composite types (Enumerated, Base, and Array)
Event Triggers
Servers
Text Search Configurations
Possibly others