Francisco Reyes wrote:
Is there a way to unset a role's search_path?I had set one role with a particular search path. Now want to take that off so the user can get the database's search_path setting.
ALTER ROLE ... RESET search_path; -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings