-----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: mips Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: Debian 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.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: d160eeb0d6dd6a9303642d344cc76564c362fdbf 246098 libpq-dev_8.4.10-0squeeze1_mips.deb 1a211954a6ad19517b16ec7c4d59196fa087dc08 156096 libpq5_8.4.10-0squeeze1_mips.deb 1303d96ff77d79248d66ef17a16fbfd93c4db294 96830 libecpg6_8.4.10-0squeeze1_mips.deb 2d0467662cde901250fbb2101d04448770bee536 252956 libecpg-dev_8.4.10-0squeeze1_mips.deb 2bf1e811841e7850f6d8831e823bb76ff4467d16 32466 libecpg-compat3_8.4.10-0squeeze1_mips.deb a2ce3da01201d6158250147886a288b50887a4a9 58948 libpgtypes3_8.4.10-0squeeze1_mips.deb 34331d7decb4b4ee1927fe7d3fd553d755979c3c 5670806 postgresql-8.4_8.4.10-0squeeze1_mips.deb cf3e169a1f042029c4689084c9e2b71a2a204c1d 1483248 postgresql-client-8.4_8.4.10-0squeeze1_mips.deb b37e2b1bf92e302a7467299acfeda1c74b9e935e 642838 postgresql-server-dev-8.4_8.4.10-0squeeze1_mips.deb 86ef2cd985df2496c920c91ab291ffafdc4a044c 395794 postgresql-contrib-8.4_8.4.10-0squeeze1_mips.deb 008c1be3601cfebcce572b18427bf3637c263597 57506 postgresql-plperl-8.4_8.4.10-0squeeze1_mips.deb 8abb5188a9de14a6219164fbabd2580706240a90 61432 postgresql-plpython-8.4_8.4.10-0squeeze1_mips.deb 8abd9df498a46dcb1222809a85ba29a2baa56509 47672 postgresql-pltcl-8.4_8.4.10-0squeeze1_mips.deb Checksums-Sha256: b0ebffa51931a2bc254f27487d216a5c5969ab317205ada7931446cdebe154f7 246098 libpq-dev_8.4.10-0squeeze1_mips.deb 25ec737fc547b079349987f886582c02976cf477e50ba7bd8b080d9d32d7a291 156096 libpq5_8.4.10-0squeeze1_mips.deb 5d7a75e188df886029009be639fecb9271ebed19f94ab155c1593cd806ca1729 96830 libecpg6_8.4.10-0squeeze1_mips.deb e4b7129659285ee34b764e25af744aa49c812886838a491615eaa8731c0ef0fc 252956 libecpg-dev_8.4.10-0squeeze1_mips.deb ca724ee6000ee7df94d9b6fa28271b2c1fecf54e60c406e12862478ab4f10617 32466 libecpg-compat3_8.4.10-0squeeze1_mips.deb 0069644eb1637f22a759f31248b8e857ee2da64b95b01b7fe887d207944003e8 58948 libpgtypes3_8.4.10-0squeeze1_mips.deb 4f66437653ee5cd3e4def3b73aa99eee6aca4870f2639b4d0229b24143121f45 5670806 postgresql-8.4_8.4.10-0squeeze1_mips.deb f79ff923d7903293393ed02eee5f4480b31e341333b16f2696d48e5a87bbd6ee 1483248 postgresql-client-8.4_8.4.10-0squeeze1_mips.deb 7d48988cbd81bd0a0420e64abd20d6fb1889e5d5ec4291c9e6659b2a67ebd614 642838 postgresql-server-dev-8.4_8.4.10-0squeeze1_mips.deb 3a1b266cacc3b5d523499ee40a6833ddad902fe720ba013bb46847c60306950f 395794 postgresql-contrib-8.4_8.4.10-0squeeze1_mips.deb 033e101694417f17845195545794ca268daf45a90500accb2f5ef1272ae4ea9d 57506 postgresql-plperl-8.4_8.4.10-0squeeze1_mips.deb 1a970a5a208639cb1c0d7267cf69cbf6d0a5615863d875c89374d9607914583d 61432 postgresql-plpython-8.4_8.4.10-0squeeze1_mips.deb 25ac73efa902776f139e22f3cb4bece175b3ac4567b88d9d88a86d32010861a8 47672 postgresql-pltcl-8.4_8.4.10-0squeeze1_mips.deb Files: a275fc520fb18f6fd4533b4ad0d7da70 246098 libdevel optional libpq-dev_8.4.10-0squeeze1_mips.deb bfd8e4941d8aa27070a3961f3525ed00 156096 libs optional libpq5_8.4.10-0squeeze1_mips.deb 8e4ac735191aba328f8b204ddf947395 96830 libs optional libecpg6_8.4.10-0squeeze1_mips.deb 4ba408a2d67cc3252506059d2f63b283 252956 libdevel optional libecpg-dev_8.4.10-0squeeze1_mips.deb 0dbf83146e95ffc140d723e2415ddc46 32466 libs optional libecpg-compat3_8.4.10-0squeeze1_mips.deb e1e60dada6f33282b06cce902f8da7d7 58948 libs optional libpgtypes3_8.4.10-0squeeze1_mips.deb 4b097e072b382ebb3edef6b502e371e5 5670806 database optional postgresql-8.4_8.4.10-0squeeze1_mips.deb 6128c7bc32a6cdae62aa1e9dee978155 1483248 database optional postgresql-client-8.4_8.4.10-0squeeze1_mips.deb 1b63bb4ed4dade7305c7b959168b8e52 642838 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_mips.deb 7e4991dd4a1490daf46e8e4489ce5f00 395794 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_mips.deb a7b2b9a551a4e3201e879d909728acd4 57506 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_mips.deb b947d062320d5c795c71db6f33119b15 61432 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_mips.deb b73149b64f7d90d860c868c5285809d4 47672 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_mips.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7McfAAoJEKAUSqXS1Z2argsQAL6kF6GXs7aFp75s3ZZfj8MJ xFmOakotOxdOqqdeYSEx0vzX7bi+LQJD6VoOuFxd1k+23eclVgxf1mrJU3BmCnkt 3Xx0qH+9ryURZ7zckSynjyt+uv6RiA/1UBRumIL6445pucqH+sh5ZeI3986x9u2c Dw3jMPlgRYf4C1WATlBSkEza7Klp2aA+bUE1eO7rsXcpr1cWbeMLofApuugV3Ge1 /MjsVn9dq4C340T1t5fL/ff8WSyEAvS0uI9mtvyaz0GlDA5PT4hRYdVnSE7MNUop 8L5HZFa0eASBr1r3LSEFlQk+HfxoykqYcJjG+qkNe4syrw9gPprbT65hCLPqdMCR 5f8dpufoTz4lrriivvKpfD7WbmoK1vBF5bS3jGIt0hq892TbR0VKqmCauI0I6O/B 4D47qkLKOVzWNT9MMTQfB0FCD+Luabho5lb+kVdWM6ziTBDjZhCk0v8BEWgfA/0M GtH0lnZNcfY6Pp6yOi4duFva0qRcCfXErJpRc4ZHDoOrPAhgEbsZWwg6JKJYh5ps 7qFQwekyDpf5PHH/lCGKUlz5hrXIWRH7IuHvHwpifJsX4fnEN3ORG4riZYUZfgWj ydIEtC2w1TEx+xPZR1L0/Nbs+kRcVZZlFiiv0XXv7hG7YwYCSkvekn7hSgXP1bNZ TssEuJiJnLGeAlkqUNQh =iuKU -----END PGP SIGNATURE-----