-----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: source all amd64 Version: 8.4.10-0squeeze1 Distribution: stable Urgency: low Maintainer: Martin Pitt 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: 090fb9d56d48af0f07160802870d7f4029833599 2506 postgresql-8.4_8.4.10-0squeeze1.dsc 1ae736d90cc84feb8b604f58fa7aa4e3fa415778 18157949 postgresql-8.4_8.4.10.orig.tar.gz 9972014226ebfd7dae4d97e14a934d5b2aa02fae 52659 postgresql-8.4_8.4.10-0squeeze1.diff.gz 7657eae6953ab0047c0aeb50df914e6a54f334bf 2172840 postgresql-doc-8.4_8.4.10-0squeeze1_all.deb dc02b676ef592b03a9203cb266c9747d626ca086 25294 postgresql_8.4.10-0squeeze1_all.deb 6b9436226b9f2115a0012153689efac8317c15f0 25262 postgresql-client_8.4.10-0squeeze1_all.deb 51c6e9a10731f930b3aebb03950cc2cdab1b58db 25108 postgresql-doc_8.4.10-0squeeze1_all.deb 030359092bd7f2d117de9e87c58c96727d8565e0 25156 postgresql-contrib_8.4.10-0squeeze1_all.deb 9abad6dbf876069ed178caadcd698379a2570f8a 244180 libpq-dev_8.4.10-0squeeze1_amd64.deb 580aa18c2bde43f30704c39352ec3bcb26af20e5 164796 libpq5_8.4.10-0squeeze1_amd64.deb 9366ecfcd40403a9318681bafa685bc754685548 97276 libecpg6_8.4.10-0squeeze1_amd64.deb 6bd7b71bb7f518694a766e541ed4349e6f588e84 263224 libecpg-dev_8.4.10-0squeeze1_amd64.deb de422632699b5f8aaa08d090940404eab69b7959 33102 libecpg-compat3_8.4.10-0squeeze1_amd64.deb 60c2a034dc9bf17b26eec8161234907c49f89a9d 56978 libpgtypes3_8.4.10-0squeeze1_amd64.deb 39e8791e6ec9645789b59d0a56d59d27f61e0d76 5483590 postgresql-8.4_8.4.10-0squeeze1_amd64.deb 2ef2901983db9840c1a65f5aeef22b06c843816d 1530562 postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb 62da07ceca52672225560afe0b4cd8e595360b54 642276 postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb 8813b8ee7afa805c702100d5e5491098d87436d6 436238 postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb 613161ab125cbec14bd27da835e09a74e6956e2b 62450 postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb 2c6a17eb525e153192a466de7c8a0d61b44d1457 63656 postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb 1f79d0ae46ad47913c23ab75a826521e56b24f69 48212 postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb Checksums-Sha256: 4e46b8784ce4e7b134b53d0b5b60cb8492afd0d7c06cbf489fb153db28ea9806 2506 postgresql-8.4_8.4.10-0squeeze1.dsc 8da06d33a08004293d70eac1d006c8af3d8aec6e13b509fdcf0ff800e48c4cd7 18157949 postgresql-8.4_8.4.10.orig.tar.gz e77a170df35e2418ee3bf41f7f66ba48c3cd9d4c56dd383d4ad55a43631d4353 52659 postgresql-8.4_8.4.10-0squeeze1.diff.gz d6d57e93c9434628bb3cc27688ece3ebb46358df26033996c682bf454f8b53ff 2172840 postgresql-doc-8.4_8.4.10-0squeeze1_all.deb 7cfb1415ff39d99219669c2169e8e4f2c2df6c55948cd4547593f07bcd65369d 25294 postgresql_8.4.10-0squeeze1_all.deb ef8eaa21dadbf208f58463fdb8e0ca4c085081d4200b5276921ebb1c8107985c 25262 postgresql-client_8.4.10-0squeeze1_all.deb 3653b615053ca0c567844d161b248a94d4dcaf8defab59f72d0da702efe6ae0f 25108 postgresql-doc_8.4.10-0squeeze1_all.deb 9e3eb39c82f4ef0036b9a21624500e498a7f4904fde15a19cb3a134903b16809 25156 postgresql-contrib_8.4.10-0squeeze1_all.deb bd9fb5bbda43d7c1b021507868a6579b35f0779cc0a441e5ee7c2e0f8813bd2f 244180 libpq-dev_8.4.10-0squeeze1_amd64.deb d45d1c9a86e328bc52580d834d73face34d7f1f66e1cc1e7d5ab5a503cfc26f2 164796 libpq5_8.4.10-0squeeze1_amd64.deb 923c0b6dd6b4662d23b752e6e689d470f11a7f4e4fa50e3931076eb9a083a93c 97276 libecpg6_8.4.10-0squeeze1_amd64.deb 818c68c86c6205c60930300f6814b7da592fc16cd19d332f242d775adc4448b8 263224 libecpg-dev_8.4.10-0squeeze1_amd64.deb bea0d117b3bec15f6c7a997c71e1e76a87f9209387bd20ebafc87b7b4e34416a 33102 libecpg-compat3_8.4.10-0squeeze1_amd64.deb e707e3b311c8552bcadd10b104090a704b28ff76e2c9d0d2e5cf5eeeaa128957 56978 libpgtypes3_8.4.10-0squeeze1_amd64.deb 3e94ea69735c93a1347a85cf9e6ce26a5ae8416353c8cf49822b8500c9941c90 5483590 postgresql-8.4_8.4.10-0squeeze1_amd64.deb 0881526afceb7b4995123c6b338b10dce50540dc6a101f9b065cddc1cc8dcc86 1530562 postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb e897c95fbd6867e8723ebaeab190cf11e0a51ea51729a5291995046d1243c237 642276 postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb f416fb91faeeb706bb9541154bd4c4032ab473aa2fd902ccec2ee8f4d35ee341 436238 postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb 8a3d9724a1ff0433aafe45964ed17193a1f9d96b731ee346f6da21dfeac1ba3e 62450 postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb a6c26fc7e05457ca761f7de2462b2065425835cd35317c8834803a342aaaa293 63656 postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb f6578c3b372e52f7ca2b864095526b7e072b12a40c2d954d236b3e82cf527a2d 48212 postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb Files: 83edb1fc396b241ff0d6a109b663478b 2506 database optional postgresql-8.4_8.4.10-0squeeze1.dsc c2776cf3da7923ac4af0ca5c164016ea 18157949 database optional postgresql-8.4_8.4.10.orig.tar.gz 2352f99e274e10be9783772ba94ec7e3 52659 database optional postgresql-8.4_8.4.10-0squeeze1.diff.gz 33bae55855792bcb06e21cd79ddcec66 2172840 doc optional postgresql-doc-8.4_8.4.10-0squeeze1_all.deb 536dd6428d1878b81b5d923ee25637ef 25294 database optional postgresql_8.4.10-0squeeze1_all.deb 4fe9dca6a707b03ab67545c3e671f2bf 25262 database optional postgresql-client_8.4.10-0squeeze1_all.deb bb8fd6bede95ae8829a98780f8bc29e9 25108 doc optional postgresql-doc_8.4.10-0squeeze1_all.deb a40fa122848f3b838a31959553940a5b 25156 database optional postgresql-contrib_8.4.10-0squeeze1_all.deb ec77fb333865d60b66a8d4216650f6db 244180 libdevel optional libpq-dev_8.4.10-0squeeze1_amd64.deb c2b057aa40d300b748edfe2fe6e58d82 164796 libs optional libpq5_8.4.10-0squeeze1_amd64.deb 8362f6a1fe4be7ce98407d3c1642f28b 97276 libs optional libecpg6_8.4.10-0squeeze1_amd64.deb ef6f9cc9e042af39f07e34da8e4edf91 263224 libdevel optional libecpg-dev_8.4.10-0squeeze1_amd64.deb 8c0da0c2912712b185dabf793fa66024 33102 libs optional libecpg-compat3_8.4.10-0squeeze1_amd64.deb c43dfc6896113b83df1a9b06d776a4e1 56978 libs optional libpgtypes3_8.4.10-0squeeze1_amd64.deb a805783a8036658794013d511259f58d 5483590 database optional postgresql-8.4_8.4.10-0squeeze1_amd64.deb 093f9bdf353ed602fa6679feaff9344e 1530562 database optional postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb 147dfadf71b1285409b87162f3fd7c39 642276 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb 76112a27c3cd5bbe043a2dd21489d28e 436238 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb 30e2016a8136194c4e01fbd1e72ff020 62450 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb 9137227ec7bee01cf3cdc4eb24d5ada5 63656 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb 3365f03edb707d339a01b0340218d00b 48212 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO6v00AAoJEPmIJawmtHufebkP/iMlUx9IY9/Hbc5rb3ftrVFq TC42S7fztoowDmhgkfxPiweO6GxB2+3qwZ9iXPdy4ZBVTHCqwnoCjnnr5trm8tC8 PEcg6C7taCi6n0o6OijzO+lSm2EXdOgt4LA8Qjz4R9xbaxXV16J8YRZqQt12ohi9 MVqdpjqQmN7kWpB22v3RNNbpE03M6/2UkNkgwP4Gc40hKLhFuzJJrJRQFFvnJz+m 3C02hS3HuCbobDAs/RjTv/Zpz8UXcHlUQpICD1EMjXYcx2APSmcsQErv0FKOjiJg qX0FsAMjPlKMx9IRfPJCVANpj6mgYjLhsor88WCQYKIv0gphBzglssPEuwqoXUzX VXvtoLZZ98/zHRjskS0Zv25seW4iEuSeBa5WsFpdO6ER+jJgAkrkmEPB5p7NPJWB CyojwR2ikhkds5CHqWrIOjfBeh8kLsQvYo37jyZb8BAy1SFAE4xwDsghURoJ3ayI hxIy/i6JFZcfTEITZxYyU3dRy5W0YW5D8jwAnJQ9m8bpB42UE/z/TJR8C3cOsdZV XZKnIjlaM53LacHAm9ClZC6+fb+OuQuluW1nDvgXGiQF1Y8bKsJ12ZQby2LN7Nms deGxjjsM9ytRc0KaTzc3wmxdLZhF+3sBxLjO90JvRHcwe8PwxyMANtCXIzziUevT EAsTQqGcfBcWsKOQVTVU =Qgce -----END PGP SIGNATURE-----