Re: Contrib Schemas

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Contrib Schemas
Date: 2006-01-13 04:34:49
Message-ID: 6501E5FD-6B31-4A6C-BD45-463A338FA539@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-01-13 04:47:57 Re: Overflow of bgwriter's request queue
Previous Message Tom Lane 2006-01-13 04:21:28 Re: info is a reserved word?