-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Format: 1.8 Date: Sat, 03 Dec 2011 16:56:34 +0100 Source: postgresql-8.4 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-8.4 postgresql-client-8.4 postgresql-server-dev-8.4 postgresql-doc-8.4 postgresql-contrib-8.4 postgresql-plperl-8.4 postgresql-plpython-8.4 postgresql-pltcl-8.4 postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: ia64 Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: ia64 Build Daemon (alkman) 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.4 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql - object-relational SQL database (supported version) postgresql-8.4 - object-relational SQL database, version 8.4 server postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-8.4 - front-end programs for PostgreSQL 8.4 postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-contrib-8.4 - additional facilities for PostgreSQL postgresql-doc - documentation for the PostgreSQL database management system postgresql-doc-8.4 - documentation for the PostgreSQL database management system postgresql-plperl-8.4 - PL/Perl procedural language for PostgreSQL 8.4 postgresql-plpython-8.4 - PL/Python procedural language for PostgreSQL 8.4 postgresql-pltcl-8.4 - PL/Tcl procedural language for PostgreSQL 8.4 postgresql-server-dev-8.4 - development files for PostgreSQL 8.4 server-side programming Changes: postgresql-8.4 (8.4.10-0squeeze1) stable; urgency=low . * New upstream bug fix release: - Fix bugs in information_schema.referential_constraints view. This view was being insufficiently careful about matching the foreign-key constraint to the depended-on primary or unique key constraint. That could result in failure to show a foreign key constraint at all, or showing it multiple times, or claiming that it depends on a different constraint than the one it really does. Since the view definition is installed by initdb, merely upgrading will not fix the problem. If you need to fix this in an existing installation, you can (as a superuser) drop the information_schema schema then re-create it by sourcing "SHAREDIR/information_schema.sql". (Run pg_config --sharedir if you're uncertain where "SHAREDIR" is.) This must be repeated in each database to be fixed. - Fix incorrect replay of WAL records for GIN index updates. This could result in transiently failing to find index entries after a crash, or on a hot-standby server. The problem would be repaired by the next "VACUUM" of the index, however. - Fix TOAST-related data corruption during CREATE TABLE dest AS SELECT - FROM src or INSERT INTO dest SELECT * FROM src. If a table has been modified by "ALTER TABLE ADD COLUMN", attempts to copy its data verbatim to another table could produce corrupt results in certain corner cases. The problem can only manifest in this precise form in 8.4 and later, but we patched earlier versions as well in case there are other code paths that could trigger the same bug. - Fix race condition during toast table access from stale syscache entries. - Track dependencies of functions on items used in parameter default expressions. Previously, a referenced object could be dropped without having dropped or modified the function, leading to misbehavior when the function was used. Note that merely installing this update will not fix the missing dependency entries; to do that, you'd need to "CREATE OR REPLACE" each such function afterwards. If you have functions whose defaults depend on non-built-in objects, doing so is recommended. - Allow inlining of set-returning SQL functions with multiple OUT parameters. - Make DatumGetInetP() unpack inet datums that have a 1-byte header, and add a new macro, DatumGetInetPP(), that does not. - Improve locale support in money type's input and output. Aside from not supporting all standard lc_monetary formatting options, the input and output functions were inconsistent, meaning there were locales in which dumped money values could not be re-read. - Don't let transform_null_equals affect CASE foo WHEN NULL ... constructs. transform_null_equals is only supposed to affect foo = NULL expressions written directly by the user, not equality checks generated internally by this form of CASE. - Change foreign-key trigger creation order to better support self-referential foreign keys. For a cascading foreign key that references its own table, a row update will fire both the ON UPDATE trigger and the CHECK trigger as one event. The ON UPDATE trigger must execute first, else the CHECK will check a non-final state of the row and possibly throw an inappropriate error. However, the firing order of these triggers is determined by their names, which generally sort in creation order since the triggers have auto-generated names following the convention "RI_ConstraintTrigger_NNNN". A proper fix would require modifying that convention, which we will do in 9.2, but it seems risky to change it in existing releases. So this patch just changes the creation order of the triggers. Users encountering this type of error should drop and re-create the foreign key constraint to get its triggers into the right order. - Avoid floating-point underflow while tracking buffer allocation rate. - Preserve blank lines within commands in psql's command history. The former behavior could cause problems if an empty line was removed from within a string literal, for example. - Fix pg_dump to dump user-defined casts between auto-generated types, such as table rowtypes. - Use the preferred version of xsubpp to build PL/Perl, not necessarily the operating system's main copy. - Fix incorrect coding in "contrib/dict_int" and "contrib/dict_xsyn". - Honor query cancel interrupts promptly in pgstatindex(). - Ensure VPATH builds properly install all server header files. - Shorten file names reported in verbose error messages. Regular builds have always reported just the name of the C file containing the error message call, but VPATH builds formerly reported an absolute path name. Checksums-Sha1: 73bdda294ee5ff526b43d0c399740dfe1f4ba0cb 285830 libpq-dev_8.4.10-0squeeze1_ia64.deb b7c3e313698c3ba3dfbe413495ecae9a710ac2f6 189524 libpq5_8.4.10-0squeeze1_ia64.deb 44ddbcc441a2f73c5035f256b9d4171d2f807dbb 109066 libecpg6_8.4.10-0squeeze1_ia64.deb a01f09fc3f81b390dfc867b39d290bf2ef677670 353062 libecpg-dev_8.4.10-0squeeze1_ia64.deb 6bfd12d7198b49c4d69ac84affb7c1f68aa88a06 36254 libecpg-compat3_8.4.10-0squeeze1_ia64.deb abca3c7273aefb71cff9ab391b6c953f120413fd 73604 libpgtypes3_8.4.10-0squeeze1_ia64.deb bbda1d3f7c3473ae950a77c65838c1d60af93b16 6490358 postgresql-8.4_8.4.10-0squeeze1_ia64.deb 6a93875beab7864d096c1429d42126914dabdfad 1716326 postgresql-client-8.4_8.4.10-0squeeze1_ia64.deb 6dfccdb72cf7bde7ba370f70da635048b1a49d00 650528 postgresql-server-dev-8.4_8.4.10-0squeeze1_ia64.deb 288722cc133caaa4568388cb724af9e4edeecd63 572930 postgresql-contrib-8.4_8.4.10-0squeeze1_ia64.deb 8765c4dd4b9172d190433281081cbb708e884edc 78874 postgresql-plperl-8.4_8.4.10-0squeeze1_ia64.deb 8ba02b7a9f366320289310b89f5734e34f413c68 75258 postgresql-plpython-8.4_8.4.10-0squeeze1_ia64.deb 257ded814ce081961b604188ef0d74d237e8673a 55606 postgresql-pltcl-8.4_8.4.10-0squeeze1_ia64.deb Checksums-Sha256: 99f73a35fa0f3ab163414fbb06df1d1496495306f5788c1ad0b34449cc6f27aa 285830 libpq-dev_8.4.10-0squeeze1_ia64.deb c742af9ca14acb7db3164484732add1498fb42b2c5d18ac2339d9d45f5c31926 189524 libpq5_8.4.10-0squeeze1_ia64.deb 8c3916950d8d0b8e35a6deffacc33b7dde5212a0871781d07ae722728e96b030 109066 libecpg6_8.4.10-0squeeze1_ia64.deb 6abbb39f973a54a4e91acfbfc3da100f01f49bdf2ef60d140868d400fc1c7d08 353062 libecpg-dev_8.4.10-0squeeze1_ia64.deb 19ec008ba5dddefdafdd6c99a13d442de2577f4fae005198dfc9df377104ad0e 36254 libecpg-compat3_8.4.10-0squeeze1_ia64.deb 1d45b60ded0c874ff6f8946b43346cf799f3cdb64f735b4bdd47f1c4ec838442 73604 libpgtypes3_8.4.10-0squeeze1_ia64.deb 2eb029388da58fad6b76a6020c6078c3c0a29e81bb844dcc9ecc01191f26ee8d 6490358 postgresql-8.4_8.4.10-0squeeze1_ia64.deb ad60fa53da932f229e2c8456573f5abb879ea7ecdbb0c33022439699798101cc 1716326 postgresql-client-8.4_8.4.10-0squeeze1_ia64.deb 4ddd00dc26fd8ee99fc1c483b691a71d74702f137c2bd7a1e60979a60e163833 650528 postgresql-server-dev-8.4_8.4.10-0squeeze1_ia64.deb ac312f5a405498d98ade9fa583809ef1cce4b9a49ad7530eeb10f7ad0d1d1cae 572930 postgresql-contrib-8.4_8.4.10-0squeeze1_ia64.deb 58799545298f539b49bd851126cab260530f8a769769ad695d5e0809ba5062e3 78874 postgresql-plperl-8.4_8.4.10-0squeeze1_ia64.deb 6338904a6cef0766eebd078e4a6e892653f4a65e6d68a0c6a668e8b6e65866ab 75258 postgresql-plpython-8.4_8.4.10-0squeeze1_ia64.deb 07d7f0aae40d17ae60e2007a242a3f893a7e494f4ffda92984f07f32fc9e535e 55606 postgresql-pltcl-8.4_8.4.10-0squeeze1_ia64.deb Files: 759a063e40cb569494a1ae5b6a381b23 285830 libdevel optional libpq-dev_8.4.10-0squeeze1_ia64.deb 17e4dae0aca530c64bd36dee290102fb 189524 libs optional libpq5_8.4.10-0squeeze1_ia64.deb ded59a126c07d1604af83bcb86b7bae7 109066 libs optional libecpg6_8.4.10-0squeeze1_ia64.deb 33c74398cc4d9b6d496dde97cf0b4157 353062 libdevel optional libecpg-dev_8.4.10-0squeeze1_ia64.deb b63cc6d23eb8d518f199a5574555df6d 36254 libs optional libecpg-compat3_8.4.10-0squeeze1_ia64.deb 8d4e3014c5868e345ffeee9892c109e9 73604 libs optional libpgtypes3_8.4.10-0squeeze1_ia64.deb 93f53751384669b203599b0e647ce1b6 6490358 database optional postgresql-8.4_8.4.10-0squeeze1_ia64.deb d5f42f05cb4cb19d6959efc8b95329c0 1716326 database optional postgresql-client-8.4_8.4.10-0squeeze1_ia64.deb 896f3be22826a62a18ee2d39d856ed41 650528 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_ia64.deb ba106a2bc1f690785e41dec8e0eb6816 572930 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_ia64.deb 5a27e2006f3e7173d7545449dc03292d 78874 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_ia64.deb b9632b0e9f90a149be9bdee8fb8319cf 75258 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_ia64.deb 95209cfa6f2f25e5128a3b39a9f6d391 55606 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_ia64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7L52AAoJEEvpbjz8HoZoUrMQAKFXA9LY5FgGKDOcHnOWMd0Z uNz992BI7B7RK5y328CAqeG9N+Ggc/wMushzwGs9KU4e7tZPexo5cTxm4wHeotj7 uRilx26e4sxz7/jKzgGeewihQdcTEbB35HbUQP4pdhwSC/qf3q3rox9PhJWCCQTH lWPxb5pPtE3VuqukrhKejYHnyVmxp1ceoZv2EdKQvT4GT4/Y+AJmGxr908pCeCKt HAlp5/B1CuunIPoBQVa9ku8Phuonu15C7lfOnU5g+X/EWcMgbMpObuG3gdzNNaon iAmwCN54ds2jXVgJyj8kiw5SXNiiEmBlo6ZrRfgN1ZjzijWIAByCBiPN/ZSorBVd tDjrPmX2T+RBExaXWppM4xQtsJULvMy8lJvaiidW3jXG+/4cOtfPwHXXgIbT3ocb Vo4Xuil7zNO+r6LYCnIgzhbdXn1n5bldgSMoOQ/I16oM7uSsJaVM66yl4AwGrdvg 9A0OrxB4PBNkyDu1dAEwyQBxYLbKnwFtGxl7nscl2l4cgS6CqCI8hdaTsGiabfoF 4U9UoDSrr6/3L32H+M8rOkJEnILC9KjwKuwieb0+DNMEi7gXlqzIyhYWpmAwe8x1 sFIGm/QGEU7gsBAapF/9dD5dyGUNEVO3W6Bp+3+N/oW1/T9b3Sp1jI90PcxTjhV1 6lSvsonoAbVRACXimkvf =drNr -----END PGP SIGNATURE-----