doc: Clarify pg_get_sequence_data() privileges and NULL results The documentation for pg_get_sequence_data() did not match the function's behavior. It stated that either USAGE or SELECT privilege was sufficient, but the function returns sequence data only when the caller has SELECT privilege.
The documentation also did not explain that the function returns a row containing all NULL values when sequence data cannot be returned, such as when the sequence does not exist or the caller lacks the required privilege. Update the documentation to reflect the actual behavior, including the required privilege and the result returned when sequence data is unavailable. Author: Fujii Masao <[email protected]> Reviewed-by: Tristan Partin <[email protected]> Discussion: https://postgr.es/m/cahgqgwgntaxnbkuv510_p1kwhdbht+kgz4zu5njbhy7ncqd...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/031904048aa22e7c70dc8e9c170e2743f9b0f090 Modified Files -------------- doc/src/sgml/func/func-sequence.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-)
