PostgreSQL 18 support #711
Description
Hello,
I am running functional test on PostgreSQL 18dev and the test_nominal.py failed with following messages.
testlog_18dev.log
=============== short test summary info ===============
ERROR test/test_nominal.py::test_roles - sh.ErrorReturnCode_1:
RAN: /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --real
STDOUT:
STDERR:
ERROR test/test_nominal.py::test_re_grant - sh.ErrorReturnCode_1:
RAN: /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --real
STDOUT:
STDERR:
ERROR test/test_nominal.py::test_re_revoke - sh.ErrorReturnCode_1:
RAN: /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --real
STDOUT:
STDERR:
ERROR test/test_nominal.py::test_nothing_to_do - sh.ErrorReturnCode_1:
RAN: /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --real
STDOUT:
STDERR:
=========== 8 passed, 1 xfailed, 4 errors in 13.21s ===========
Errors were observed at below steps.
+ /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --check
time=2025-03-28T15:16:09.648+09:00 level=ERROR msg="Failed to inspect privileges." acl="ALL SEQUENCES IN SCHEMA" database=nominal err="ALL SEQUENCES IN SCHEMA: ERROR: set-valued function called in context that cannot accept a set (SQLSTATE 0A000)"
time=2025-03-28T15:16:09.649+09:00 level=ERROR msg="Failed to inspect privileges." acl="ALL TABLES IN SCHEMA" database=nominal err="ALL TABLES IN SCHEMA: ERROR: set-valued function called in context that cannot accept a set (SQLSTATE 0A000)"
+ /home/postgres/ldap2pg/ldap2pg -c ldap2pg.yml --real
time=2025-03-28T15:16:09.812+09:00 level=ERROR msg="Synchronisation error." err="ERROR: permission denied to drop role (SQLSTATE 42501)"
time=2025-03-28T15:16:09.812+09:00 level=CHANGE msg="Reassign objects and purge ACL." role=nicolas owner=nominal database=nominal
time=2025-03-28T15:16:09.813+09:00 level=CHANGE msg="Drop role." role=nicolas database=nominal
time=2025-03-28T15:16:09.814+09:00 level=ERROR msg="Synchronisation error." err="ERROR: permission denied to drop role (SQLSTATE 42501)"
time=2025-03-28T15:16:09.816+09:00 level=CHANGE msg="Revoke privileges." grant="CONNECT ON DATABASE nominal TO public" database=nominal
time=2025-03-28T15:16:09.818+09:00 level=CHANGE msg="Revoke privileges." grant="TEMPORARY ON DATABASE nominal TO public" database=nominal
time=2025-03-28T15:16:09.819+09:00 level=CHANGE msg="Grant privileges." grant="CONNECT ON DATABASE nominal TO readers" database=nominal
time=2025-03-28T15:16:09.820+09:00 level=CHANGE msg="Grant privileges." grant="TEMPORARY ON DATABASE nominal TO writers" database=nominal
time=2025-03-28T15:16:09.827+09:00 level=ERROR msg="Failed to inspect privileges." acl="ALL SEQUENCES IN SCHEMA" database=nominal err="ALL SEQUENCES IN SCHEMA: ERROR: set-valued function called in context that cannot accept a set (SQLSTATE 0A000)"
time=2025-03-28T15:16:09.828+09:00 level=ERROR msg="Failed to inspect privileges." acl="ALL TABLES IN SCHEMA" database=nominal err="ALL TABLES IN SCHEMA: ERROR: set-valued function called in context that cannot accept a set (SQLSTATE 0A000)"