diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2022-11-16 19:44:38 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2022-11-16 19:44:38 +0100 |
| commit | 90e4f308b42b12bd66262c52fc4845bd0443c6e0 (patch) | |
| tree | 538a436808604a1ea10ad7ee3cb1ebdf6e732f2b /src | |
| parent | fccaf259f22f4aedc02033516c561ca86903077d (diff) | |
| download | postgresql-90e4f308b42b12bd66262c52fc4845bd0443c6e0.tar.gz postgresql-90e4f308b42b12bd66262c52fc4845bd0443c6e0.zip | |
Add missing object classes to object_address test
Per the comment, fill in classes mentioned in getObjectIdentityParts()
but not in the test.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/object_address.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/object_address.sql | 3 |
2 files changed, 9 insertions, 0 deletions
diff --git a/src/test/regress/expected/object_address.out b/src/test/regress/expected/object_address.out index dadd58e8b9c..a0a9c90d6af 100644 --- a/src/test/regress/expected/object_address.out +++ b/src/test/regress/expected/object_address.out @@ -569,6 +569,7 @@ WITH objects (classid, objid, objsubid) AS (VALUES ('pg_ts_template'::regclass, 0, 0), -- no TS template ('pg_ts_config'::regclass, 0, 0), -- no TS configuration ('pg_authid'::regclass, 0, 0), -- no role + ('pg_auth_members'::regclass, 0, 0), -- no role membership ('pg_database'::regclass, 0, 0), -- no database ('pg_tablespace'::regclass, 0, 0), -- no tablespace ('pg_foreign_data_wrapper'::regclass, 0, 0), -- no FDW @@ -577,8 +578,10 @@ WITH objects (classid, objid, objsubid) AS (VALUES ('pg_default_acl'::regclass, 0, 0), -- no default ACL ('pg_extension'::regclass, 0, 0), -- no extension ('pg_event_trigger'::regclass, 0, 0), -- no event trigger + ('pg_parameter_acl'::regclass, 0, 0), -- no parameter ACL ('pg_policy'::regclass, 0, 0), -- no policy ('pg_publication'::regclass, 0, 0), -- no publication + ('pg_publication_namespace'::regclass, 0, 0), -- no publication namespace ('pg_publication_rel'::regclass, 0, 0), -- no publication relation ('pg_subscription'::regclass, 0, 0), -- no subscription ('pg_transform'::regclass, 0, 0) -- no transformation @@ -598,6 +601,7 @@ ORDER BY objects.classid, objects.objid, objects.objsubid; ("(relation,,,)")|("(relation,,)")|NULL ("(""table column"",,,)")|("(""table column"",,)")|NULL ("(role,,,)")|("(role,,)")|NULL +("(""role membership"",,,)")|("(""role membership"",,)")|NULL ("(database,,,)")|("(database,,)")|NULL ("(server,,,)")|("(server,,)")|NULL ("(""user mapping"",,,)")|("(""user mapping"",,)")|NULL @@ -630,5 +634,7 @@ ORDER BY objects.classid, objects.objid, objects.objsubid; ("(subscription,,,)")|("(subscription,,)")|NULL ("(publication,,,)")|("(publication,,)")|NULL ("(""publication relation"",,,)")|("(""publication relation"",,)")|NULL +("(""publication namespace"",,,)")|("(""publication namespace"",,)")|NULL +("(""parameter ACL"",,,)")|("(""parameter ACL"",,)")|NULL -- restore normal output mode \a\t diff --git a/src/test/regress/sql/object_address.sql b/src/test/regress/sql/object_address.sql index e91072a75d1..e9c80437014 100644 --- a/src/test/regress/sql/object_address.sql +++ b/src/test/regress/sql/object_address.sql @@ -263,6 +263,7 @@ WITH objects (classid, objid, objsubid) AS (VALUES ('pg_ts_template'::regclass, 0, 0), -- no TS template ('pg_ts_config'::regclass, 0, 0), -- no TS configuration ('pg_authid'::regclass, 0, 0), -- no role + ('pg_auth_members'::regclass, 0, 0), -- no role membership ('pg_database'::regclass, 0, 0), -- no database ('pg_tablespace'::regclass, 0, 0), -- no tablespace ('pg_foreign_data_wrapper'::regclass, 0, 0), -- no FDW @@ -271,8 +272,10 @@ WITH objects (classid, objid, objsubid) AS (VALUES ('pg_default_acl'::regclass, 0, 0), -- no default ACL ('pg_extension'::regclass, 0, 0), -- no extension ('pg_event_trigger'::regclass, 0, 0), -- no event trigger + ('pg_parameter_acl'::regclass, 0, 0), -- no parameter ACL ('pg_policy'::regclass, 0, 0), -- no policy ('pg_publication'::regclass, 0, 0), -- no publication + ('pg_publication_namespace'::regclass, 0, 0), -- no publication namespace ('pg_publication_rel'::regclass, 0, 0), -- no publication relation ('pg_subscription'::regclass, 0, 0), -- no subscription ('pg_transform'::regclass, 0, 0) -- no transformation |