Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql90-plpython
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Retire EOLed PostgreSQL 8.4 and 9.0.
Fix PLIST for python-3.x.
Changes: * Fix btree index corruption from insertions concurrent with vacuuming * Recover from errors occurring during WAL replay of DROP TABLESPACE * Fix transient zeroing of shared buffers during WAL replay * Fix postmaster to attempt restart after a hot-standby crash * Fix corner case in SSI transaction cleanup * Update per-column permissions, not only per-table permissions, when changing table owner * Fix handling of data-modifying WITH subplans in READ COMMITTED rechecking * Fix for "could not find plan for CTE" failures * Fix unsupported node type error caused by COLLATE in an INSERT expression * Avoid crashing when we have problems deleting table files post-commit * Fix recently-introduced memory leak in processing of inet/cidr * Fix GIN cost estimation to handle column IN (...) index conditions * Fix I/O-conversion-related memory leaks in plpgsql * Teach pg_upgrade to handle renaming of plpython's shared library (affecting upgrades to 9.1)
Changes 9.0.5: * Fix catalog cache invalidation after a "VACUUM FULL" or "CLUSTER" on a system catalog * Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs * Fix bugs in indexing of in-doubt HOT-updated tuples * Fix multiple bugs in GiST index page split processing * Fix possible buffer overrun in tsvector_concat() * Fix crash in xml_recv when processing a "standalone" parameter * Make pg_options_to_table return NULL for an option with no value * Avoid possibly accessing off the end of memory in "ANALYZE" and in SJIS-2004 encoding conversion * Protect pg_stat_reset_shared() against NULL input * Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction * Avoid spurious conflicts while recycling btree index pages during hot standby * Shut down WAL receiver if it's still running at end of recovery * Fix race condition in relcache init file invalidation * Fix memory leak at end of a GiST index scan * Fix memory leak when encoding conversion has to be done on incoming command strings and "LISTEN" is active * Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command * Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist * more...
Changes 9.0.3: * Before exiting walreceiver, ensure all the received WAL is fsync'd to disk * Avoid excess fsync activity in walreceiver * Make "ALTER TABLE" revalidate uniqueness and exclusion constraints when needed * Fix EvalPlanQual for "UPDATE" of an inheritance tree in which the tables are not all alike * Avoid failures when "EXPLAIN" tries to display a simple-form CASE expression * Fix assignment to an array slice that is before the existing range of subscripts * Avoid unexpected conversion overflow in planner for very distant date values * Fix PL/Python crash when an array contains null entries * Remove ecpg's fixed length limit for constants defining an array dimension * Fix erroneous parsing of tsquery values containing ... & !(subexpression) | ... * Fix buffer overrun in "contrib/intarray"'s input function for the query_int type * Fix bug in "contrib/seg"'s GiST picksplit algorithm
Changes 9.0.2: * Force the default wal_sync_method to be fdatasync on Linux * Fix "too many KnownAssignedXids" error during Hot Standby replay * Fix race condition in lock acquisition during Hot Standby * Avoid unnecessary conflicts during Hot Standby * Fix assorted bugs in WAL replay logic for GIN indexes * Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point * Fix corner-case bug when streaming replication is enabled immediately after creating the master database cluster * Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time * Fix long-term memory leak in autovacuum launcher * Avoid failure when trying to report an impending transaction wraparound condition from outside a transaction * Add support for detecting register-stack overrun on IA64 * Add a check for stack overflow in copyObject() * Fix detection of page splits in temporary GiST indexes * Fix error checking during early connection processing * Improve efficiency of window functions * Avoid memory leakage while "ANALYZE"'ing complex index expressions * Ensure an index that uses a whole-row Var still depends on its table * Add missing support in "DROP OWNED BY" for removing foreign data wrapper/server privileges belonging to a user * Do not "inline" a SQL function with multiple OUT parameters * Fix crash when inline-ing a set-returning function whose argument list contains a reference to an inline-able user function * Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES * Make the OFF keyword unreserved This prevents problems with using off as a variable name in PL/pgSQL. That worked before 9.0, but was now broken because PL/pgSQL now treats all core reserved words as reserved. * Fix constant-folding of COALESCE() expressions
Changes 9.0.1: * Use a separate interpreter for each calling SQL userid in PL/Perl and PL/Tcl * Improve pg_get_expr() security fix so that the function can still be used on the output of a sub-select * Fix incorrect placement of placeholder evaluation * Fix join removal's handling of placeholder expressions * Fix possible duplicate scans of UNION ALL member relations * Prevent infinite loop in ProcessIncomingNotify() after unlistening * Prevent show_session_authorization() from crashing within autovacuum processes * Re-allow input of Julian dates prior to 0001-01-01 AD * Make psql recognize "DISCARD ALL" as a command that should not be encased in a transaction block in autocommit-off mode * Update build infrastructure and documentation to reflect the source code repository's move from CVS to Git
Changes 9.0: 9.0 includes more major features than any release before it, including: * Hot standby * Streaming replication * In-place upgrades * 64-bit Windows builds * Easy mass permissions management * Anonymous blocks and named parameter calls for stored procedures * New windowing functions and ordered aggregates ... and many more. For details on the over 200 additions and improvements in this version, developed by over a hundred contributors, please see the release notes.
Initial revision