Re: Possible regression setting GUCs on \connect

On 4/27/23 21:16, Tom Lane wrote:
> David Steele <david(at)pgmasters(dot)net> writes:
>> Seems plausible. This can be reproduced by cloning [1] into contrib and
>> running `make check`. I can work out another test case but it may not
>> end up being simpler.
>> [1] https://github.com/pgaudit/pgaudit/tree/dev-pg16-ci
>
> I tried to replicate this per that recipe, but it works for me:
>
> $ git clone https://github.com/pgaudit/pgaudit.git pgaudit
> $ cd pgaudit
> $ git checkout dev-pg16-ci
> $ make -s check
> # +++ regress check in contrib/pgaudit +++
> # using temp instance on port 61696 with PID 1191703
> ok 1 - pgaudit 310 ms
> 1..1
> # All 1 tests passed.

I included the errors in the expect log so I could link to them. So test
success means the error is happening.

> Note that I had to add
>
> $ diff -pud Makefile~ Makefile
> --- Makefile~ 2023-04-27 14:02:19.041714415 -0400
> +++ Makefile 2023-04-27 14:07:10.056909016 -0400
> @@ -20,3 +20,5 @@ top_builddir = ../..
> include $(top_builddir)/src/Makefile.global
> include $(top_srcdir)/contrib/contrib-global.mk
> endif
> +
> +EXTRA_INSTALL += contrib/pg_stat_statements

Yeah, I rarely run tests in-tree, but I'll add this if it does not break
our regular CI.

-David