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

pgsql-server: plperl update from Andrew Dunstan, deriving (I believe)

From: joe(at)svr1(dot)postgresql(dot)org (Joe Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: plperl update from Andrew Dunstan, deriving (I believe)
Date: 2004-07-01 20:50:22
Message-ID: 20040701205022.BD80ED1B744@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Log Message:
-----------
plperl update from Andrew Dunstan, deriving (I believe) from Command Prompt's
plperlNG. Review and minor cleanup/improvements by Joe Conway.

Summary of new functionality:
- Shared data space and namespace. There is a new global variable %_SHARED
  that functions can use to store and save data between invocations of a
  function, or between different functions. Also, all trusted plperl function
  now share a common Safe container (this is an optimization, also), which
  they can use for storing non-lexical variables, functions, etc.
- Triggers are now supported
- Records can now be returned (as a hash reference)
- Sets of records can now be returned (as a reference to an array of hash
  references).
- New function spi_exec_query() provided for performing db functions or
  getting data from db.
- Optimization for counting hash keys (Abhijit Menon-Sen)
- Allow return of 'record' and 'setof record'

Modified Files:
--------------
    pgsql-server/src/pl/plperl:
        GNUmakefile (r1.12 -> r1.13)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/GNUmakefile.diff?r1=1.12&r2=1.13)
        SPI.xs (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/SPI.xs.diff?r1=1.5&r2=1.6)
        plperl.c (r1.44 -> r1.45)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/plperl.c.diff?r1=1.44&r2=1.45)

Added Files:
-----------
    pgsql-server/src/pl/plperl:
        spi_internal.c (r1.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/spi_internal.c?rev=1.1&content-type=text/x-cvsweb-markup)
        spi_internal.h (r1.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/spi_internal.h?rev=1.1&content-type=text/x-cvsweb-markup)

Removed Files:
-------------
    pgsql-server/src/pl/plperl:
        eloglvl.c
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/eloglvl.c)
        eloglvl.h
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/pl/plperl/eloglvl.h)

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-07-01 20:51:24
Subject: Re: Schedule, feature freeze, etc
Previous:From: netmaskDate: 2004-07-01 20:42:07
Subject: Re: A wanna be

pgsql-committers by date

Next:From: Tom LaneDate: 2004-07-01 21:17:13
Subject: pgsql-server: More paranoia in AtEOSubXact_SPI: don't assume we can
Previous:From: Tom LaneDate: 2004-07-01 20:11:03
Subject: pgsql-server: Further review of xact.c state machine for nested

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