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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-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

Browse pgsql-committers by date

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-07-01 20:51:24 Re: Schedule, feature freeze, etc
Previous Message netmask 2004-07-01 20:42:07 Re: A wanna be