Обсуждение: 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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books