-----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: i386 Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: i386 Build Daemon (murphy) 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: ab727f000faeb8c7831427fa165b64377783698e 233436 libpq-dev_8.4.10-0squeeze1_i386.deb 07886062ef239dacfc1ccca53b7e210fa6e77f21 156132 libpq5_8.4.10-0squeeze1_i386.deb deb11c3a8cdca99dc43b3f5b24877673b089cff7 96240 libecpg6_8.4.10-0squeeze1_i386.deb 1184580d18b3cae447e0f5320434e270ba73c7c7 248364 libecpg-dev_8.4.10-0squeeze1_i386.deb 42c0e5e7d92112a7792393e084181a6282b21012 32734 libecpg-compat3_8.4.10-0squeeze1_i386.deb 14942b76a919bb91a5e27b77fc6a41f9038fa723 56304 libpgtypes3_8.4.10-0squeeze1_i386.deb dbc65349df40931b68198fe70d4678b3912eaf29 5353382 postgresql-8.4_8.4.10-0squeeze1_i386.deb bb31b4b567875ded25b20a7a89e5afb1127fbf4f 1487966 postgresql-client-8.4_8.4.10-0squeeze1_i386.deb 3144c48c989838060ff74b876a2f364b15ff7d80 641638 postgresql-server-dev-8.4_8.4.10-0squeeze1_i386.deb 2c6b5dd9db0562d2f0410715e4b7a6e723f0326b 393598 postgresql-contrib-8.4_8.4.10-0squeeze1_i386.deb 7c9cbda405521fde6e352948fcc274606c14995d 61212 postgresql-plperl-8.4_8.4.10-0squeeze1_i386.deb 13530fc925dbe58d6467ebaa9a76013938af4d01 61048 postgresql-plpython-8.4_8.4.10-0squeeze1_i386.deb cd9fa10e61849f5cf4fa328af1356a2fefe45ae5 47336 postgresql-pltcl-8.4_8.4.10-0squeeze1_i386.deb Checksums-Sha256: 0c69db2db9f5c7484bd4cef9c6acedacf80cd9586ac24f42964f89626be7c80d 233436 libpq-dev_8.4.10-0squeeze1_i386.deb 763cca22ff5e60f156fb4fde5fd7c3703d1284ed2b2e4038580c1d37e8fc744c 156132 libpq5_8.4.10-0squeeze1_i386.deb f1f92c412829ca3e449128193894e865096214e37183a0ba0bc36ef3ecac5c26 96240 libecpg6_8.4.10-0squeeze1_i386.deb ecfda12cbd86b28f3bda0f5118e023274564adc0b3fc21bce6b435b7bdb29e60 248364 libecpg-dev_8.4.10-0squeeze1_i386.deb 758440894844cf492254e7b782f105ebaac1c0939ed2a2840f926de7c6ad46a6 32734 libecpg-compat3_8.4.10-0squeeze1_i386.deb 8626c5ba953e54674aad8532c5347c33dc7e4fd35d862505d089311e7515dda9 56304 libpgtypes3_8.4.10-0squeeze1_i386.deb 3b78b1b7a80ccccb2b10212a8b80de0c789de1082f2dc62f6f0bc8db21c9931c 5353382 postgresql-8.4_8.4.10-0squeeze1_i386.deb 594d67f3abc12f2c5249e43576c501011e26c3c4ce28ec203bbdb921be10d662 1487966 postgresql-client-8.4_8.4.10-0squeeze1_i386.deb e1cfe82bc5f67e6dcb2d34915bd83bb8e1c32a687cc3df0ea1d9af18a088dac3 641638 postgresql-server-dev-8.4_8.4.10-0squeeze1_i386.deb 6fce7d5d0ec0f874e1b67dc238694b7dc345dc1f4e23acb5b71e53bf730dd331 393598 postgresql-contrib-8.4_8.4.10-0squeeze1_i386.deb e2ef7fbb7d030f66164e428781f4604bfa8f7a1cc6030655c4695f7e8e4d6952 61212 postgresql-plperl-8.4_8.4.10-0squeeze1_i386.deb 6549441171568500a9a7170e30d9708c495b276ac17e64278607e03d82428c3e 61048 postgresql-plpython-8.4_8.4.10-0squeeze1_i386.deb 042fdc1ab7cd6239d98bb98be818d4b7c452cd942e3d72b18494e2622065e18c 47336 postgresql-pltcl-8.4_8.4.10-0squeeze1_i386.deb Files: 4a6c96518312c1f4ae47ae89ab90eab2 233436 libdevel optional libpq-dev_8.4.10-0squeeze1_i386.deb 51470d4d1a7034d53ce99c7fddf8a3db 156132 libs optional libpq5_8.4.10-0squeeze1_i386.deb 79776ef4fe83c4c9cf7ef2dd8044747c 96240 libs optional libecpg6_8.4.10-0squeeze1_i386.deb dfd5c6d6ba2149bc36b52154a6c84e9f 248364 libdevel optional libecpg-dev_8.4.10-0squeeze1_i386.deb e275ffe603c2d02220977d99cb1fccea 32734 libs optional libecpg-compat3_8.4.10-0squeeze1_i386.deb 2d875bb1925b2234f7a0cef6a12261ca 56304 libs optional libpgtypes3_8.4.10-0squeeze1_i386.deb 4e7a19d967f8568fbb8c2a055d7ea0b9 5353382 database optional postgresql-8.4_8.4.10-0squeeze1_i386.deb 7cd1347336c76e0db18d0865ed1d32eb 1487966 database optional postgresql-client-8.4_8.4.10-0squeeze1_i386.deb 6f1d8838b2785f9c22c8ea2f4611b4a4 641638 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_i386.deb 578250a310e17e9886469a2a0545ec6f 393598 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_i386.deb 6bfdeb11b8ca0f99dd314689871acff1 61212 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_i386.deb 18368c43c18cb3dbe7218d484823684c 61048 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_i386.deb 90d1ebb85aaf08f3262a87d15585401b 47336 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7Lb5AAoJEDNF0n2wdNbJnu8P/Rl9HUFWb4mFM8SJA9piZXjN 626rrzIJHJKWU5oXbM5eq+07/W9Z4USTm+EJUdcPTZBUcMTY1xkG0zBcDqwEQYoj 3lg8jpAcLIpRVdbZamoSSyZH5XygdYpr/II3DHEkJRsNXe34nu7eCiWvGMNHMC67 jBXJwvALM8qyI7CllS+Hlq/ki/aoEdDpq9slBYbC5XVUB7kuMPwaq9Ze2Bklspm8 BzWhHryYv2/9amvBi4LeZus+fRBepOmtapuy6Rv9mtjvqNYrSYL8QOf0Q7k9wn82 CL8bnPR7+ID32KtIu10dq0G2kk2zl7hmGmZmA7D28animXe/HFVCY1zLA00YmmWW l4whL6C1j7kcDI/H8ntsuXt5/nSnzdtqVCDHq9zXDxJ6vZ92PRSD9JVZn2WYWpcQ SkzgEV4layHOu/JpCsD5aYHdLIj5olALyk3Lr1KvKHYNvP4QY3DC9aSK/Axv2UmQ EkWR03SPUSQNHfnif8rpNcg5zBIP52oqlaspEbzQlsUpGKe4ZDXlBDKAmh4RJdzR AHHL9T6uxXqjPkg/wlp2BtWKot6a3StE8PvXKjx+jQLRvNUfsDj0TMa/LQL4sG9B qGde6KazJLKZebArHMy0fl5g3Y/xUFQEl/aVSerx1Ee4FiBOJpg5Yn7O94c3pfy8 oC0Ea2k47Ha7eA3FNSyP =iVv0 -----END PGP SIGNATURE-----