[no description] https://git.osdyson.ru/mirror/pkgsrc/atom?h=cube-native-xorg 2008-06-20T06:54:42Z 2008-06-20T06:54:42Z adam adam@pkgsrc.org 2008-06-20T06:54:42Z urn:sha1:5fe9be435e8716654ed55e736bfbcc7d76e88346 * 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-04-05T16:39:26Z adam adam@pkgsrc.org 2008-04-05T16:39:26Z urn:sha1:b89730cc45555223f5594d36b0b6c396228d5f26 * Fix character string comparison for Windows locales that consider different character combinations as equal * Repair corner-case bugs in "VACUUM FULL" * Fix misbehavior of foreign key checks involving character or bit columns * Avoid needless deadlock failures in no-op foreign-key checks * Fix possible core dump when re-planning a prepared query * Fix possible failure when re-planning a query that calls an SPI-using function * Fix failure in row-wise comparisons involving columns of different datatypes * 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 incorrect comparison of tsquery values * Fix incorrect behavior of LIKE with non-ASCII characters in single-byte encodings * Disable xmlvalidate 2008-03-24T18:48:35Z rmind rmind@pkgsrc.org 2008-03-24T18:48:35Z urn:sha1:f9ed7f723a8645d14f7569d69f7402d92a59966d newer versions, as done in other versions of PostgreSQL packages. This gives a performance improvement on client-side, especially on NetBSD -current. 2008-03-04T12:41:36Z adam adam@pkgsrc.org 2008-03-04T12:41:36Z urn:sha1:ccf532ab0c1146ff606fbd4932571528a2ab23c7 With significant new functionality and performance enhancements, this release represents a major leap forward for PostgreSQL. This was made possible by a growing community that has dramatically accelerated the pace of development. This release adds the following major features: * Full text search is integrated into the core database system * Support for the SQL/XML standard, including new operators and an XML data type * Enumerated data types (ENUM) * Arrays of composite types * Universally Unique Identifier (UUID) data type * Add control over whether NULLs sort first or last * Updatable cursors * Server configuration parameters can now be set on a per-function basis * User-defined types can now have type modifiers * Automatically re-plan cached queries when table definitions change or statistics are updated * Numerous improvements in logging and statistics collection * Support Security Service Provider Interface (SSPI) for authentication on Windows * Support multiple concurrent autovacuum processes, and other autovacuum improvements * Allow the whole PostgreSQL distribution to be compiled with Microsoft Visual C++