-----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: s390 Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: s390/s390x Build Daemon (zandonai) 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: 76673ef5bcdec07015c82ca74c765e9a0c47e81f 244702 libpq-dev_8.4.10-0squeeze1_s390.deb ac8455bf241a5bfdc862599d7a22f793f06c3425 164856 libpq5_8.4.10-0squeeze1_s390.deb 684b45d34f29c0177f9cce0bd21deff049434004 97180 libecpg6_8.4.10-0squeeze1_s390.deb bca3621e95e8819620791fc8c9c85a145ec8b331 264490 libecpg-dev_8.4.10-0squeeze1_s390.deb 39d6d33974d38b3c78390a3bdda937764e7387ac 33544 libecpg-compat3_8.4.10-0squeeze1_s390.deb 9db6870b04718ce5112c45e712f3db91e493e126 59590 libpgtypes3_8.4.10-0squeeze1_s390.deb 759ccf5dc65d4d943d7239ccc381e19f29f8a898 5879056 postgresql-8.4_8.4.10-0squeeze1_s390.deb b5308edf618875550fab4502d10bf119c5447254 1537302 postgresql-client-8.4_8.4.10-0squeeze1_s390.deb c2f8abc339faa7dfbd4ffd853361efe3d48d3c96 643874 postgresql-server-dev-8.4_8.4.10-0squeeze1_s390.deb cca1eb22eabc94f243254e6fc98970f704f7a1f0 436048 postgresql-contrib-8.4_8.4.10-0squeeze1_s390.deb 7a92bbedcad09b2b53ab438a3349ff726a5bbbc9 60300 postgresql-plperl-8.4_8.4.10-0squeeze1_s390.deb c61d11c6c422539954942d4f8b3777772eb3ae24 63060 postgresql-plpython-8.4_8.4.10-0squeeze1_s390.deb 5f927e22939f93a5e14526f0ce25f20e20c9ba95 47830 postgresql-pltcl-8.4_8.4.10-0squeeze1_s390.deb Checksums-Sha256: 9ab2e7071dca13c0f074bd1c2e9eff62b7a4deca54befb11bc335cbce8a34599 244702 libpq-dev_8.4.10-0squeeze1_s390.deb b59ac359a8fcde2a4f0c19420aaa6b34e53a6c78aad2938ccaa33f747d713f35 164856 libpq5_8.4.10-0squeeze1_s390.deb 4176fbaa621ca4d589aaefaaaa0889af538642082fcd81994b3b620541d7674e 97180 libecpg6_8.4.10-0squeeze1_s390.deb b5c5f1dccb8e0491f43f219e224830f24443a688ed658a778ecd7c4c41fa6cb9 264490 libecpg-dev_8.4.10-0squeeze1_s390.deb c2a7acb5b3ee4de71cfe7b972b68f1c2f1dba8aa530cc75b65674b585d10264b 33544 libecpg-compat3_8.4.10-0squeeze1_s390.deb 93287d448aa3f63a7902e512d92d064c369cac66c5d6a61a335190c5e6c7cd7f 59590 libpgtypes3_8.4.10-0squeeze1_s390.deb ccb6afc0acd943b2f4faef30dd93800abddb48890c34091747ffa895a87bc74c 5879056 postgresql-8.4_8.4.10-0squeeze1_s390.deb 9fe105fcdb297b42da194b51b4109d567edfe45cd3a56c61f70b0c8db19dad02 1537302 postgresql-client-8.4_8.4.10-0squeeze1_s390.deb 45a2fe95d2570ae5f1e3cd4c10fc4e1ab9496d8308224513a4b1787dc5b82953 643874 postgresql-server-dev-8.4_8.4.10-0squeeze1_s390.deb b6478efe9b6fe27aa22c8554dfdbcb3f4222cfb1ee2b17ace2a17bb724704091 436048 postgresql-contrib-8.4_8.4.10-0squeeze1_s390.deb 5114ec758c30e851ff1260b0f2d723281b5bab8d1f53a2dc62b069aeec3e738c 60300 postgresql-plperl-8.4_8.4.10-0squeeze1_s390.deb 615a8cdc401bf539fd850d72fdb209df3e7b9c5a779fd0a4ec7e42c641497ab5 63060 postgresql-plpython-8.4_8.4.10-0squeeze1_s390.deb 80495ec649861d9aca2f800df9f983658e8e52dafe73d8a7fd8ed84cc828eedf 47830 postgresql-pltcl-8.4_8.4.10-0squeeze1_s390.deb Files: 2669f2056af8fdbb7fbd919462bdec7e 244702 libdevel optional libpq-dev_8.4.10-0squeeze1_s390.deb d71ec562ab0c3799e0889378ad69bc60 164856 libs optional libpq5_8.4.10-0squeeze1_s390.deb ba30e1c2f4c38c64f0391503341a7f51 97180 libs optional libecpg6_8.4.10-0squeeze1_s390.deb 3d48a6f0e9a55c29476bece46eebb5be 264490 libdevel optional libecpg-dev_8.4.10-0squeeze1_s390.deb 9c582b68dba84ba37949727c55a46379 33544 libs optional libecpg-compat3_8.4.10-0squeeze1_s390.deb 48403b7e4711f24877d86cb9619b1dd9 59590 libs optional libpgtypes3_8.4.10-0squeeze1_s390.deb 3a67b4fe47712860708a930b9c996db5 5879056 database optional postgresql-8.4_8.4.10-0squeeze1_s390.deb ac9c984db6ab464bbe7ae4fdf1f16435 1537302 database optional postgresql-client-8.4_8.4.10-0squeeze1_s390.deb 5e84f375722b24601cb5cc20c08de278 643874 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_s390.deb 6516865916e6c74d3f9e341fdf539aac 436048 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_s390.deb 836a62c0847e8fa4434da159811406b2 60300 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_s390.deb e0e4c1197dbb4aca956e0ac43e91a69e 63060 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_s390.deb ccebebc2de560abf6e89ab5d50fa04a1 47830 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_s390.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7LT+AAoJELWkVFx3JxH3DyoP/0xT911d74+pBAAichPahG13 1VQC0a751MjDQtldzbVNmTnuvXfC4+yTKsd+9WcQ6oAmFHMYssSteu30dTaNVZkw 94C2b1Slhb+WJX8KWp8EN0neZAtP3tJL2hZDqcmMr0bEpJ4CoUdwv382A/q13Wqr W52cnr1doGPBzfqbHkTwHowcxMNQ3uVJ+s1tA/O//PWpz8f6uJeOBOkcB42dF+P/ dkWaFjRwI2m2Q7YJ+bHfFbNyxLVJdtHwxBUUOCesEMA+5LSKZwF6A3EqkyxQHT6d IHRKVlk9hjuebU7o3u5ot/8qhMygOsNCjgsXqm3mcOVQshXueR920ZqyHaWRNIwj Nszhy1o2WAyBFBotBM+8xadBlaCGa4zWIoYNoYGWLc89kPxpAS4JRTzcdU9OGqEr dFiQlgXP/w+y8FnicYy8y9cui2JfItLTStfJH05jMBpTymD8/wbssEG+0UZLjIRR Kd3D4bhAgHUPxgF2NyNKTEbzc88cD/spyKSTDpsNfBHx3awtW3jqsqFnTXvRrxtN 16NPwG+IXem32vNdCljs4GOnx0xLdZscH4EBYusyun1HK23zDyPDz3EXQX3LHscK lMVJ6MeX/09nIMIulZE6nzbVasIk7D6BFD8rjRoT19wh888f2xIsp/iPbMhDsFLo k+Rs+cJLh0vo3IUsE63P =1t9z -----END PGP SIGNATURE-----