Skip site navigation (1) Skip section navigation (2)

Re: contrib function naming, and upgrade issues

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: contrib function naming, and upgrade issues
Date: 2009-03-23 02:57:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
>>>>> "Alvaro" == Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:

 >> I've been thinking about this, and my conclusion is that schemas
 >> as they currently exist are the wrong tool for making
 >> modules/packages.

 Alvaro> This has been discussed at length previously, and we even had
 Alvaro> an incomplete but substantive patch posted.  Did you review
 Alvaro> that?  Some of it appears to be in line of what you're
 Alvaro> proposing here.  If you're interested in this area, perhaps
 Alvaro> you could pick up where Tom Dunstan left off.

Yes, that's close to what I had in mind.

One difference is that I would be inclined to punt more of the
installation logic into the module itself. If "INSTALL MODULE foo"
worked by calling a specially-declared function in (if
present), it would give the module more flexibility in terms of what
to install based on the version number requested, etc.; some helper
functions could be provided so that the simpler cases require only a
few lines of code.

Modules not implemented as .so files would have a bit less flexibility
thanks to the fact that we don't have any procedural languages
installed by default; how to do versioning for them would require a
bit more thought. (Maybe have a to do the work for

I will consider working on this at some point.


In response to

pgsql-hackers by date

Next:From: Andrew GierthDate: 2009-03-23 03:03:12
Subject: Re: contrib function naming, and upgrade issues
Previous:From: Robert HaasDate: 2009-03-23 02:40:31
Subject: Re: contrib function naming, and upgrade issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group