summaryrefslogtreecommitdiff
path: root/databases/postgresql82-plpython
AgeCommit message (Collapse)AuthorFilesLines
2010-10-12Retire PostgreSQL 8.2 to keep with the list of three supportedjoerg4-51/+0
PostgreSQL versions in pkgsrc.
2010-04-12Changes 8.2.16:adam1-2/+1
* 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-02-10Bump revision for PYTHON_VERSION_DEFAULT change.joerg1-2/+2
2010-01-17Recursive PKGREVISION bump for jpeg update to 8.wiz1-1/+2
2009-03-20Changes 8.2.13:adam1-2/+1
* Prevent error recursion crashes when encoding conversion fails. * Disallow "CREATE CONVERSION" with the wrong encodings for the specified conversion function. * Fix core dump when to_char() is given format codes that are inappropriate for the type of the data argument. * Fix possible failure in "contrib/tsearch2" when C locale is used with a multi-byte encoding. * Fix extreme inefficiency in "contrib/tsearch2" parser's handling of an email-like string containing multiple @ characters. * Fix decompilation of CASE WHEN with an implicit coercion. * Fix possible misassignment of the owner of a TOAST table's rowtype. * Fix PL/pgSQL to not treat INTO after "INSERT" as an INTO-variables clause anywhere in the string, not only at the start; in particular, don't fail for "INSERT INTO" within "CREATE RULE". * Clean up PL/pgSQL error status variables fully at block exit. * Retry failed calls to CallNamedPipe() on Windows. * Add MUST (Mauritius Island Summer Time) to the default list of known timezone abbreviations.
2009-02-09Switch to Python 2.5 as default. Bump revision of all packages that havejoerg1-1/+2
changed runtime dependencies now.
2008-06-12Add DESTDIR support.joerg1-1/+3
2008-04-05Changes 8.2.7:adam1-2/+1
* 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...
2008-01-18Per the process outlined in revbump(1), perform a recursive revbumptnn1-1/+2
on packages that are affected by the switch from the openssl 0.9.7 branch to the 0.9.8 branch. ok jlam@
2007-02-05Changes 8.2.2:adam1-2/+2
* Remove security vulnerabilities that allowed connected users to read backend memory * Fix not-so-rare-anymore bug wherein btree index page splits could fail due to choosing an infeasible split point * Fix Borland C compile scripts * Properly handle to_char('CC') for years ending in 00 Year 2000 is in the twentieth century, not the twenty-first. * "/contrib/tsearch2" localization improvements * Fix incorrect permission check in information_schema.key_column_usage view * Improve "VACUUM" performance for databases with many tables * Fix for rare Assert() crash triggered by UNION * Fix potentially incorrect results from index searches using ROW inequality conditions * Tighten security of multi-byte character processing for UTF8 sequences over three bytes long * Fix bogus "permission denied" failures occurring on Windows due to attempts to fsync already-deleted files * Fix bug that could cause the statistics collector to hang on Windows * Fix possible crashes when an already-in-use PL/pgSQL function is updated * Improve PL/pgSQL handling of domain types * Fix possible errors in processing PL/pgSQL exception blocks
2006-12-09Changes 8.2.0:adam4-0/+49
* Query language enhancements including "INSERT/UPDATE/DELETE RETURNING", multirow VALUES lists, and optional target-table alias in "UPDATE"/"DELETE" * Index creation without blocking concurrent "INSERT"/"UPDATE"/"DELETE" operations * Many query optimization improvements, including support for reordering outer joins * Improved sorting performance with lower memory usage * More efficient locking with better concurrency * More efficient vacuuming * Easier administration of warm standby servers * New FILLFACTOR support for tables and indexes * Monitoring, logging, and performance tuning additions * More control over creating and dropping objects * Table inheritance relationships can be defined for and removed from pre-existing tables * "COPY TO" can copy the output of an arbitrary "SELECT" statement * Array improvements, including nulls in arrays * Aggregate-function improvements, including multiple-input aggregates and SQL:2003 statistical functions * Many "contrib/" improvements