ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" . - Mailing list pgsql-general

From Achilleas Mantzios
Subject ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .
Date
Msg-id b834e08c-fa94-5823-932e-2073ea805e98@matrix.gatewaynet.com
Whole thread Raw
Responses Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" .  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
This is with PostgreSQL 10.4.
How to reproduce :
postgres@smadev:~% psql
psql (10.4)
Type "help" for help.

Alter the role for search path :
dynacom=# ALTER ROLE amura3 SET search_path TO "$user", amuragents, public;
ALTER ROLE
dynacom=#

Verify :
postgres@smadev:~% psql -U amura3
Password for user amura3:
psql (10.4)
Type "help" for help.

dynacom=> show search_path ;
         search_path
---------------------------
  $user, amuragents, public
(1 row)

dynacom=>

pg_dumpall's output :
ALTER ROLE amura3 SET search_path TO $user, amuragents, public;

psql -f pg_dumpall_out.sql :
dynacom=# ALTER ROLE amura3 SET search_path TO $user, amuragents, public;
ERROR:  syntax error at or near "$"

Is this a bug or am I missing something ?

-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt



pgsql-general by date:

Previous
From: vardenis pavardenis
Date:
Subject: Re: Postgresql 10.4 installation issues on Ubuntu 14.05
Next
From: Adrian Klaver
Date:
Subject: Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .