[no description] https://git.osdyson.ru/mirror/pkgsrc/atom?h=cube-native-xorg 2008-06-20T07:46:49Z 2008-06-20T07:46:49Z adam adam@pkgsrc.org 2008-06-20T07:46:49Z urn:sha1:33296c1f96099b54f931e45bc2e0ea845f896261 * 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-07T20:14:35Z adam adam@pkgsrc.org 2008-01-07T20:14:35Z urn:sha1:28a0721cb19791e424ab365861983802b8a2999d This release contains a variety of fixes from 8.2.5, including fixes for significant security issues. 2007-09-19T20:02:12Z adam adam@pkgsrc.org 2007-09-19T20:02:12Z urn:sha1:901be59274508a64a6106e292b90471f4e1437b7 * Prevent index corruption when a transaction inserts rows and then aborts close to the end of a concurrent "VACUUM" on the same table * Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over domains * Make "CREATE DOMAIN ... DEFAULT NULL" work properly * Fix some planner problems with outer joins, notably poor size estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL * Allow the interval data type to accept input consisting only of milliseconds or microseconds * Allow timezone name to appear before the year in timestamp input * Fixes for GIN indexes used by "/contrib/tsearch2" * 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 * Fix stddev_pop(numeric) and var_pop(numeric) * 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 and semaphore improvements * Make "pg_ctl -w" work properly in Windows service mode * Fix memory allocation bug when using MIT Kerberos on Windows * 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 * Restrict "/contrib/pgstattuple" functions to superusers, for security reasons * Do not let "/contrib/intarray" try to make its GIN opclass the default (this caused problems at dump/restore) 2007-04-30T13:37:00Z adam adam@pkgsrc.org 2007-04-30T13:37:00Z urn:sha1:7a06d63bd3e6ccde59f8ec22672cc945d5a8168a * Support explicit placement of the temporary-table schema within search_path, and disable searching it for functions and operators * Fix shared_preload_libraries for Windows by forcing reload in each backend * Fix to_char() so it properly upper/lower cases localized day or month names * "/contrib/tsearch2" crash fixes * Require "COMMIT PREPARED" to be executed in the same database as the transaction was prepared in * Allow "pg_dump" to do binary backups larger than two gigabytes on Windows * New traditional (Taiwan) Chinese FAQ * Prevent the statistics collector from writing to disk too frequently * Fix potential-data-corruption bug in how "VACUUM FULL" handles "UPDATE" chains * Fix bug in domains that use array types * Fix "pg_dump" so it can dump a serial column's sequence using "-t" when not also dumping the owning table * Planner fixes, including improving outer join and bitmap scan selection logic * Fix possible wrong answers or crash when a PL/pgSQL function tries to RETURN from within an EXCEPTION block * Fix PANIC during enlargement of a hash index * Fix POSIX-style timezone specs to follow new USA DST rules 2007-03-20T18:17:13Z jlam jlam@pkgsrc.org 2007-03-20T18:17:13Z urn:sha1:98ea690841951a7108134f409e3f468bbe8bea92 2006-12-09T15:34:13Z adam adam@pkgsrc.org 2006-12-09T15:34:13Z urn:sha1:4114b9ec4faafb281204b43ea9bf11c859cd45e4 * 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