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 <masao.fujii@gmail.com> Reviewed-by: Tristan Partin <tristan@partin.io> Discussion: https://postgr.es/m/CAHGQGwGNTaXnBKUV510_P1KwhdbHT+kgZ4zU5njBHy7nCqdhzg@mail.gmail.com
PostgreSQL Database Management System
This directory contains the source code distribution of the PostgreSQL database management system.
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This distribution also contains C language bindings.
Copyright and license information can be found in the file COPYRIGHT.
General documentation about this version of PostgreSQL can be found at https://www.postgresql.org/docs/devel/. In particular, information about building PostgreSQL from the source code can be found at https://www.postgresql.org/docs/devel/installation.html.
The latest version of this software, and related software, may be obtained at https://www.postgresql.org/download/. For more information look at our web site located at https://www.postgresql.org/.