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
