On Jan 12, 2006, at 9:03 PM, Christopher Kings-Lynne wrote:
Default schema really has to be public to help the newbies out there. All contribs should come with some sort of standard uninstall.sql script though.
Speaking of contrib newbies and install/uninstall, I recently had the need to install tsearch2 in a shared hosting environment (where, of course, I don't have superuser access). Since there are C language functions, I could not install it. The hoster's solution was to install it in template1 which seems bad because (1) now everyone gets it whether they want it or not, (2) restoring the database is going to have permission problems.
Would it be reasonable for there to be a way for the super user to grant access to load "approved" modules and/or C language functions?
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
