-----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: sparc Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: sparc Build Daemon (spontini) 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: 59078eaf2d40429418420de5c430efc8b3028964 233282 libpq-dev_8.4.10-0squeeze1_sparc.deb b07d89cd35a89a387e9f209fcc43c96e09b4a8d5 152050 libpq5_8.4.10-0squeeze1_sparc.deb 3e667ca02031fa43cf65351a8846811f4d73e4b3 95650 libecpg6_8.4.10-0squeeze1_sparc.deb 5be7c20fbe907e092111f853fdc1b00f81488ec9 254282 libecpg-dev_8.4.10-0squeeze1_sparc.deb 8894b5108ff509ea6d5ec1b3e1228071bb26a7e2 32130 libecpg-compat3_8.4.10-0squeeze1_sparc.deb c3931dbb52b73af53d11b25fb64bb9a3f74b9dfd 54582 libpgtypes3_8.4.10-0squeeze1_sparc.deb fa5fe16f486695c13580b8c99de70522658f9f0f 5627736 postgresql-8.4_8.4.10-0squeeze1_sparc.deb bafbe25dee4867f278c77089ec8dbdbadb21d51d 1507572 postgresql-client-8.4_8.4.10-0squeeze1_sparc.deb c0c50f4720923717c9eeb96e48f26771c73ba24a 644494 postgresql-server-dev-8.4_8.4.10-0squeeze1_sparc.deb 3bd4c7fec01806c2758e5a16e0cf4aa165acd783 399364 postgresql-contrib-8.4_8.4.10-0squeeze1_sparc.deb 4c22c081435b1c29fdca0f76291281c57078bb3b 59780 postgresql-plperl-8.4_8.4.10-0squeeze1_sparc.deb d2012aca920c9e182c03c8b07e1499a0ac7af337 60736 postgresql-plpython-8.4_8.4.10-0squeeze1_sparc.deb 56e968e495d34612ddcddb882bfcdc593354ffca 47260 postgresql-pltcl-8.4_8.4.10-0squeeze1_sparc.deb Checksums-Sha256: 20fdb03707f34a7deb38dae47ae8756a9e17cc60989f5be220551b16756dc3e3 233282 libpq-dev_8.4.10-0squeeze1_sparc.deb a76001f95e000bce31eb5a1bcb398d7af7317f959f1b794e36eca7f39b4f3ca4 152050 libpq5_8.4.10-0squeeze1_sparc.deb 97c6b7b2587edfc9779a870d59cdda6f9489aa8eb20002d8a6b4561847493cbf 95650 libecpg6_8.4.10-0squeeze1_sparc.deb 3235fb4c54339adc6dfe74b535e42fb7be3b999c370c81f86a8af68c6be857f5 254282 libecpg-dev_8.4.10-0squeeze1_sparc.deb ff627c5aef21e01ba4bbbeef3f8b22329f732414a8bffb76f7973785f501d642 32130 libecpg-compat3_8.4.10-0squeeze1_sparc.deb 72539f7126a6a55646ee8a27ede788e77b1406ba6e0188acfc5b25b3ed0e297f 54582 libpgtypes3_8.4.10-0squeeze1_sparc.deb bfc98ce42de91c5b046eda1c1790caaa992dd4ff8888f636b1f954dea9c3c38d 5627736 postgresql-8.4_8.4.10-0squeeze1_sparc.deb 787b4b0f33a6e8f3763cdcf64f8024019994bd6371674842067010c471b11f2c 1507572 postgresql-client-8.4_8.4.10-0squeeze1_sparc.deb 703b575b8a987fe35ddd070fdc6cf555f8f8dc93db0ddef0f526af97d9919d0c 644494 postgresql-server-dev-8.4_8.4.10-0squeeze1_sparc.deb 45a5ba9d97cf88b62bb81f0ac4729585f88d3ba10c6fb996a39db183c4dd85a0 399364 postgresql-contrib-8.4_8.4.10-0squeeze1_sparc.deb b315777b2950666eb9d5ae29d97abcf63b91ddf148cbc92696ceb3bfcf0181c2 59780 postgresql-plperl-8.4_8.4.10-0squeeze1_sparc.deb 21cf6c64c08bdd9c8a12762e74e605ed2119fbddf676de72565219ef9b48f0fd 60736 postgresql-plpython-8.4_8.4.10-0squeeze1_sparc.deb 277e943566710582e1799535be4db2f28ea372725bc46b2e14199e28b91e7fb1 47260 postgresql-pltcl-8.4_8.4.10-0squeeze1_sparc.deb Files: 9bb80a532fb938892de324a1e5fc8f52 233282 libdevel optional libpq-dev_8.4.10-0squeeze1_sparc.deb 66dc6921133a4fefffff25bd25868a89 152050 libs optional libpq5_8.4.10-0squeeze1_sparc.deb 9989f2d22ca43614eb73ba6fcfbf8577 95650 libs optional libecpg6_8.4.10-0squeeze1_sparc.deb 102a2d15592977d09288adf8d44f55f6 254282 libdevel optional libecpg-dev_8.4.10-0squeeze1_sparc.deb 6e7f60ec2c125b723dcfeaa5967e11c8 32130 libs optional libecpg-compat3_8.4.10-0squeeze1_sparc.deb be287c40595015e736842d02fb26d3ad 54582 libs optional libpgtypes3_8.4.10-0squeeze1_sparc.deb 7d6cd7696214e4366b6311b7621dc7bd 5627736 database optional postgresql-8.4_8.4.10-0squeeze1_sparc.deb 31c63905a49b8c61f3e4d51e43f629f5 1507572 database optional postgresql-client-8.4_8.4.10-0squeeze1_sparc.deb f0f744c7949a53871475d9e6c78b5222 644494 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_sparc.deb fb324d8310fe49b7e06ccde8cc703017 399364 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_sparc.deb 58e87aa27741b3c879d41d9959263bd4 59780 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_sparc.deb b4a390f858640f5f6def1cb4dd92d6f7 60736 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_sparc.deb d0cab40a8d1cedf838b57ae16b8fa62f 47260 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_sparc.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7MwVAAoJEErIoNUNTAQMUEsQAIEFQp5PCy6ERzwkAK7q5194 givB4gLeekJYgCWcbhiqsNbBpRTnhskPOqmIvB/m+Y+25rTGKIrvjP9/y5C/kMAz oHMjEdhwDpzDd3OQGwkBmfIqBz70KCQ5KfErs8OTi8H/eMVzvslpJxwpFaE1fZ// O5pCPHaMogK+ilXqEUnjvvfi5V3ZEtq/EaTydz8Ak/oeE6fdZ/R2nFa59/E65D0r uU0rO7xW7yM+1HdasTmzzVXlQBmtDy7ezo5pGRKY/d1qjOD9NVFsfOvF7waVHgD/ hqvlIPMZvZWvZnJ/CFM9RqfrYDqkLIf4DsXBwoL7lpyXEqx2c32Ep3iHt0EF82R/ iRGQ8mFi9wbYUpdLw198sw/O6J0Jww/EIR+uKqiLLlrgWGjJs/5qP1qCMe13303B muwxIbwFhhveL2w9LUXuWeyGqZ8BHYstrZLMxt/RtgeJlG7tCGhwcgMXgA+juxKt aQP/fjE+UvENmNTTB8WOZWDk9wWyQYs/gZ+LZBsjEzRvLB48Eik0JYsLZ7xZxGHc 2h2Sr9Orv0WCFErOblNihcYg+gfYGMk/envMHwa+uwCke+D+1qoLW4L3PrhZwi0m Z53D47MpXMMQOUcjMKt1W7ACGrX+CI0jrg65b8P5rwhqbiDhIrgzxrvps5lJANAy 8BmWKYpWkzqjSTKu9awM =MUAo -----END PGP SIGNATURE-----