If you have a language installed (like pl/pgsql), then dropping the public schema also drops the language. Ouch.
Maybe there is a solution to that one though... John Sidney-Woollett Kris Jurka said: > > > On Wed, 31 Dec 2003, Mike Nolan wrote: > >> That raises an interesting question. Can pg be configured so >> that user tables MUST be in user schemas, i.e., nobody can put tables >> in the PUBLIC schema? > > Sure, you can simply drop the public schema, or "revoke all on schema > public from public"; > > Kris Jurka > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
