pgsql: Add TAP tests for include directives in HBA end ident files
Add TAP tests for include directives in HBA end ident files This commit adds a basic set of authentication tests to check after the new keywords added by a54b658 for the HBA and ident files, aka "include", "include_if_exists" and "include_dir". This includes checks for all the positive cases originally proposed, where valid contents are generated for the HBA and ident files without any errors happening in the server, checking as well the contents of their respective system views. The error handling will be evaluated separately (-DEXEC_BACKEND makes that trickier), and what we have here covers most of the ground I would like to see covered if one manipulates the tokenization logic of hba.c in the future. While on it, some coverage is added for files included with '@' for database or user name lists. Author: Julien Rouhaud Reviewed-by: Michael Paquier Discussion: https://postgr.es/m/20220223045959.35ipdsvbxcstrhya@jrouhaud Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/cbe6e482d7bf851c6e466697a21dcef7b05cbb59 Modified Files -- src/test/authentication/meson.build | 1 + src/test/authentication/t/004_file_inclusion.pl | 298 2 files changed, 299 insertions(+)
pgsql: Doc: update queries.sgml for optional subquery aliases.
Doc: update queries.sgml for optional subquery aliases. Commit bcedd8f5f made subquery aliases optional in the FROM clause. It missed updating this part of the docs, though. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ec25ba624e9c0168d44c9f6e87872f1e3e6b308f Modified Files -- doc/src/sgml/queries.sgml | 18 -- 1 file changed, 12 insertions(+), 6 deletions(-)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/68d89d80c3db06ad080a0f291e165456fb2f51f7 Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f3f70b8de66c0bae86f4761e152c10dd39f6f179 Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b5d8fd4182f24ee489aa6bb72308f8712cd8810d Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/724dd5649079a38193793c00292419917969effb Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ccc59a83cd977608564a6f11ffcb2ec1773a9e94 Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
pgsql: Fix binary mismatch for MSVC plperl vs gcc built perl libs
Fix binary mismatch for MSVC plperl vs gcc built perl libs When loading plperl built against Strawberry perl or the msys2 ucrt perl that have been built with gcc, a binary mismatch has been encountered which looks like this: loadable library and perl binaries are mismatched (got handshake key 12800080, needed 12900080) To cure this we bring the handshake keys into sync by adding NO_THREAD_SAFE_LOCALE to the defines used to build plperl. Discussion: https://postgr.es/m/20211005004334.tgjmro4kuachw...@alap3.anarazel.de Discussion: https://postgr.es/m/c2da86a0-2906-744c-923d-16da60478...@dunslane.net Backpatch to all live branches. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/85565cbcad4a78dab5a60c457b0f6e0a740539ce Modified Files -- src/tools/msvc/Mkvcbuild.pm | 3 +++ 1 file changed, 3 insertions(+)
