suggest: change alter user set search_path to raise notice not error

From: Robert Grabowski <grabba(at)env(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: suggest: change alter user set search_path to raise notice not error
Date: 2003-11-07 10:53:08
Message-ID: 3FAB7994.3070403@env.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2003-11-07 14:32:54 Re: [HACKERS] PostgreSQL client has problems when libbind is
Previous Message Jan Poslusny 2003-11-07 10:29:58 some latin2 characters not correctly read from script