ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .
От
Achilleas Mantzios
Тема
ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" .
Дата
Msg-id
b834e08c-fa94-5823-932e-2073ea805e98@matrix.gatewaynet.com
Список
Дерево обсуждения
ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" . Achilleas Mantzios <achill@matrix.gatewaynet.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>
Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" . Achilleas Mantzios <achill@matrix.gatewaynet.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>
Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR:syntax error at or near "$" . Achilleas Mantzios <achill@matrix.gatewaynet.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>
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 "$" . Achilleas Mantzios <achill@matrix.gatewaynet.com>
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 по дате отправления
От: vardenis pavardenis
Дата:
От: Adrian Klaver
Дата: