Format: 1.8 Date: Wed, 11 Jun 2008 20:43:07 +0200 Source: postgresql-8.3 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-8.3 postgresql-client-8.3 postgresql-server-dev-8.3 postgresql-doc-8.3 postgresql-contrib-8.3 postgresql-plperl-8.3 postgresql-plpython-8.3 postgresql-pltcl-8.3 postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: powerpc_translations powerpc Version: 8.3.3-1 Distribution: intrepid Urgency: low Maintainer: Ubuntu/powerpc Build Daemon <buildd@adare.buildd> Changed-By: Martin Pitt <mpitt@debian.org> Description: libecpg-compat3 - older version of run-time library for ECPG programs libecpg-dev - development files for ECPG (Embedded PostgreSQL for C) libecpg6 - run-time library for ECPG programs libpgtypes3 - shared library libpgtypes for PostgreSQL 8.3 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql - object-relational SQL database (supported version) postgresql-8.3 - object-relational SQL database, version 8.3 server postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-8.3 - front-end programs for PostgreSQL 8.3 postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-contrib-8.3 - additional facilities for PostgreSQL postgresql-doc - documentation for the PostgreSQL database management system postgresql-doc-8.3 - documentation for the PostgreSQL database management system postgresql-plperl-8.3 - PL/Perl procedural language for PostgreSQL 8.3 postgresql-plpython-8.3 - PL/Python procedural language for PostgreSQL 8.3 postgresql-pltcl-8.3 - PL/Tcl procedural language for PostgreSQL 8.3 postgresql-server-dev-8.3 - development files for PostgreSQL 8.3 server-side programming Changes: postgresql-8.3 (8.3.3-1) unstable; urgency=low . * New upstream bugfix release (note that 8.3.2 was never officially released due to the discovery of another major bug): - Make pg_get_ruledef() parenthesize negative constants. 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. This oversight could lead to problems if the aggregate was later involved in a "DROP OWNED" or "REASSIGN OWNED" operation. - Fix incorrect archive truncation point calculation for the %r macro in recovery_command parameters. This could lead to data loss if a warm-standby script relied on %r to decide when to throw away WAL segment files. - Fix "ALTER TABLE ADD COLUMN ... PRIMARY KEY" so that the new column is correctly checked to see if it's been initialized to all non-nulls. - Fix "REASSIGN OWNED" so that it works on procedural languages too. - Fix problems with "SELECT FOR UPDATE/SHARE" occurring as a subquery in a query with a non-"SELECT" top-level operation. - Fix possible "CREATE TABLE" failure when inheriting the "same" constraint from multiple parent relations that inherited that constraint from a common ancestor. - Fix pg_get_ruledef() to show the alias, if any, attached to the target table of an "UPDATE" or "DELETE". - Restore the pre-8.3 behavior that an out-of-range block number in a TID being used in a TidScan plan results in silently not matching any rows. 8.3.0 and 8.3.1 threw an error instead. - Fix GIN bug that could result in a too many LWLocks taken failure. - Fix broken GiST comparison function for tsquery. - Fix tsvector_update_trigger() and ts_stat() to accept domains over the types they expect to work with. - Fix failure to support enum data types as foreign keys. - Avoid possible crash when decompressing corrupted data. - Fix race conditions between delayed unlinks and "DROP DATABASE". In the worst case this could result in deleting a newly created table in a new database that happened to get the same OID as the recently-dropped one; but of course that is an extremely low-probability scenario. - Repair two places where SIGTERM exit of a backend could leave corrupted state in shared memory. - Fix possible crash due to incorrect plan generated for an x IN (SELECT y FROM ...) clause when "x" and "y" have different data types; and make sure the behavior is semantically correct when the conversion from "y"'s type to "x"'s type is lossy. - Fix oversight that prevented the planner from substituting known Param values as if they were constants. - Fix planner failure when an indexable MIN or MAX aggregate is used with DISTINCT or ORDER BY. - Fix planner to ensure it never uses a "physical tlist" for a plan node that is feeding a Sort node. - Avoid unnecessary copying of query strings. - Make TransactionIdIsCurrentTransactionId() use binary search instead of linear search when checking child-transaction XIDs. This fixes some cases in which 8.3.0 was significantly slower than earlier releases. - Fix conversions between ISO-8859-5 and other encodings to handle Cyrillic "Yo" characters (e and E with two dots). - Fix several datatype input functions, notably array_in(), that were allowing unused bytes in their results to contain uninitialized, unpredictable values. This could lead to failures in which two apparently identical literal values were not seen as equal, resulting in the parser complaining about unmatched ORDER BY and DISTINCT expressions. - Fix a corner case in regular-expression substring matching (substring(string from pattern)). The problem occurs when there is a match to the pattern overall but the user has specified a parenthesized subexpression and that subexpression hasn't got a match. An example is substring('foo' from 'foo(bar)?'). This should return NULL, since (bar) isn't matched, but it was mistakenly returning the whole-pattern match instead (ie, foo). - Prevent cancellation of an auto-vacuum that was launched to prevent XID wraparound. - Improve "ANALYZE"'s handling of in-doubt tuples (those inserted or deleted by a not-yet-committed transaction) so that the counts it reports to the stats collector are more likely to be correct. - Fix initdb to reject a relative path for its --xlogdir (-X) option. - Make psql print tab characters as an appropriate number of spaces, rather than \x09 as was done in 8.3.0 and 8.3.1. - Add ECPGget_PGconn() function to ecpglib. Dropped 00upstream-ecpg-get-connection.patch, which backported this fix. - Fix incorrect result from ecpg's PGTYPEStimestamp_sub() function. - Fix handling of continuation line markers in ecpg. - Fix possible crashes in "contrib/cube" functions. - Fix core dump in "contrib/xml2"'s xpath_table() function when the input query returns a NULL value. * Build against tcl 8.5. * debian/control: Fix bad wrapping in build dependencies. Checksums-Sha1: 6f199b5c83c204f8441c8e61b1c8169fbfe75742 2563402 postgresql-8.3_8.3.3-1_powerpc_translations.tar.gz 843010ef9ac33d79620dd7344fd6376e11851219 189714 libpq-dev_8.3.3-1_powerpc.deb 2b1cca6043f546a252d013ac5dbff51c406a223f 276290 libpq5_8.3.3-1_powerpc.deb 0ca7e68c255e4c7559bec76b3de2e27b16686fc5 34008 libecpg6_8.3.3-1_powerpc.deb de7c17fc3d980502b1fe1a4dea365abd47fba6c2 217468 libecpg-dev_8.3.3-1_powerpc.deb 8ac4fff7e4d19278f2b3af939d1e6f817af2462f 11344 libecpg-compat3_8.3.3-1_powerpc.deb 4ed34ed474af6cd28f7873766da151d41b1d1df4 243726 libpgtypes3_8.3.3-1_powerpc.deb 712078665d52a2ea5889f7e54ec31ccbab3e15cf 4103284 postgresql-8.3_8.3.3-1_powerpc.deb defa5850237260e2fbe194201a5e73477acc8b42 758906 postgresql-client-8.3_8.3.3-1_powerpc.deb 1b44208f31c3f89ecc080465a4b2b1e622bc01b1 777394 postgresql-server-dev-8.3_8.3.3-1_powerpc.deb f3b221e96ebe24b0d783715a9f959e9f9d73be6a 419832 postgresql-contrib-8.3_8.3.3-1_powerpc.deb cf8568f5a9d5eb477173538407a27bd5cadfc534 240610 postgresql-plperl-8.3_8.3.3-1_powerpc.deb 247bb9a540385cc766ceba969b0c0ac0ae15214d 235034 postgresql-plpython-8.3_8.3.3-1_powerpc.deb 2369f6cdde9bb644614ef34051be95b534e33bed 233008 postgresql-pltcl-8.3_8.3.3-1_powerpc.deb Checksums-Sha256: d640bad2dab18fe68feb54054c49d356e6e488df22726a347d047d46f56aedea 2563402 postgresql-8.3_8.3.3-1_powerpc_translations.tar.gz 55426345985bb79ff894b3dc2068223fe5d74907b835623ae8008d8594a98454 189714 libpq-dev_8.3.3-1_powerpc.deb 551bb0073abfffa80fca82ba3207ddd4a6f0c732c000760f7a92450f1e33b7b6 276290 libpq5_8.3.3-1_powerpc.deb dbe910a54dd20514bf8524376eb562ee8f7d31fe6b532e023a2feaded7deffb6 34008 libecpg6_8.3.3-1_powerpc.deb 03284a59f084f56fb61003255762a5d321f7540c820b13136a788cd0ed35cf09 217468 libecpg-dev_8.3.3-1_powerpc.deb 99aa8cc597b173f310220c6225adc0a86f0568f4d38053b253a0067a1a7a9936 11344 libecpg-compat3_8.3.3-1_powerpc.deb 39f4d5a5bcfec11e32d252649347ab9dbe065ffdf3f352de8b9cde4bc6d6348f 243726 libpgtypes3_8.3.3-1_powerpc.deb 1e6b7f4bbd04f97647e3d15b3f1f1b405ea313ccd0b8f677ee9f4c13abb1d717 4103284 postgresql-8.3_8.3.3-1_powerpc.deb 4bd05fc4d9ebc1c8e3431b1f5004b50c6278e5589f035c39bfcf5e7134668568 758906 postgresql-client-8.3_8.3.3-1_powerpc.deb 1ed9ebdcb2b2cbafeab5e05c5a3d1937833b8bb45627e366f341bbfb8f50a24e 777394 postgresql-server-dev-8.3_8.3.3-1_powerpc.deb f120cfdd40bbb3050d74b441cc9ad201d3a052d3b4145b519e0d763538786287 419832 postgresql-contrib-8.3_8.3.3-1_powerpc.deb 0c9d48afb3ffa93b2d7001d66a9685a25fe10746f2ca4c8f258483f72c8358b4 240610 postgresql-plperl-8.3_8.3.3-1_powerpc.deb 3474916f423768f4be5dfc58af419be15d6142a443c4b7e5f0039b110ed20255 235034 postgresql-plpython-8.3_8.3.3-1_powerpc.deb 7b588d68c135eeebba4bfdf77e4d1d14e6a5f4cdd44fed965cef1ed6e6d9f7a3 233008 postgresql-pltcl-8.3_8.3.3-1_powerpc.deb Files: 2708a7d6fcb0961fb16f3906cacaeb76 2563402 raw-translations - postgresql-8.3_8.3.3-1_powerpc_translations.tar.gz 250f50fb5f893eaa1b1a07ef6b71b6bb 189714 libdevel optional libpq-dev_8.3.3-1_powerpc.deb f7a10a7f67772f2e07a0c1aa85d31166 276290 libs optional libpq5_8.3.3-1_powerpc.deb 94a0b4049e36c09f5960ee67294c927a 34008 libs optional libecpg6_8.3.3-1_powerpc.deb 1a05a589fe439b568bbeb601040e8f67 217468 libdevel optional libecpg-dev_8.3.3-1_powerpc.deb 64d5daeb13bbf2ca7bdebaa334e27afd 11344 libs optional libecpg-compat3_8.3.3-1_powerpc.deb f8a7de2df4a56dbef340eb1fd5097eb5 243726 libs optional libpgtypes3_8.3.3-1_powerpc.deb 10841b30c7d2f0aa8c1f9cf121eb9e4c 4103284 misc optional postgresql-8.3_8.3.3-1_powerpc.deb db8f182ff51414e54e008c011ea833ac 758906 misc optional postgresql-client-8.3_8.3.3-1_powerpc.deb 2779d33fddd932a0da27ea3bf8f433c4 777394 libdevel optional postgresql-server-dev-8.3_8.3.3-1_powerpc.deb 4714c5aed5d8a568dd4cef396aaf6d9d 419832 misc optional postgresql-contrib-8.3_8.3.3-1_powerpc.deb c6e39b38cf2b71843803d4e7a9cd63cf 240610 misc optional postgresql-plperl-8.3_8.3.3-1_powerpc.deb 3f54e69406d90c2ec5b07f3dade5bb1a 235034 misc optional postgresql-plpython-8.3_8.3.3-1_powerpc.deb 9874361f32d17f55c521a2118ff19a7a 233008 misc optional postgresql-pltcl-8.3_8.3.3-1_powerpc.deb