-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Sat, 03 Dec 2011 17:18:08 +0100 Source: postgresql-8.3 Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-8.3 postgresql-client-8.3 postgresql-server-dev-8.3 postgresql-doc-8.3 postgresql-contrib-8.3 postgresql-plperl-8.3 postgresql-plpython-8.3 postgresql-pltcl-8.3 postgresql postgresql-client postgresql-doc postgresql-contrib Architecture: powerpc Version: 8.3.17-0lenny1 Distribution: lenny Urgency: low Maintainer: powerpc Build Daemon (praetorius) 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.3 libpq-dev - header files for libpq5 (PostgreSQL library) libpq5 - PostgreSQL C client library postgresql - object-relational SQL database (supported version) postgresql-8.3 - object-relational SQL database, version 8.3 server postgresql-client - front-end programs for PostgreSQL (supported version) postgresql-client-8.3 - front-end programs for PostgreSQL 8.3 postgresql-contrib - additional facilities for PostgreSQL (supported version) postgresql-contrib-8.3 - additional facilities for PostgreSQL postgresql-doc - documentation for the PostgreSQL database management system postgresql-doc-8.3 - documentation for the PostgreSQL database management system postgresql-plperl-8.3 - PL/Perl procedural language for PostgreSQL 8.3 postgresql-plpython-8.3 - PL/Python procedural language for PostgreSQL 8.3 postgresql-pltcl-8.3 - PL/Tcl procedural language for PostgreSQL 8.3 postgresql-server-dev-8.3 - development files for PostgreSQL 8.3 server-side programming Changes: postgresql-8.3 (8.3.17-0lenny1) oldstable; 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 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. The typical symptom was transient errors like "missing chunk number 0 for toast value NNNNN in pg_toast_2619", where the cited toast table would always belong to a system catalog. - 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. - Change foreign-key trigger creation order to better support self-referential foreign keys. - 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: c6dead0e7855de8003169fc963ecb1934e62f30c 497742 libpq-dev_8.3.17-0lenny1_powerpc.deb b602f906c85174732d8a98af3b2dab853692790a 432120 libpq5_8.3.17-0lenny1_powerpc.deb a4d9c85cb5b98ef4cb7fbe96a99223eab6e53b02 323700 libecpg6_8.3.17-0lenny1_powerpc.deb 4a39b73aa1f76244e3b2ed6f78d6643f7d99d9ab 507398 libecpg-dev_8.3.17-0lenny1_powerpc.deb 14051cd55d6922c32b9170acd838b3460cede590 301284 libecpg-compat3_8.3.17-0lenny1_powerpc.deb 53d7b1f4d339e1fbdf27ea06faab2354b48e0573 325556 libpgtypes3_8.3.17-0lenny1_powerpc.deb cf426f678669bfd30d90a22cf598e7d962120abc 5813048 postgresql-8.3_8.3.17-0lenny1_powerpc.deb 30e96b615553eb2ac7eed96c3b56aa83d45af6e2 1776256 postgresql-client-8.3_8.3.17-0lenny1_powerpc.deb 626c459cf29bc8398e0ea4ed7cb5b9df4db9c643 869450 postgresql-server-dev-8.3_8.3.17-0lenny1_powerpc.deb 2557ea0c064dd0d0c751ec9475ed6c2203ccac39 705536 postgresql-contrib-8.3_8.3.17-0lenny1_powerpc.deb 7e0f7d301495097fef6a84b58a1b3a57178eb051 323982 postgresql-plperl-8.3_8.3.17-0lenny1_powerpc.deb 9818d4b2fe3614bef92afd641cbbccf2f624403a 316190 postgresql-plpython-8.3_8.3.17-0lenny1_powerpc.deb 85e4530daabd75f7c149304f3a651bf6395e90a3 314624 postgresql-pltcl-8.3_8.3.17-0lenny1_powerpc.deb Checksums-Sha256: 14a685882160e88ec109788c120d7bb118ba44f25701eae4229dac10c78bf715 497742 libpq-dev_8.3.17-0lenny1_powerpc.deb 4a7567772df655be447d873887a69c7f756e927d34ab63e76dc2f2abed84fe4c 432120 libpq5_8.3.17-0lenny1_powerpc.deb 77e0935c0d99c31ded2a95b3c0c2c4c27135f2e4da97ea236d23607cd23aeba6 323700 libecpg6_8.3.17-0lenny1_powerpc.deb b4e0187e54689d04c7d6b313cf37bdbdd71fc5d6c16f7fdbc26e78bd2e16da25 507398 libecpg-dev_8.3.17-0lenny1_powerpc.deb f6e9468c6093531018b0d2e4a13d5b0ab94fb587a76f5561c46dee0f0ce6cea7 301284 libecpg-compat3_8.3.17-0lenny1_powerpc.deb e56a52086a3770fe6741c8e0e92d35061517306548fde41a0d26a2509d8e3e4b 325556 libpgtypes3_8.3.17-0lenny1_powerpc.deb 2a58c19ccde2eebe1f18078929787a2947057054dd086af75cf02537e469a242 5813048 postgresql-8.3_8.3.17-0lenny1_powerpc.deb 81647313a120283ad20bcc06c333ea47946aeead4cc9d454ecbad1fbae7b39f2 1776256 postgresql-client-8.3_8.3.17-0lenny1_powerpc.deb dca524b7966c1eb966c201c2910fe8c1f00f782d7f7feb37a1ea437469f4348b 869450 postgresql-server-dev-8.3_8.3.17-0lenny1_powerpc.deb a54dfa8dadfe3ce45055fbc5a97c701461f945e8d430878188ce941c15451695 705536 postgresql-contrib-8.3_8.3.17-0lenny1_powerpc.deb c05db9f0f82c4b4a940d433870c3c1fcacaedfb375892479fdf37aed2c2f80cb 323982 postgresql-plperl-8.3_8.3.17-0lenny1_powerpc.deb 21e6dee4946963eedc7b00f67898da0593553c9569e8ff89e9d5232a42df6939 316190 postgresql-plpython-8.3_8.3.17-0lenny1_powerpc.deb 305af1b8faab54456f4c9c02a71b22bae4f6e4f5d7bf2a1df0a0b009d9c5c221 314624 postgresql-pltcl-8.3_8.3.17-0lenny1_powerpc.deb Files: 79638cd3c789f2627db855804a2ec89f 497742 libdevel optional libpq-dev_8.3.17-0lenny1_powerpc.deb 4eb1656f18eba4a4fb85af355768cf3d 432120 libs optional libpq5_8.3.17-0lenny1_powerpc.deb 2fc7ca0ad8b8f5b5d25e258af7c16e49 323700 libs optional libecpg6_8.3.17-0lenny1_powerpc.deb ff5573e4010a4bf32f279b379fa98a06 507398 libdevel optional libecpg-dev_8.3.17-0lenny1_powerpc.deb da6b8ed0e61f8fb1c382829c882e0b62 301284 libs optional libecpg-compat3_8.3.17-0lenny1_powerpc.deb 2c7442a43160c8f641553b04cdd6f487 325556 libs optional libpgtypes3_8.3.17-0lenny1_powerpc.deb af87ce9533a1441a4681c967d784a2a8 5813048 misc optional postgresql-8.3_8.3.17-0lenny1_powerpc.deb e7874b8ce78653e55ff17e6fb4aa9c5c 1776256 misc optional postgresql-client-8.3_8.3.17-0lenny1_powerpc.deb e7e52614455c298ab82d4d732852f206 869450 libdevel optional postgresql-server-dev-8.3_8.3.17-0lenny1_powerpc.deb 53ef766d22075c60499e31efcd45cffa 705536 misc optional postgresql-contrib-8.3_8.3.17-0lenny1_powerpc.deb e788f53d406700bbf433ceb35946cdc9 323982 misc optional postgresql-plperl-8.3_8.3.17-0lenny1_powerpc.deb 4f704e084696b9d6719c0d001a44d32c 316190 misc optional postgresql-plpython-8.3_8.3.17-0lenny1_powerpc.deb ae8449a76243873e60d0f407aee7ac07 314624 misc optional postgresql-pltcl-8.3_8.3.17-0lenny1_powerpc.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBAgAGBQJO7aAiAAoJEMKUD5Ub3wqdq6EP/2qMy/01IbD4Rpolp8NBTBr4 ptcOH2yDy1g2o4DhbgaWCB3mMd7R+6fO+X1QQPnX5fR333muBk9EMeRea0pirOoA dgSsMb1kTBg6BUq9EGi357rlH1Fv9QSg1+/ZzPBzIcKSLcVWYbtD6M7ALe4/60uD k3Vd16A6ugaoMk0hNJ2tSo01lpBObDs0t1q+Zyjszo9aSsxlBFAXdlXWwFq1bjOO DOFu90vc2EC0tg6N5LTullKDoLN+HIZsDIZYErVBn212A2HXP9PhfpZ4usd42Q2s vwkquW/JliGEdon1vQGbK3THOVHNV+uanOoutG842z6NcBpzFP5evvVESNRtrwRT 08IQk7hPVORkXEuA/xpH1S39MM3ITYBdlcGhdKaOK18xn7e3Us+yeInSnJ6HP0wT 2+Jx/QKL3UnVW6En+bJIdCVyqKEcDQSXIBQ6AdD5wIk3+iThf+IkSPDAfFoKpwQQ EAG0ZumPNDYTg0uFXdudhyfROZ610nDEpkEnElEpXpwQwb5fwLXRLD+wyvWb2M/V 8kyzK2w9xh4u2UkHmmooixnylpJkXr2kosARf0QyveI+SyVB3tHZgyUVRyiixeVl t8kwyXNF1dhTOLZG4f5EBAFRcjN6Zn+45MDskJUZ1LpU7AqDxT4yWDER92Ri8Jma 6YJbZXgac9TEbucRkUjp =vCAb -----END PGP SIGNATURE-----