Format: 1.8 Date: Wed, 16 Sep 2009 11:15:21 +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.8-0ubuntu9.04 Distribution: jaunty Urgency: low Maintainer: Ubuntu/powerpc Build Daemon Changed-By: Martin Pitt 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 Launchpad-Bugs-Fixed: 430544 Changes: postgresql-8.3 (8.3.8-0ubuntu9.04) jaunty-security; urgency=low . * New upstream security/bug fix release: (LP: #430544) - Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside security-definer functions. This covers a case that was missed in the previous patch that disallowed "SET ROLE" and "SET SESSION AUTHORIZATION" inside security-definer functions. [CVE-2007-6600] - Force WAL segment switch during pg_start_backup(). This avoids corner cases that could render a base backup unusable. - Make "LOAD" of an already-loaded loadable module into a no-op. Formerly, "LOAD" would attempt to unload and re-load the module, but this is unsafe and not all that useful. - Disallow empty passwords during LDAP authentication. - Fix handling of sub-SELECTs appearing in the arguments of an outer-level aggregate function. - Fix bugs associated with fetching a whole-row value from the output of a Sort or Materialize plan node. - Prevent synchronize_seqscans from changing the results of scrollable and WITH HOLD cursors. - Revert planner change that disabled partial-index and constraint exclusion optimizations when there were more than 100 clauses in an AND or OR list. - Fix hash calculation for data type interval. This corrects wrong results for hash joins on interval values. It also changes the contents of hash indexes on interval columns. If you have any such indexes, you must "REINDEX" them after updating. - Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'. It was previously handled as 'th' (lowercase). - Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million and integer datetimes are in use. - Fix calculation of distance between a point and a line segment. This led to incorrect results from a number of geometric operators. - Fix money data type to work in locales where currency amounts have no fractional digits, e.g. Japan. - Fix LIKE for case where pattern contains %_. - Properly round datetime input like 00:12:57.9999999999999999999999999999. - Fix memory leaks in XML operations. - Fix poor choice of page split point in GiST R-tree operator classes. - Ensure that a "fast shutdown" request will forcibly terminate open sessions, even if a "smart shutdown" was already in progress. - Avoid performance degradation in bulk inserts into GIN indexes when the input values are (nearly) in sorted order. - Correctly enforce NOT NULL domain constraints in some contexts in PL/pgSQL. - Fix portability issues in plperl initialization. - Fix pg_ctl to not go into an infinite loop if "postgresql.conf" is empty. - Improve pg_dump's efficiency when there are many large objects. - Use SIGUSR1, not SIGQUIT, as the failover signal for pg_standby. - Make pg_standby's maxretries option behave as documented. - Make "contrib/hstore" throw an error when a key or value is too long to fit in its data structure, rather than silently truncating it. - Fix "contrib/xml2"'s xslt_process() to properly handle the maximum number of parameters (twenty). - Improve robustness of libpq's code to recover from errors during "COPY FROM STDIN". Checksums-Sha1: a107bf4c24ff4a96e62d0cfaf1ba615f37108edb 2594763 postgresql-8.3_8.3.8-0ubuntu9.04_powerpc_translations.tar.gz 011f14d51dc70cefe5fe55a118305530be6c1156 190668 libpq-dev_8.3.8-0ubuntu9.04_powerpc.deb 4d43848092e0c018053dc03003140c824ef73314 305838 libpq5_8.3.8-0ubuntu9.04_powerpc.deb 7d4e84567d6e6614b2216e0c644f95229bdc9302 33846 libecpg6_8.3.8-0ubuntu9.04_powerpc.deb 3728703c82c8886bf35d66503a76972726f1018f 224154 libecpg-dev_8.3.8-0ubuntu9.04_powerpc.deb 0ecfd278d47950a6bdada9b38816d088d76c4ef2 11238 libecpg-compat3_8.3.8-0ubuntu9.04_powerpc.deb f69d6c36cb56e61660068a57350c15590dfcb870 273590 libpgtypes3_8.3.8-0ubuntu9.04_powerpc.deb caee05292c7eba8c5b9f60aa66d9960c93dac75c 4186362 postgresql-8.3_8.3.8-0ubuntu9.04_powerpc.deb c02d72872af91e8c3c2d588434f3da07e2170769 797492 postgresql-client-8.3_8.3.8-0ubuntu9.04_powerpc.deb 545274d330a514955de2b3b61bc6226a39810a8a 814764 postgresql-server-dev-8.3_8.3.8-0ubuntu9.04_powerpc.deb bd7dcf488cb88b875f501bab1becf1309d162a57 425176 postgresql-contrib-8.3_8.3.8-0ubuntu9.04_powerpc.deb c6b9ad7594ef6161b0e0cd2fc3aef0712c6dbd6d 270236 postgresql-plperl-8.3_8.3.8-0ubuntu9.04_powerpc.deb de9a5cb58257c68aec68bb068919f53efc365438 264604 postgresql-plpython-8.3_8.3.8-0ubuntu9.04_powerpc.deb 41782aa4e6a19363f5174aa969b56b26a85f3f9f 262734 postgresql-pltcl-8.3_8.3.8-0ubuntu9.04_powerpc.deb Checksums-Sha256: 2628ee47ff4b621cec56eb053e00520490c1108ab38055e2ebc4e309b8fce604 2594763 postgresql-8.3_8.3.8-0ubuntu9.04_powerpc_translations.tar.gz 12c4e57a0b56cbd9bc55246894651483d3fc386c7d03ee43c750bc90e2e1a316 190668 libpq-dev_8.3.8-0ubuntu9.04_powerpc.deb 308c4be24c214a2be70a196bc486286cd917f5d85e762457e026e4c8745ef4e4 305838 libpq5_8.3.8-0ubuntu9.04_powerpc.deb 8a31abebf8bcc4530058164234b64306e17cfe4c69fb943977051e0dfacd433d 33846 libecpg6_8.3.8-0ubuntu9.04_powerpc.deb 88f462db55ab1fa032f02a294daa7535350c4cff334aba5ec0ca6818b7a6faee 224154 libecpg-dev_8.3.8-0ubuntu9.04_powerpc.deb d07b0d00410d1f00556705f5732c58bd2c949fe519dcb4fca57f57298b939eaf 11238 libecpg-compat3_8.3.8-0ubuntu9.04_powerpc.deb c1b090ac78d2805aa1e8644f555fba82b5d57a2677da6c9f6a04220596f5c02f 273590 libpgtypes3_8.3.8-0ubuntu9.04_powerpc.deb ad1edb2d4fcfb634342d23e96fe9f73067c8b617c05183c7f2e2e45b235e4a2f 4186362 postgresql-8.3_8.3.8-0ubuntu9.04_powerpc.deb 655e013cf04512426bfcebdd4a03c4ff1ef6de8d24242b4350e93d4771819a0f 797492 postgresql-client-8.3_8.3.8-0ubuntu9.04_powerpc.deb 7c7dca719e07e422e0874d45bce020bf31c260827175c02920791266875aca89 814764 postgresql-server-dev-8.3_8.3.8-0ubuntu9.04_powerpc.deb e774102a9f54dc3a41eba75587dbfa0deda07c444ea5ce121e7c851f31089fde 425176 postgresql-contrib-8.3_8.3.8-0ubuntu9.04_powerpc.deb 49551059172c2a3abeb8517111bc8d40e6cdd5f32b9dbf868f37b97f2b03673a 270236 postgresql-plperl-8.3_8.3.8-0ubuntu9.04_powerpc.deb 2daa951fe83e5aa5886ecc9adaaf315d4c95eab87aad280fbd4ae5760ccc27ea 264604 postgresql-plpython-8.3_8.3.8-0ubuntu9.04_powerpc.deb 3e550d27ff779bfa87f59d259aafade81ba171bdecd0c3dffcffbf5e6c4ef5ae 262734 postgresql-pltcl-8.3_8.3.8-0ubuntu9.04_powerpc.deb Files: 226c5eeb2093f49e0a82b9ae007ac93c 2594763 raw-translations - postgresql-8.3_8.3.8-0ubuntu9.04_powerpc_translations.tar.gz baef9f56448e96d7e62b68f6227896f3 190668 libdevel optional libpq-dev_8.3.8-0ubuntu9.04_powerpc.deb cc4d988118b5d8c2241582b4048f9fad 305838 libs optional libpq5_8.3.8-0ubuntu9.04_powerpc.deb fb12d7a4492d41675f0afe2a0bae16a4 33846 libs optional libecpg6_8.3.8-0ubuntu9.04_powerpc.deb c18888026765114ff4be2365345c5de0 224154 libdevel optional libecpg-dev_8.3.8-0ubuntu9.04_powerpc.deb c1a1c781de3dabc0cf6d3c2bb599f609 11238 libs optional libecpg-compat3_8.3.8-0ubuntu9.04_powerpc.deb a29352522711181f86e3b0ee1a38a3a4 273590 libs optional libpgtypes3_8.3.8-0ubuntu9.04_powerpc.deb 702f2df7d954c9d74ae709dfdc4d64ca 4186362 misc optional postgresql-8.3_8.3.8-0ubuntu9.04_powerpc.deb 34366b52ed4f40649e33778084d07358 797492 misc optional postgresql-client-8.3_8.3.8-0ubuntu9.04_powerpc.deb 2230c7d33904261270259a54e84f743f 814764 libdevel optional postgresql-server-dev-8.3_8.3.8-0ubuntu9.04_powerpc.deb 1d735361983001b534835e34d7f7c38d 425176 misc optional postgresql-contrib-8.3_8.3.8-0ubuntu9.04_powerpc.deb 094ca06c106bd6862be95328fdedcd67 270236 misc optional postgresql-plperl-8.3_8.3.8-0ubuntu9.04_powerpc.deb c9f52f3b35901d1959112a8f81c0f894 264604 misc optional postgresql-plpython-8.3_8.3.8-0ubuntu9.04_powerpc.deb 4f3e10623a42622b32a3dcd5e3b222fc 262734 misc optional postgresql-pltcl-8.3_8.3.8-0ubuntu9.04_powerpc.deb