Andrew Dunstan <[email protected]> writes:
> That seems quite weird. I'm not sure how it's getting loaded at all if
> not via shared_preload_libraries
Some other animals are showing this:
diff -U3
/home/postgres/pgsql/src/test/modules/test_oat_hooks/expected/test_oat_hooks.out
/home/postgres/pgsql/src/test/modules/test_oat_hooks/results/test_oat_hooks.out
---
/home/postgres/pgsql/src/test/modules/test_oat_hooks/expected/test_oat_hooks.out
2022-03-22 11:57:40.224991011 -0400
+++
/home/postgres/pgsql/src/test/modules/test_oat_hooks/results/test_oat_hooks.out
2022-03-22 11:59:59.998983366 -0400
@@ -48,6 +48,8 @@
SELECT * FROM regress_test_table;
NOTICE: in executor check perms: superuser attempting execute
NOTICE: in executor check perms: superuser finished execute
+NOTICE: in executor check perms: superuser attempting execute
+NOTICE: in executor check perms: superuser finished execute
t
---
(0 rows)
@@ -95,6 +97,8 @@
^
NOTICE: in executor check perms: non-superuser attempting execute
NOTICE: in executor check perms: non-superuser finished execute
+NOTICE: in executor check perms: non-superuser attempting execute
+NOTICE: in executor check perms: non-superuser finished execute
t
---
(0 rows)
@@ -168,6 +172,8 @@
^
NOTICE: in executor check perms: superuser attempting execute
NOTICE: in executor check perms: superuser finished execute
+NOTICE: in executor check perms: superuser attempting execute
+NOTICE: in executor check perms: superuser finished execute
t
---
(0 rows)
I can duplicate that by adding "force_parallel_mode = regress"
to test_oat_hooks.conf, so a fair bet is that the duplication
comes from executing the same hook in both leader and worker.
regards, tom lane
