-----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: armel Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: armel Build Daemon (alwyn) 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: f0fcd515027c1ec95f052798ff452fe1d0e3b9d3 231796 libpq-dev_8.4.10-0squeeze1_armel.deb a1d9a8a6b10a8361fccdd3f3c15563fd23332e93 153186 libpq5_8.4.10-0squeeze1_armel.deb 994a8da37ab6931b17de09a5da0b07320a1d2aba 97474 libecpg6_8.4.10-0squeeze1_armel.deb 4577df9a9a0cb6b9105d63abde386598e7d4bf2c 250176 libecpg-dev_8.4.10-0squeeze1_armel.deb 8f959618173ef55c2be04731118d82b6bab33758 32366 libecpg-compat3_8.4.10-0squeeze1_armel.deb 5bf4b7142c466ded55cdfb945cf6518aaa201910 57396 libpgtypes3_8.4.10-0squeeze1_armel.deb 45588c960ce74c160a5ebef39cceb47133da5b8c 5373440 postgresql-8.4_8.4.10-0squeeze1_armel.deb befd97ca06dd6ae432eaeff9173d1aed0ec59e28 1484056 postgresql-client-8.4_8.4.10-0squeeze1_armel.deb 5be3b990cb5bc3a02eafb73f051269d1b3217520 638272 postgresql-server-dev-8.4_8.4.10-0squeeze1_armel.deb 2cad355553dd5eeef81a2446512ed49acbff435e 415176 postgresql-contrib-8.4_8.4.10-0squeeze1_armel.deb ff7fe951bea408e3184946ca4d2a495dbecc06d2 61216 postgresql-plperl-8.4_8.4.10-0squeeze1_armel.deb e5fc75d713cc9b7b426e99b9865e65832c4bdf1d 62538 postgresql-plpython-8.4_8.4.10-0squeeze1_armel.deb 248c2465dc73d5586643d30bec6409e01ab98e2d 47440 postgresql-pltcl-8.4_8.4.10-0squeeze1_armel.deb Checksums-Sha256: 2b3993abf61922a45d35fee4f7496ab992ef1bc4252d3b909071d4ffbee31989 231796 libpq-dev_8.4.10-0squeeze1_armel.deb 0eadc5fc0dc12d42c030bea13335848f7460f2c6caa1398a8ae33a796608b260 153186 libpq5_8.4.10-0squeeze1_armel.deb 63148ea75f8925df14bcdce3a05819b721119053d49deac5db243b72c54d92ea 97474 libecpg6_8.4.10-0squeeze1_armel.deb 049d6dd6710f8a8f456f02c5c6ae8486f61f966a25ab621e55e6a8fe61003f77 250176 libecpg-dev_8.4.10-0squeeze1_armel.deb 3533de5365c590f9e17da8e02410265d27671ea3b970ee8d7aacfb9475ec7939 32366 libecpg-compat3_8.4.10-0squeeze1_armel.deb 02134354a9ccc7cedbf7cde7d97097aa471dd5abcce2ed616368677e30c2fbcd 57396 libpgtypes3_8.4.10-0squeeze1_armel.deb 6dfb616c72aafa5f3227b069cb774cf2d0b9ef2afb47389dada4602c0fa4484e 5373440 postgresql-8.4_8.4.10-0squeeze1_armel.deb 27e7d4ed9433df9784b42bff7da1140f85704deaa60305f0fb9cca50e9a113a5 1484056 postgresql-client-8.4_8.4.10-0squeeze1_armel.deb 78f22200791eb559cc4d593ffeccc882f44c2367dcca979524e6e25c350f2577 638272 postgresql-server-dev-8.4_8.4.10-0squeeze1_armel.deb c11f2470d6ee6730c59d798f08296a375519e79bb901eb4c2a5d62aa3397b18d 415176 postgresql-contrib-8.4_8.4.10-0squeeze1_armel.deb 3c84b53d14fd335cf9c8eb924db3ba8954fe316f6be2051f28a8211da7815e7c 61216 postgresql-plperl-8.4_8.4.10-0squeeze1_armel.deb e85248578f1559ce45411679d436fed7e7aac7f42361ec21a39a4c0d7f5af1aa 62538 postgresql-plpython-8.4_8.4.10-0squeeze1_armel.deb 0a4d2ca71074f6820834ae87b3bb1d447255a72ec8b6ff2f0049b825a9eae70c 47440 postgresql-pltcl-8.4_8.4.10-0squeeze1_armel.deb Files: fb508f28ae564bd579c7428367b80967 231796 libdevel optional libpq-dev_8.4.10-0squeeze1_armel.deb ab79ffba492af77cf8df8a6c3ffb5df6 153186 libs optional libpq5_8.4.10-0squeeze1_armel.deb 7fb14676cb42bcaa9bebc28f3d2d287d 97474 libs optional libecpg6_8.4.10-0squeeze1_armel.deb 2aab7251fcc83e866fbc22e8227f80c8 250176 libdevel optional libecpg-dev_8.4.10-0squeeze1_armel.deb 6a3f5e87da152ac0f98c6d98ce73629d 32366 libs optional libecpg-compat3_8.4.10-0squeeze1_armel.deb 1f5a1b8b83c19545d11d86316882274b 57396 libs optional libpgtypes3_8.4.10-0squeeze1_armel.deb bddff4f622c7ddf930fe1dffb8411f33 5373440 database optional postgresql-8.4_8.4.10-0squeeze1_armel.deb 28d20ecc3854950116e500d8b2b8a213 1484056 database optional postgresql-client-8.4_8.4.10-0squeeze1_armel.deb 8b5cb66a9969de46719ae9156d2ee5d5 638272 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_armel.deb 739fbf41ec55b7d7b03ad1f467b692ef 415176 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_armel.deb 9a8839ca9572bd497f4d3b00698f4e69 61216 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_armel.deb 3f0b66b789cd283c5101c25aca21f311 62538 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_armel.deb ba4dc7aa4015040e970894da38ee6782 47440 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_armel.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7MxWAAoJEBRVXZHoMsNVD38P/ixrqWxWT6L82aq1/YQSxTow +zMzljvlez9E3yjLW2lpfJfKfJl2t/kUnG4BwvaGlyVKlnT2r+1G50+Jy71Ryxwj oEIh09tn9d1hg+w8WZsYNeWyymRxK8fkFSVsOtLhmOZPBU1sOHc2Vz5/VS3t00Zt 3emUmLnSGXy5pu+Qijgb7OkWK0f1JE+OzRxobb06Ihlpbnivw/gfRhhYsTSLqvKa Xqp5TSoCyQ0+nbs6PPTbvdTcWgAZjZ+CPmfV2H6+M36CkC4AKXUfucyhyA2Fih3B qIROm1dC7QRMBGM01AlbAaGrKdfoHmmjmCUKky3sHWAeEWT8b0UZx/u2/w4z9Nfj nBjkqzCVhd05jO0y39RlAbIqUHN/VzaKOBk6m+rOkgYrUkRKXIkVzIBP+tN69OoZ wc7dl52g+G5meO3ozz6Cjz83cc8IcYudpe8ZjAS8GNsaEUTS5J37AI1ZiB+4TQeP vdvtUL6UwoRRLke6N1pwkjCDL0n+QxdqXBqpMy371VUGn/014exSS5214OayjHg8 i1FA6y9H/x94uj0rrmI3tkMwwBsQvA5g6vWgzj9EzB2s/HEYyav8nCDiLscqUfXO Ns6WO62yGKVFcuNRFuZVrePIf1ztLflpP/XwEZvGRCo4+3t0Kf5jdLK5NERMyhwS 3NaT2iDnK2+3542w6jiw =ucIG -----END PGP SIGNATURE-----