Thread

  1. Extensions, patch v17

    Dimitri Fontaine <dimitri@2ndquadrant.fr> — 2010-12-12T20:50:41Z

    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
    
    
  2. Re: Extensions, patch v17

    David Wheeler <david@kineticode.com> — 2010-12-12T21:48:04Z

    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
    
    
    
  3. Re: Extensions, patch v17

    Greg Smith <greg@2ndquadrant.com> — 2010-12-16T13:05:08Z

    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