[no description] https://git.osdyson.ru/mirror/pkgsrc/atom?h=cube-native-xorg 2008-06-20T08:27:57Z 2008-06-20T08:27:57Z adam adam@pkgsrc.org 2008-06-20T08:27:57Z urn:sha1:6fbe71741ad380258f94ed5627df4b78e1047ada * Make pg_get_ruledef() parenthesize negative constants (Tom) Before this fix, a negative constant in a view or rule might be dumped as, say, -42::integer, which is subtly incorrect: it should be (-42)::integer due to operator precedence rules. Usually this would make little difference, but it could interact with another recent patch to cause PostgreSQL to reject what had been a valid "SELECT DISTINCT" view query. Since this could result in pg_dump output failing to reload, it is being treated as a high-priority fix. The only released versions in which dump output is actually incorrect are 8.3.1 and 8.2.7. * Make "ALTER AGGREGATE ... OWNER TO" update pg_shdepend (Tom) This oversight could lead to problems if the aggregate was later involved in a "DROP OWNED" or "REASSIGN OWNED" operation. 2008-01-18T05:06:18Z tnn tnn@pkgsrc.org 2008-01-18T05:06:18Z urn:sha1:ad6ceadd25e1d535423ffbc205cb3e45472c83ca on packages that are affected by the switch from the openssl 0.9.7 branch to the 0.9.8 branch. ok jlam@ 2008-01-07T20:14:23Z adam adam@pkgsrc.org 2008-01-07T20:14:23Z urn:sha1:523e67efcbe637ab2cf86b6f0c56631221f9c10a This release contains a variety of fixes from 8.1.10, including fixes for significant security issues. This is the last 8.1.X release for which the PostgreSQL community will produce binary packages for Windows. Windows users are encouraged to move to 8.2.X or later, since there are Windows-specific fixes in 8.2.X that are impractical to back-port. 8.1.X will continue to be supported on other platforms. 2007-09-19T20:01:58Z adam adam@pkgsrc.org 2007-09-19T20:01:58Z urn:sha1:60c7102866cdfcfaa462d5b8074ff87b7b0a040c * Prevent index corruption when a transaction inserts rows and then aborts close to the end of a concurrent "VACUUM" on the same table * Make "CREATE DOMAIN ... DEFAULT NULL" work properly * Allow the interval data type to accept input consisting only of milliseconds or microseconds * Speed up rtree index insertion * Fix excessive logging of SSL error messages * Fix logging so that log messages are never interleaved when using the syslogger process * Fix crash when log_min_error_statement logging runs out of memory * Fix incorrect handling of some foreign-key corner cases * Prevent "REINDEX" and "CLUSTER" from failing due to attempting to process temporary tables of other sessions * Update the time zone database rules, particularly New Zealand's upcoming changes * Windows socket improvements * Suppress timezone name (%Z) in log timestamps on Windows because of possible encoding mismatches * Require non-superusers who use "/contrib/dblink" to use only password authentication, as a security measure 2007-07-04T20:54:31Z jlam jlam@pkgsrc.org 2007-07-04T20:54:31Z urn:sha1:4390d56940778d6ab856866401c0690f1c28c724 the owner of all installed files is a non-root user. This change affects most packages that require special users or groups by making them use the specified unprivileged user and group instead. (1) Add two new variables PKG_GROUPS_VARS and PKG_USERS_VARS to unprivileged.mk. These two variables are lists of other bmake variables that define package-specific users and groups. Packages that have user-settable variables for users and groups, e.g. apache and APACHE_{USER,GROUP}, courier-mta and COURIER_{USER,GROUP}, etc., should list these variables in PKG_USERS_VARS and PKG_GROUPS_VARS so that unprivileged.mk can know to set them to ${UNPRIVILEGED_USER} and ${UNPRIVILEGED_GROUP}. (2) Modify packages to use PKG_GROUPS_VARS and PKG_USERS_VARS. 2007-04-30T13:37:22Z adam adam@pkgsrc.org 2007-04-30T13:37:22Z urn:sha1:05954558af412f8889865f20cc1eb6b90116b817 * Support explicit placement of the temporary-table schema within search_path, and disable searching it for functions and operators * "/contrib/tsearch2" crash fixes * Require "COMMIT PREPARED" to be executed in the same database as the transaction was prepared in * Fix potential-data-corruption bug in how "VACUUM FULL" handles "UPDATE" chains * Planner fixes, including improving outer join and bitmap scan selection logic * Fix PANIC during enlargement of a hash index (bug introduced in 8.1.6) * Fix POSIX-style timezone specs to follow new USA DST rules 2007-01-08T18:55:38Z adam adam@pkgsrc.org 2007-01-08T18:55:38Z urn:sha1:515dd4e879b62229ea2f339c1ef6fa99240764fa * Improve handling of getaddrinfo() on AIX This fixes a problem with starting the statistics collector, among other things. * Fix pg_restore to handle a tar-format backup that contains large objects (blobs) with comments * Fix "failed to re-find parent key" errors in "VACUUM" * Clean out "pg_internal.init" cache files during server restart This avoids a hazard that the cache files might contain stale data after PITR recovery. * Fix race condition for truncation of a large relation across a gigabyte boundary by "VACUUM" * Fix bug causing needless deadlock errors on row-level locks * Fix bugs affecting multi-gigabyte hash indexes * Fix possible deadlock in Windows signal handling * Fix error when constructing an ARRAY[] made up of multiple empty elements * Fix ecpg memory leak during connection * Fix for Darwin (OS X) compilation * to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for new initdb installs This is because lc_numeric can potentially change the output of these functions. * Improve index usage of regular expressions that use parentheses This improves psql \d performance also. * Update timezone database This affects Australian and Canadian daylight-savings rules in particular. 2006-11-05T17:42:30Z joerg joerg@pkgsrc.org 2006-11-05T17:42:30Z urn:sha1:5ade59fdafbd1d4d9d91ab9ae015cd7c5d72b576 2006-10-18T16:31:24Z adam adam@pkgsrc.org 2006-10-18T16:31:24Z urn:sha1:2d6b1efeb4d6a5bfd41184ffbd27d3ecbc854862 * Disallow aggregate functions in "UPDATE" commands, except within sub-SELECTs (Tom) The behavior of such an aggregate was unpredictable, and in 8.1.X could cause a crash, so it has been disabled. The SQL standard does not allow this either. * Fix core dump when an untyped literal is taken as ANYARRAY * Fix core dump in duration logging for extended query protocol when a "COMMIT" or "ROLLBACK" is executed * Fix mishandling of AFTER triggers when query contains a SQL function returning multiple rows (Tom) * Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause (Tom) * Fix string_to_array() to handle overlapping matches for the separator string For example, string_to_array('123xx456xxx789', 'xx'). * Fix to_timestamp() for AM/PM formats (Bruce) * Fix autovacuum's calculation that decides whether "ANALYZE" is needed (Alvaro) * Fix corner cases in pattern matching for psql's \d commands * Fix index-corrupting bugs in /contrib/ltree (Teodor) * Numerous robustness fixes in ecpg (Joachim Wieland) * Fix backslash escaping in /contrib/dbmirror * Minor fixes in /contrib/dblink and /contrib/tsearch2 * Efficiency improvements in hash tables and bitmap index scans (Tom) * Fix instability of statistics collection on Win32 (Tom, Andrew) * Fix statement_timeout to use the proper units on Win32 (Bruce) In previous Win32 8.1.X versions, the delay was off by a factor of 100. * Fixes for MSVC and Borland C++ compilers (Hiroshi Saito) * Fixes for AIX and Intel compilers (Tom) 2006-04-23T00:12:35Z jlam jlam@pkgsrc.org 2006-04-23T00:12:35Z urn:sha1:802ce74fcbb88a27d21b45fde8f40d7ac06aaeff syntax as specified in pkgsrc/mk/install/bsd.pkginstall.mk:1.47.