Horton

Tighten pg_get_object_address argument checking

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 2da8c4cff39328897aa716a0ba57bdada5aeaf6e
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2022-09-21T13:42:35Z
Releases: 16.0 
Tighten pg_get_object_address argument checking

For publication schemas (OBJECT_PUBLICATION_NAMESPACE) and user
mappings (OBJECT_USER_MAPPING), pg_get_object_address() checked the
array length of the second argument, but not of the first argument.
If the first argument was too long, it would just silently ignore
everything but the first argument.  Fix that by checking the length of
the first argument as well.

Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/caaef70b-a874-1088-92ef-5ac38269c33b%40enterprisedb.com

Files

PathChange+/−
src/backend/catalog/objectaddress.c modified +8 −2
src/test/regress/expected/object_address.out modified +11 −5
src/test/regress/sql/object_address.sql modified +1 −1

Discussion