NOTICE: This package has been removed from pkgsrc

./databases/postgresql82-plperl, PL/Perl procedural language for the PostgreSQL backend

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ]


Branch: CURRENT, Version: 8.2.18, Package name: postgresql82-plperl-8.2.18, Maintainer: adam

PL/Perl allows you to write functions in the Perl programming language
that may be used in SQL queries as if they were built into Postgres.
The PL/Perl intepreter is a full Perl interpreter. However, certain
operations have been disabled in order to maintain the security of the
system.


Required to run:
[databases/postgresql82-server] [databases/postgresql82-client] [lang/perl5]

Required to build:
[lang/perl5] [devel/gmake] [devel/libtool-base] [devel/bison]

Master sites: (Expand)

SHA1: ec6bd4cd830b5df50c3d6038186cf1af03b609ff
RMD160: b1aa60338c3f6dc886caedc60e924128d64971dd
Filesize: 12425.635 KB

Version history: (Expand)


CVS history: (Expand)


   2010-10-07 17:52:06 by Adam Ciarcinski | Files touched by this commit (6)
Log message:
Changes 8.2.18:

* Use a separate interpreter for each calling SQL userid in PL/Perl and PL/Tcl
* Prevent possible crashes in pg_get_expr() by disallowing it from being called
  with an argument that is not one of the system catalog columns it's intended
  to be used with
* Fix Windows shared-memory allocation code
* Treat exit code 128 (ERROR_WAIT_NO_CHILDREN) as non-fatal on Windows
* Fix possible duplicate scans of UNION ALL member relations
* Fix "cannot handle unplanned sub-select" error
* Reduce PANIC to ERROR in some occasionally-reported btree failure cases, and
  provide additional detail in the resulting error messages
* Prevent show_session_authorization() from crashing within autovacuum
  processes
* Defend against functions returning setof record where not all the returned
  rows are actually of the same rowtype
* Fix possible failure when hashing a pass-by-reference function result
* Take care to fsync the contents of lockfiles (both "postmaster.pid" \ 
and the
  socket lockfile) while writing them
* Avoid recursion while assigning XIDs to heavily-nested subtransactions
* Fix log_line_prefix's %i escape, which could produce junk early in backend
  startup
* Fix possible data corruption in "ALTER TABLE ... SET TABLESPACE" when
  archiving is enabled
* Allow "CREATE DATABASE" and "ALTER DATABASE ... SET \ 
TABLESPACE" to be
  interrupted by query-cancel
* In PL/Python, defend against null pointer results from PyCObject_AsVoidPtr
  and PyCObject_FromVoidPtr
* Improve "contrib/dblink"'s handling of tables containing dropped columns
* Fix connection leak after "duplicate connection name" errors in
  "contrib/dblink"
* Fix "contrib/dblink" to handle connection names longer than 62 bytes
  correctly
   2010-08-21 18:37:14 by Stoned Elipot | Files touched by this commit (1724) | Package updated
Log message:
Bump the PKGREVISION for all packages which depend directly on perl,
to trigger/signal a rebuild for the transition 5.10.1 -> 5.12.1.

The list of packages is computed by finding all packages which end
up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl,
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=..."), minus the packages updated after
the perl package update.

sno@ was right after all, obache@ kindly asked and he@ led the
way. Thanks!
   2010-04-12 11:48:49 by Adam Ciarcinski | Files touched by this commit (13)
Log message:
Changes 8.2.16:
* Add new configuration parameter ssl_renegotiation_limit to control
  how often we do session key renegotiation for an SSL connection
* Fix possible deadlock during backend startup
* Fix possible crashes due to not handling errors during relcache
  reload cleanly
* Fix possible crashes when trying to recover from a failure in
   subtransaction start
* Fix server memory leak associated with use of savepoints and a
  client encoding different from server's encoding
* Fix incorrect WAL data emitted during end-of-recovery cleanup of a
  GIST index page split
* Make substring() for bit types treat any negative length as meaning
  "all the rest of the string"
  The previous coding treated only -1 that way, and would produce an
  invalid result value for other negative values, possibly leading to
  a crash (CVE-2010-0442).
* Fix integer-to-bit-string conversions to handle the first
  fractional byte correctly when the output bit width is wider than
  the given integer by something other than a multiple of 8 bits
* Fix some cases of pathologically slow regular expression matching
* Fix the STOP WAL LOCATION entry in backup history files to report
  the next WAL segment's name when the end location is exactly at a
  segment boundary
* Fix some more cases of temporary-file leakage
* Improve constraint exclusion processing of boolean-variable cases,
  in particular make it possible to exclude a partition that has a
  "bool_column = false" constraint
* When reading "pg_hba.conf" and related files, do not treat
  @something as a file inclusion request if the @ appears inside
  quote marks; also, never treat @ by itself as a file inclusion
  request
* Prevent infinite loop on some platforms if a directory is named as
  an inclusion target in "pg_hba.conf" and related files
* Fix possible infinite loop if SSL_read or SSL_write fails without
  setting errno
  This is reportedly possible with some Windows versions of openssl.
* Fix psql's numericlocale option to not format strings it shouldn't
  in latex and troff output formats
* Make psql return the correct exit status (3) when ON_ERROR_STOP and
  --single-transaction are both specified and an error occurs during
  the implied "COMMIT"
* Fix plpgsql failure in one case where a composite column is set to NULL
* Fix possible failure when calling PL/Perl functions from PL/PerlU
  or vice versa
* Add volatile markings in PL/Python to avoid possible
  compiler-specific misbehavior
* Ensure PL/Tcl initializes the Tcl interpreter fully
  The only known symptom of this oversight is that the Tcl clock
  command misbehaves if using Tcl 8.5 or later.
* Prevent crash in "contrib/dblink" when too many key columns are
  specified to a dblink_build_sql_* function
* Fix assorted crashes in "contrib/xml2" caused by sloppy memory
  management
* Make building of "contrib/xml2" more robust on Windows
* Fix race condition in Windows signal handling
  One known symptom of this bug is that rows in pg_listener could be
  dropped under heavy load.
* Update time zone data files to tzdata release 2010e for DST law
  changes in Bangladesh, Chile, Fiji, Mexico, Paraguay, Samoa.
   2010-01-17 13:02:58 by Thomas Klausner | Files touched by this commit (724) | Package updated
Log message:
Recursive PKGREVISION bump for jpeg update to 8.
   2008-11-04 10:52:39 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 8.2.11:
* Fix GiST index corruption due to marking the wrong index entry
  "dead" after a deletion.
  This would result in index searches failing to find rows they
  should have found.
* Fix backend crash when the client encoding cannot represent a
  localized error message.
  We have addressed similar issues before, but it would still fail if
  the "character has no equivalent" message itself couldn't be
  converted. The fix is to disable localization and send the plain
  ASCII error message when we detect such a situation.
* Fix possible crash when deeply nested functions are invoked from a
  trigger.
* Improve optimization of "expression" IN \ 
("expression-list") queries.
  Cases in which there are query variables on the right-hand side had
  been handled less efficiently in 8.2.x and 8.3.x than in prior
  versions. The fix restores 8.1 behavior for such cases.
* Fix mis-expansion of rule queries when a sub-SELECT appears in a
  function call in FROM, a multi-row VALUES list, or a RETURNING list.
* Fix memory leak during rescan of a hashed aggregation plan.
* Ensure an error is reported when a newly-defined PL/pgSQL trigger
  function is invoked as a normal function.
* Prevent possible collision of relfilenode numbers when moving a
  table to another tablespace with "ALTER SET TABLESPACE".
  The command tried to re-use the existing filename, instead of
  picking one that is known unused in the destination directory.
* Fix incorrect tsearch2 headline generation when single query item
  matches first word of text.
* Fix improper display of fractional seconds in interval values when
  using a non-ISO datestyle in an "--enable-integer-datetimes" build.
* Ensure SPI_getvalue and SPI_getbinval behave correctly when the
  passed tuple and tuple descriptor have different numbers of columns.
* Fix ecpg's parsing of "CREATE ROLE".
* Fix recent breakage of pg_ctl restart.
* Ensure "pg_control" is opened in binary mode.
  pg_controldata and pg_resetxlog did this incorrectly, and so could
  fail on Windows.
* Update time zone data files to tzdata release 2008i (for DST law
  changes in Argentina, Brazil, Mauritius, Syria)
   2008-10-19 21:19:25 by Havard Eidnes | Files touched by this commit (1179)
Log message:
Bump the PKGREVISION for all packages which depend directly on perl,
to trigger/signal a rebuild for the transition 5.8.8 -> 5.10.0.

The list of packages is computed by finding all packages which end
up having either of PERL5_USE_PACKLIST, BUILDLINK_API_DEPENDS.perl,
or PERL5_PACKLIST defined in their make setup (tested via
"make show-vars VARNAMES=...").
   2008-06-12 04:14:58 by Joerg Sonnenberger | Files touched by this commit (1134)
Log message:
Add DESTDIR support.
   2008-04-05 18:40:08 by Adam Ciarcinski | Files touched by this commit (12)
Log message:
Changes 8.2.7:
* Fix character string comparison for Windows locales that consider
  different character combinations as equal
* Repair potential deadlock between concurrent "VACUUM FULL"
  operations on different system catalogs
* Fix longstanding "LISTEN"/"NOTIFY" race condition
* Disallow "LISTEN" and "UNLISTEN" within a prepared transaction
* Disallow dropping a temporary table within a prepared transaction
* Fix rare crash when an error occurs during a query using a hash
  index
* Fix memory leaks in certain usages of set-returning functions
* Fix input of datetime values for February 29 in years BC
* Fix "unrecognized node type" error in some variants of "ALTER
  OWNER"
* Ensure pg_stat_activity.waiting flag is cleared when a lock wait is
  aborted
* Fix handling of process permissions on Windows Vista
* More...