-----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: powerpc Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: powerpc Build Daemon (poulenc) 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: 1e062af6018fa23aac9ccb2d57de8bc2cdd605de 242770 libpq-dev_8.4.10-0squeeze1_powerpc.deb 6503418bb406f44cbce513f5b8e2afadff21be21 160932 libpq5_8.4.10-0squeeze1_powerpc.deb 788754bf268ac2e862c2da4fa37b0f82c4b199bf 97698 libecpg6_8.4.10-0squeeze1_powerpc.deb fe381aa6ef0fbac4bcac18e5ad8a2a2f32e3fe68 262444 libecpg-dev_8.4.10-0squeeze1_powerpc.deb 79ba2c0408fee4d96a07e71fb247aec15772c25a 33092 libecpg-compat3_8.4.10-0squeeze1_powerpc.deb 6dcef3c1d671db7ebeae6a8ac147e6e20b750271 60078 libpgtypes3_8.4.10-0squeeze1_powerpc.deb 86a184f2bcb0448fa80ea2ccbf896f41efec181f 5812780 postgresql-8.4_8.4.10-0squeeze1_powerpc.deb 60f8bf2a0fd1aac305177f0ddda22b6287df15ad 1533354 postgresql-client-8.4_8.4.10-0squeeze1_powerpc.deb ed8023b7a0e358cd275a07c452bb5e2bd86503a2 645770 postgresql-server-dev-8.4_8.4.10-0squeeze1_powerpc.deb b41dbf075ca99f0f3c0b878d8fe9219d2a86015e 418644 postgresql-contrib-8.4_8.4.10-0squeeze1_powerpc.deb b33600f0346d89b0a17de95565b8f61166ca7155 62420 postgresql-plperl-8.4_8.4.10-0squeeze1_powerpc.deb f515c1049f9db073de342cc5ab4e7ecdc5366acc 62588 postgresql-plpython-8.4_8.4.10-0squeeze1_powerpc.deb 0b0f51181401f0de92d7a270b3f7ee8aa65a16d5 48768 postgresql-pltcl-8.4_8.4.10-0squeeze1_powerpc.deb Checksums-Sha256: 14eb8c4ae7042917d99b2624abb2a3d36c9d2e850781a3a595ac9b28cdbd2e52 242770 libpq-dev_8.4.10-0squeeze1_powerpc.deb 9352f7ead9b47d09bab3858f4933b0b90154796d54be81a1f0e0269c9df9711c 160932 libpq5_8.4.10-0squeeze1_powerpc.deb 092844570951d283a0228b21bb8bbb6b50a11e487c172b25ad7ff7b9df273a5b 97698 libecpg6_8.4.10-0squeeze1_powerpc.deb 3172789a5f2dd5df173b74a287524fdc1f1d18a52abd9b84bf3df8ee7a98a5fd 262444 libecpg-dev_8.4.10-0squeeze1_powerpc.deb d56c8836311304ca651ae6f6b7176b1cd3235636222800bd0b891dfb439eff56 33092 libecpg-compat3_8.4.10-0squeeze1_powerpc.deb 0a66a32d6ed66f9ebcee6665b5f686ec07622cbafe07e40926a29490ba378dc3 60078 libpgtypes3_8.4.10-0squeeze1_powerpc.deb cc8540193d20790000596e5b854c9971bf5a9aa04ce2ae2ae581ccace82274de 5812780 postgresql-8.4_8.4.10-0squeeze1_powerpc.deb 149842ece3bf7dfa35ec3d646ca41543e2b30291932c61435edb5b9152ca96e4 1533354 postgresql-client-8.4_8.4.10-0squeeze1_powerpc.deb 42684861ee3740ab2848dcdecf3171bef714dae4c1b3c7b693505dbf941d78c1 645770 postgresql-server-dev-8.4_8.4.10-0squeeze1_powerpc.deb 0aa7d28280c5d3acfd6b5bc9d0d3df169c6d4117782cefbdeb518430cfdb99ac 418644 postgresql-contrib-8.4_8.4.10-0squeeze1_powerpc.deb 469d1d8dd33b0fedba7a9cc8a0b7cba0e3005f557a05f26fa21c169a5b703203 62420 postgresql-plperl-8.4_8.4.10-0squeeze1_powerpc.deb 13a33a83f53dc6ed0ddbcd3e44e3153803a02337d5c2d08c20bbfbdfbef6370b 62588 postgresql-plpython-8.4_8.4.10-0squeeze1_powerpc.deb 934abc85f5d8395b056e7bcd459c909b6dd517578ec007bf71393b58053d0f14 48768 postgresql-pltcl-8.4_8.4.10-0squeeze1_powerpc.deb Files: 73b980d4d9a81e444b07682da99a84a0 242770 libdevel optional libpq-dev_8.4.10-0squeeze1_powerpc.deb 1c62810b2aaef3138932f7ea4f36ce3b 160932 libs optional libpq5_8.4.10-0squeeze1_powerpc.deb 2de1c7a2053249b9dd8f14988deb3e10 97698 libs optional libecpg6_8.4.10-0squeeze1_powerpc.deb c5f46d9dcfaaf8f36a89309c4c2a012f 262444 libdevel optional libecpg-dev_8.4.10-0squeeze1_powerpc.deb b0e29cd5cba93a7bcb73765a8bf6858b 33092 libs optional libecpg-compat3_8.4.10-0squeeze1_powerpc.deb 3a96ac7e55ceeed4c548bd165484e2d6 60078 libs optional libpgtypes3_8.4.10-0squeeze1_powerpc.deb 364dbf1f195bc40ec344f17413e649bd 5812780 database optional postgresql-8.4_8.4.10-0squeeze1_powerpc.deb 8f216533c48323f8ae27c338ab85fe7a 1533354 database optional postgresql-client-8.4_8.4.10-0squeeze1_powerpc.deb 63a89e7fb33d47d23546cb07dabd4a42 645770 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_powerpc.deb 312d107b4bf5815bb1bf8fb9e83ab500 418644 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_powerpc.deb 2ac274c0558cbe243c4d7e9c4e001c5b 62420 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_powerpc.deb 32487e640aeba786a78e1df9fdd7812f 62588 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_powerpc.deb 7dbe377bbba08cb06b11b15f22f87d7f 48768 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_powerpc.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7LhEAAoJEAEba0y9vvHNIvUQAJH4PTSHKmXqSyO2R/T1j3o4 E+VFnYtH+QEesJIJENFl+Q8io5bkcxTzf5mZosVNaGxyepo7c78FnVd1qoOWiPoL JNv4+3sk3+pbWb07A12tMgHB3v0mSQ7flkx4/aoFEEpWIbuxEOSNXXX0xmPQzbsi gns4f7mFjBNCeqjGLOsyP9OHLcD3T967ckoDhDl//kidY8bj4UB2TuLsOF2vfsdZ d6YQ6bZAd7aNOeyIp47hehKL5gcZfqrwXjiMdJVZ6F4zsCPiTVKbholH2lU09ps8 lHb2qsE5JG5u3W5p1ACKIjFji6AzGFOV89CcYA9RICI1BawoIL7wZbaB2LLSiYfK IYEuZ8JTC3eSV2Yvy2cTOmOtTrI7jRuZKjl8732XYCLEGuEG2KVidRn+OKK0FVTu jTiAiG+szO55J/M/yisKWWnCEqb+K8+dcsterSe4tGQc4vck/tFtuddYQYUHuQCI fIFZ00wdoGpvFYIl9eb3tdSYFr2SyKrU+qL0mDDUmp6Ien9ZpBf3WivL6LUCILyD JZOXHuiGl2DLdtsUhMlJtIDaqh95zPqTqonbAqKTo8/0VKnOIWnBAkN9Nv7V/yK9 pC+rZ8fk/7B/VF9yTXmHGz9yIhIN8QwALoFN0/7c8yWsjoIYWh5SI05kDGszCH7j nN0td1DXWSoqr+z9F0p1 =ZF23 -----END PGP SIGNATURE-----