From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . |
Date: | 2018-07-30 13:23:41 |
Message-ID: | 452f7783-eab3-0d2c-cb83-3ad473d8e9b2@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/30/2018 05:57 AM, Achilleas Mantzios wrote:
> This is with PostgreSQL 10.4.
> How to reproduce :
> postgres(at)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(at)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 "$"
Well the above does not have $user double quoted. Was that hand entered
or was that like that in the pg_dumpall_out.sql file?
>
> Is this a bug or am I missing something ?
I could not replicate:
create role sp_test;
alter role sp_test SET search_path TO "$user", public;
pg_dumpall -g -U postgres > sp_test.sql
In sp_test.sql
CREATE ROLE sp_test;
ALTER ROLE sp_test SET search_path TO "$user", public;
drop role sp_test ;
psql -d test -U postgres -f sp_test.sql
\du
sp_test | Cannot login
| {}
\drds
List of settings
Role | Database | Settings
---------+----------+-----------------------------
sp_test | | search_path="$user", public
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-07-30 13:29:27 | Re: Multi client in subscription? |
Previous Message | Achilleas Mantzios | 2018-07-30 12:57:02 | ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . |