-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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: mipsel Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: mipsel Build Daemon (phrixos) 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: fa534ef0fb75df2ec99ecfaadc346d9caaae1ff7 245142 libpq-dev_8.4.10-0squeeze1_mipsel.deb b84187bf8f0269d35dc8344d17ae3ae250a308dc 154368 libpq5_8.4.10-0squeeze1_mipsel.deb ef2eda4dd3f8d69a0c581d0abbfa1360f550af4f 95960 libecpg6_8.4.10-0squeeze1_mipsel.deb fa6b545fb2d2e0ded23bf4f7dea516716d776de1 249632 libecpg-dev_8.4.10-0squeeze1_mipsel.deb d70c4a4db2bee25bf1c1d10ab2357b329753d5d8 32384 libecpg-compat3_8.4.10-0squeeze1_mipsel.deb e85150a70367955bb505b7cb4301ce5793794c84 58884 libpgtypes3_8.4.10-0squeeze1_mipsel.deb d2208578573d94f79d587c12c53061e223fce3c1 5313778 postgresql-8.4_8.4.10-0squeeze1_mipsel.deb 1f4a76f4cc34495ab4be4e4d68ab5c9f395b9088 1481066 postgresql-client-8.4_8.4.10-0squeeze1_mipsel.deb 526d48c618ce0a0bf02a3a25ca4c0b406f511352 641290 postgresql-server-dev-8.4_8.4.10-0squeeze1_mipsel.deb b081b2055ecc8b7fbd7a8d69450b9446d57df5f1 390092 postgresql-contrib-8.4_8.4.10-0squeeze1_mipsel.deb 8ad026bffc8184866be3bb0e5d2d8fdb50d51d16 57382 postgresql-plperl-8.4_8.4.10-0squeeze1_mipsel.deb 9cd2b3a1965a4374c9d91a2b922e03dbca27fa87 61114 postgresql-plpython-8.4_8.4.10-0squeeze1_mipsel.deb dd2d38511995c2da306fad7e8cb4ad5e7ae167bd 47648 postgresql-pltcl-8.4_8.4.10-0squeeze1_mipsel.deb Checksums-Sha256: 86855f38fa6b9cc06c795cb9cb06fba02fa016c282f635fa4380e83c2bfc6a2d 245142 libpq-dev_8.4.10-0squeeze1_mipsel.deb 378b11e353f4bf00d6672259cfe8127e0e37f30a82360e8a2fdfa7140b7fadbe 154368 libpq5_8.4.10-0squeeze1_mipsel.deb ddcaa783de06fc8cd0698d3add8c3b1d947f450581811581ca2df6609a242efb 95960 libecpg6_8.4.10-0squeeze1_mipsel.deb 859ecc5a2bbc1da2757efaa0d559f444170709464112624f7096613086f317e5 249632 libecpg-dev_8.4.10-0squeeze1_mipsel.deb 524b8b039068955e7aae96290bbc7094cb06b65a30b421fa33334388f9a8b654 32384 libecpg-compat3_8.4.10-0squeeze1_mipsel.deb ea7549822ff99d0b075a2b5072d6010b6e5656607bfe9b2148cea1833331cc09 58884 libpgtypes3_8.4.10-0squeeze1_mipsel.deb 6d7b0c5dfa70429ed3b44c0121ee680a4205ce4b5d7d6d94f6d513380332a634 5313778 postgresql-8.4_8.4.10-0squeeze1_mipsel.deb 429754f7906eb6f98e63f9dffe264fb1ba71dfd11cd0090d1ff851b125d832b7 1481066 postgresql-client-8.4_8.4.10-0squeeze1_mipsel.deb fab442ad5f0187167e738ac4a47523407bd5818d5cc0d5f44b7c4ff090ea29ba 641290 postgresql-server-dev-8.4_8.4.10-0squeeze1_mipsel.deb a9f61b33f53f5a94ed165e186ba3cb908803e45bc3af8daa9dcca6f653d54c6e 390092 postgresql-contrib-8.4_8.4.10-0squeeze1_mipsel.deb 051e65db09756e8791a64aec50fe288d2c241e4b5b31213e4c8fad3b89f39210 57382 postgresql-plperl-8.4_8.4.10-0squeeze1_mipsel.deb 1e2e66e4f40d47cbf5acfa15981ee2b3dfed3355b1f2874e3771aa23aff565d6 61114 postgresql-plpython-8.4_8.4.10-0squeeze1_mipsel.deb bbe7474e7d2007bc96a8dc63de919e147ee449a60cc76cf001d24345d474c551 47648 postgresql-pltcl-8.4_8.4.10-0squeeze1_mipsel.deb Files: 65d53e7111595893cdf1793e50a25e38 245142 libdevel optional libpq-dev_8.4.10-0squeeze1_mipsel.deb 11039d4220e9fb8fc17a23d404cb4b54 154368 libs optional libpq5_8.4.10-0squeeze1_mipsel.deb eeff06b46e28f0b6d98f0d6bf864af20 95960 libs optional libecpg6_8.4.10-0squeeze1_mipsel.deb e26687dbb050da45d689b393838d3b97 249632 libdevel optional libecpg-dev_8.4.10-0squeeze1_mipsel.deb 389219663d0f1fb2297bb368c64628f8 32384 libs optional libecpg-compat3_8.4.10-0squeeze1_mipsel.deb f321b6c601e475656e9e9e1b882f065a 58884 libs optional libpgtypes3_8.4.10-0squeeze1_mipsel.deb 827ddc5ccb1b196d4c2b0e2e923f2f32 5313778 database optional postgresql-8.4_8.4.10-0squeeze1_mipsel.deb e6c7f81fa41ed4699e5e449809334d85 1481066 database optional postgresql-client-8.4_8.4.10-0squeeze1_mipsel.deb 383c644d734d02e759c82872dce39438 641290 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_mipsel.deb 280a4d58f848b31069ba50693ab4f000 390092 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_mipsel.deb bc0e66da64fb9819a8b6471717d51b4f 57382 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_mipsel.deb 7623d02e0ca66ad1ce97761a2820ef64 61114 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_mipsel.deb 9e648f4d972e157c4f6a0da26637c0b4 47648 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_mipsel.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAk7uXYkACgkQmdOZoew2oYXBDACfXLIolx1Zrd8aCnbdbKaX0+c/ evQAnivYJqQH6/S0O06qz7ZeyWemE+qI =N/76 -----END PGP SIGNATURE-----