I am attempting to change my schema search path to my newly-created schema,
which isn't functioning correctly.
When I initially show search_path, it gives me $Users, public, which is
When I perform set search_path TO newpath, I am told that it was performed
When I then show search_path, it shows me newpath, which is correct and
If I attempt to do a query of, say Select * from Users, it fails with
'relation "users" does not exist.
Show search_path still returns newpath
If I open a new SQL query window and show search_path, I see $users, public
Is there a way to make it 'stick' as it seems that it isn't sticking? Or,
am I missing something completely? Please help!
Michael A Weber
Weber Racing Equipment, Inc.
pgsql-novice by date
|Next:||From: Ian Pilcher||Date: 2004-05-15 19:49:08|
|Subject: "Procedure" or deferrable check constraint?|
|Previous:||From: Theo Dickinson||Date: 2004-05-14 15:17:26|
|Subject: Update Row Level Trigger: default value for update trigger|