Hi.

I can't set user's search_path to no exists schema by simple alter
user set ... . I get this message:

test=# CREATE USER test;
CREATE USER
test=# ALTER USER test SET search_path TO noexists;
ERROR: schema "noexists" does not exist


But this is possible by simple trick:
test=# CREATE SCHEMA noexists;
CREATE SCHEMA
test=# ALTER USER test SET search_path TO noexists;
ALTER USER
test=# DROP SCHEMA noexists;
DROP SCHEMA

and search_path for user test looks:
search_path
-------------
noexists
(1 row)

Some times set user's search_path before schema creation is
necessary. I suggest to change error at alter user to notice.

Robert Grabowski


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Robert Grabowski <grabba (AT) env (DOT) pl> writes:
I can't imagine why you think that's necessary.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly