Tom Lane <t...@sss.pgh.pa.us> writes: > =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= <ilm...@ilmari.org> writes: >> Tom Lane <t...@sss.pgh.pa.us> writes: >>> I wonder if it'd be a good idea to convert >>> auto_explain's TAP test to load auto_explain via session_preload_libraries >>> instead of shared_preload_libraries, and then pass in the settings for >>> each test via PGOPTIONS instead of constantly rewriting postgresql.conf. > >> That whole config-file rewriting did feel a bit icky when I added more >> tests recently, but I completely forgot about PGOPTIONS and -c. >> Something like the attached is indeed much nicer. > > Thanks! I added a test to verify the permissions-checking issue > and pushed it.
Thanks! Just one minor nitpick: setting an %ENV entry to `undef` doesn't unset the environment variable, it sets it to the empty string. To unset a variable it needs to be deleted from %ENV, i.e. `delete $ENV{PGUSER};`. Alternatively, wrap the relevant tests in a block and use `local`, like in the `query_log` function. > regards, tom lane - ilmari