Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> This is with PostgreSQL 10.4.
> How to reproduce :
> dynacom=# ALTER ROLE amura3 SET search_path TO "$user", amuragents, public;
> ALTER ROLE
> ...
> dynacom=> show search_path ;
> search_path
> ---------------------------
> $user, amuragents, public
> (1 row)
Hm, that's not happening for me:
regression=# alter user joe set search_path to "$user", public;
...
regression=> show search_path ;
search_path
-----------------
"$user", public
(1 row)
and then pg_dumpall produces
ALTER ROLE joe SET search_path TO "$user", public;
There was a relevant bug fix in March (commit 742869946) ...
are you certain this is a 10.4 server, and not 10.3 or older?
regards, tom lane