Extensions, patch v17

Hi,

Here's the latest extension's patch.

The only item with still some work to be done on it is the regression
tests support: we're not aiming to full coverage is my understanding,
and installing contribs goes a long way towards testing extensions. Do
we want more? If so, please detail what exactly.

What's in v17:

- 9700 lines of context diff

226 files changed, 4919 insertions(+), 326 deletions(-)

- extension.control.in cleanup

This file is no longer supported nor mentioned in the docs. The
version property of the extension.control file has to be managed
there directly, we no longer offer any support for using any existing
way to obtain it from the extension's Makefile.

- psql integration rework

\dx list installed extensions
\dx[+] [PATTERN] list extension's objects
\dX [PATTERN] list installed and available extensions

dim=# \dx
List of extensions
Schema | Name | Version | Description
--------+---------------+----------+----------------------------------------------------------------
utils | adminpack | 9.1devel | Administrative functions for PostgreSQL
utils | cube | 9.1devel | data type for representing multidimensional cubes
utils | earthdistance | 9.1devel | calculating great circle distances on the surface of the Earth
utils | hstore | 9.1devel | storing sets of key/value pairs
utils | isn | 9.1devel | data types for the international product numbering standards
utils | lo | 9.1devel | managing Large Objects
(6 rows)

dim=# \dx lo
Objects in extension "lo"
Object Class | Object Description
--------------+---------------------------------
pg_extension | extension lo
pg_type | type utils.lo
pg_proc | function utils.lo_oid(utils.lo)
pg_proc | function utils.lo_manage()
(4 rows)

dim=# \dx+ lo
Objects in extension "lo"
Object OID | Object ClassOID | Object Class | Object Description
------------+-----------------+--------------+---------------------------------
16388 | 3996 | pg_extension | extension lo
16389 | 1247 | pg_type | type utils.lo
16390 | 1255 | pg_proc | function utils.lo_oid(utils.lo)
16391 | 1255 | pg_proc | function utils.lo_manage()
(4 rows)

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

On Dec 12, 2010, at 12:50 PM, Dimitri Fontaine wrote:

> The only item with still some work to be done on it is the regression
> tests support: we're not aiming to full coverage is my understanding,
> and installing contribs goes a long way towards testing extensions. Do
> we want more? If so, please detail what exactly.

At least those things not exercised by the contrib modules.

David

Dimitri tells me there's a V18 of this patch due real soon now. That
may very well be ready for a committer, but even if that's the case it's
going to take them some time to consume what was at last count an almost
10K line long context diff. In the interest of closing this CF out
without further schedule overrun, I'm going to mark this as returned for
now.

Extensions are such a major improvement for PostgreSQL that I certainly
hope review and eventual commit for 9.1 continues during or before the
next CF. Both the multiple dependency patches that have been committed
in the last month and the steady flow of updates to this one are good
signs of progress.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books