./databases/postgresql96-plpython, PL/Python procedural language for the PostgreSQL backend

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 9.6.10nb1, Package name: postgresql96-plpython-9.6.10nb1, Maintainer: adam

PL/Python allows you to write functions in the Python programming
language that may be used in SQL queries as if they were built into
Postgres. The PL/Python intepreter is a full Python interpreter.

PL/Python is currently only available as an "untrusted" language
(meaning it does not offer any way of restricting what users can do
in it). It has therefore been named "plpythonu". The trusted variant
plpython may become available again in future, if a new secure execution
mechanism is developed in Python.


Required to run:
[textproc/libxml2] [lang/python27] [databases/postgresql96-client] [databases/postgresql96-server]

Required to build:
[pkgtools/cwrappers]

Package options: gssapi

Master sites:

SHA1: 860ff3e2ce42246f45db1fc4519f972228168242
RMD160: 1183d331a6e3ceef5e50f6ae55bce745593a842d
Filesize: 19522.66 KB

Version history: (Expand)


CVS history: (Expand)


   2018-08-22 11:48:07 by Thomas Klausner | Files touched by this commit (3558)
Log message:
Recursive bump for perl5-5.28.0
   2018-08-10 13:56:10 by Adam Ciarcinski | Files touched by this commit (27) | Package updated
Log message:
postgresql: updated to 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24

The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24. \ 
This release fixes two security issues as well as bugs reported over the last \ 
three months.

SECURITY ISSUES:
CVE-2018-10915: CERTAIN HOST CONNECTION PARAMETERS DEFEAT CLIENT-SIDE SECURITY \ 
DEFENSES
CVE-2018-10925: MEMORY DISCLOSURE AND MISSING AUTHORIZATION IN INSERT ... ON \ 
CONFLICT DO UPDATE

BUG FIXES AND IMPROVEMENTS
Several fixes related to VACUUM, including an issue that could lead to data \ 
corruption in certain system catalog tables
Several fixes for replaying write-ahead logs, including a case where a \ 
just-promoted standby server would not restart if it crashed before its first \ 
post-recovery checkpoint
Several performance improvements for replaying write-ahead logs
Several fixes for logical replication and logical decoding, including ensuring \ 
logical WAL senders are reporting the streaming state correctly
Allow replication slots to be dropped in single-user mode
Fix to have variance and similar aggregate functions return accurate results \ 
when executed using parallel query
Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects
Fix to ensure that a process doing a parallel index scan will respond to \ 
signals, such as one to abort a query
Fix EXPLAIN's accounting for resource usage, particularly buffer accesses, in \ 
parallel workers
Several fixes for the query planner including improving the cost estimates for \ 
hash-joins and choosing to use indexes for mergejoins on composite type columns
Fix performance regression related to POSIX semaphores for multi-CPU systems \ 
running Linux or FreeBSD
Fix for GIN indexes that could lead to an assertion failure after a pg_upgrade \ 
from a version before PostgreSQL 9.4
Fix for SHOW ALL to display superuser configuration settings to roles that are \ 
allowed to read all settings
Fix issue where COPY FROM .. WITH HEADER would drop a line after every \ 
4,294,967,296 lines processed
Several fixes for XML support, including using the document node as the context \ 
for XPath queries as defined in the SQL standard, which affects the xpath and \ 
xpath_exists functions, as well as XMLTABLE
Fix libpq for certain cases where hostaddr is used
Several ecpg fixes for Windows
Fix password prompting in Windows client programs so that echo is properly disabled
Several pg_dump fixes, including correctly outputting REPLICA IDENTITY \ 
properties for constraint indexes
Make pg_upgrade check that the old server was shut down cleanly