-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 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: source all amd64 Version: 8.3.17-0lenny1 Distribution: oldstable Urgency: low Maintainer: Martin Pitt 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: 741cf3f776e097a9a53f2d064e18c650e6cb4944 2312 postgresql-8.3_8.3.17-0lenny1.dsc 0be03e2931f6bb039d766852f15b954eeabd8012 14215528 postgresql-8.3_8.3.17.orig.tar.gz 2eea7e716055ce5e110e97da0746c714b6247014 55376 postgresql-8.3_8.3.17-0lenny1.diff.gz e60c65313d12fefd51f4df3c77d4b5d581e689e2 2256858 postgresql-doc-8.3_8.3.17-0lenny1_all.deb 0474dd39513ecfbdce402a5424cf9340d2ae4019 293606 postgresql_8.3.17-0lenny1_all.deb e54ad5952cf9fee5d97d5708ffc0b4b85317a9d5 293590 postgresql-client_8.3.17-0lenny1_all.deb 1c5fdcb1952e29aa21bf3e3d90133e72e90b0e09 293420 postgresql-doc_8.3.17-0lenny1_all.deb ce3421b76930ad37a05f78ce7d7b157680061e73 293490 postgresql-contrib_8.3.17-0lenny1_all.deb c0eddb40f9e61c254e9582040c72de719cda82f2 500824 libpq-dev_8.3.17-0lenny1_amd64.deb ade0028793e9ff0ef6fcbe7abff8f165493d2d2e 432264 libpq5_8.3.17-0lenny1_amd64.deb 3d74dab08b43c73a5fe3285099697d0a0dac44c1 322868 libecpg6_8.3.17-0lenny1_amd64.deb ff86e11b7dae0f9177f64095051ae3ce82266765 513092 libecpg-dev_8.3.17-0lenny1_amd64.deb 19752b92806ccc84e6bda2aaf0bef19727b8e70f 301592 libecpg-compat3_8.3.17-0lenny1_amd64.deb 237417bcf3329bd6958a64877b87eef56fd01cb1 323090 libpgtypes3_8.3.17-0lenny1_amd64.deb 365e1116b9d4435237872f26e3e0f302f3ae48d7 5461896 postgresql-8.3_8.3.17-0lenny1_amd64.deb f36eadafc5b03208dd3c2c2ad5d1cbef8244f076 1746808 postgresql-client-8.3_8.3.17-0lenny1_amd64.deb 241ae41cd4a29315ef17fd3efee05f176ace6a15 865876 postgresql-server-dev-8.3_8.3.17-0lenny1_amd64.deb 7e001ce4575d146e1961de99a62f72ddf1589e46 657846 postgresql-contrib-8.3_8.3.17-0lenny1_amd64.deb 77476ecb196704716b0d0192e5ce9f771a44c611 323100 postgresql-plperl-8.3_8.3.17-0lenny1_amd64.deb 9c5cc9e659f66b1eba2f260c620f855adcd56f90 315502 postgresql-plpython-8.3_8.3.17-0lenny1_amd64.deb f2c3009952b42fb38b7e47d830d8a713ed2d8aea 313208 postgresql-pltcl-8.3_8.3.17-0lenny1_amd64.deb Checksums-Sha256: 54246ca0a98112519e23fb3aec871cb24877ec48ad4136da85b42ab623c0f992 2312 postgresql-8.3_8.3.17-0lenny1.dsc e33032fec24875021c9b715c8e2a6085649e7fe16daa9645f28b69a1de1f41dc 14215528 postgresql-8.3_8.3.17.orig.tar.gz 84e0daf6322ca376105e4ca235bbb01e544c5a1afb747d4712b6a0abce8e8dd1 55376 postgresql-8.3_8.3.17-0lenny1.diff.gz 86e0d25b3fd0d678ec01c378d5c4d50d81a29d8bf1a0c136ae629e29c2afd62b 2256858 postgresql-doc-8.3_8.3.17-0lenny1_all.deb 60183bcbe2938683b30b54a0f0fad8e56554d7f68ab6e3fd869101fede391dcd 293606 postgresql_8.3.17-0lenny1_all.deb e493214048478b0d39f60519af30a3c325ab794e9d00dacdb6356934efd0c1ce 293590 postgresql-client_8.3.17-0lenny1_all.deb 665abeca9cac0b88767fadef2e4049c72812daab22a36d135b1c4a8b5df2e2eb 293420 postgresql-doc_8.3.17-0lenny1_all.deb 4d459bc25e8e07a28dcb209199fc40186a205b1986c01cf8341b8b61e4426609 293490 postgresql-contrib_8.3.17-0lenny1_all.deb f4b590819ea7aa348c087883e8a464a3e38eeec630deb0fb6ab1913a2c7ac939 500824 libpq-dev_8.3.17-0lenny1_amd64.deb 4aaf9186d9490caba9542a2d5cd3e651d7752ea9fff01223eda497ec12dc4999 432264 libpq5_8.3.17-0lenny1_amd64.deb 9ee49f8790ff82b71a71773b9ea7728ea7e3d86de75b902a3e90da59f196fa27 322868 libecpg6_8.3.17-0lenny1_amd64.deb b7baffec61d8af0f4b03bbd71f97c9d5755f49293b1d1833836bb1c3b0837bf1 513092 libecpg-dev_8.3.17-0lenny1_amd64.deb 09c21c37a4f9a8851baa525e164dbccfdab930392667fa09a84a7df8ea1ce841 301592 libecpg-compat3_8.3.17-0lenny1_amd64.deb 1a38d44c7a71a08263ddec2f3f0ee64121b3e193a2d7c9e2b3a1f7fd6a9e1840 323090 libpgtypes3_8.3.17-0lenny1_amd64.deb 49c385d33471d1ae4450f9a2482e47282accc7a3b4d70d566a636c5b6bb45e76 5461896 postgresql-8.3_8.3.17-0lenny1_amd64.deb ab4baf5a11e4a6e1aac7470e6f27c20921a953cc83e071413d9ae523f71f0877 1746808 postgresql-client-8.3_8.3.17-0lenny1_amd64.deb cb8eb2a377d4c1e1ed8edf3c51bedcd21474621980e5a2c898e835d226bd5a5c 865876 postgresql-server-dev-8.3_8.3.17-0lenny1_amd64.deb 70c3b86e4687016540bb80777e8b797227a4569eb85d8bf616350e0b0578bf2f 657846 postgresql-contrib-8.3_8.3.17-0lenny1_amd64.deb 08c1e341d3377cc59a1fdf199a5f31dce2b6987857deec8003129fd798bd0aeb 323100 postgresql-plperl-8.3_8.3.17-0lenny1_amd64.deb b1c48a1061fad9d0cbc914f40482f10b96ffb7eb3f19fad24efaf4f9a832e7c3 315502 postgresql-plpython-8.3_8.3.17-0lenny1_amd64.deb 5d6b759654a77d6bbf8e06a288e6d967d3b24b6053f75f287442dfebb77174f2 313208 postgresql-pltcl-8.3_8.3.17-0lenny1_amd64.deb Files: 051d9fa04b8cc2af3fd364be422a7d5b 2312 misc optional postgresql-8.3_8.3.17-0lenny1.dsc 0866d80adef07a6602e9aa519275231e 14215528 misc optional postgresql-8.3_8.3.17.orig.tar.gz c8a3baf956a718aa024e9e4cf5a59a04 55376 misc optional postgresql-8.3_8.3.17-0lenny1.diff.gz 36cb0948b83559287c1e9d6ab5c95e91 2256858 doc optional postgresql-doc-8.3_8.3.17-0lenny1_all.deb 3f6a5585283a501eeed71e26ddf82cb4 293606 misc optional postgresql_8.3.17-0lenny1_all.deb 9b542b6d2e61a249011a520db0954618 293590 misc optional postgresql-client_8.3.17-0lenny1_all.deb 40175d1172651782df625f3d61243dcd 293420 doc optional postgresql-doc_8.3.17-0lenny1_all.deb a60c9a129d8217ee5f97c6639c1bf2e0 293490 misc optional postgresql-contrib_8.3.17-0lenny1_all.deb 18cd1eb5826e98d8917212fc8da7df52 500824 libdevel optional libpq-dev_8.3.17-0lenny1_amd64.deb ab3c129c25a58bb3016fafabdd77e0b0 432264 libs optional libpq5_8.3.17-0lenny1_amd64.deb 02074b9eb276f4d168cfefa5cb130132 322868 libs optional libecpg6_8.3.17-0lenny1_amd64.deb 25707378140edccb5bcf11592b398ff4 513092 libdevel optional libecpg-dev_8.3.17-0lenny1_amd64.deb b14bead0e8294f9e89230a005b1a0e79 301592 libs optional libecpg-compat3_8.3.17-0lenny1_amd64.deb 899535eeaaaf929ba41f27f1c6e7adb8 323090 libs optional libpgtypes3_8.3.17-0lenny1_amd64.deb 5cc5f41c49d82a2361931113c7e17ea6 5461896 misc optional postgresql-8.3_8.3.17-0lenny1_amd64.deb 816bc75357d9c150d76c597e99f111e9 1746808 misc optional postgresql-client-8.3_8.3.17-0lenny1_amd64.deb 7c79cb77ca75105813faefb2dc714624 865876 libdevel optional postgresql-server-dev-8.3_8.3.17-0lenny1_amd64.deb 767cf1fe3d230e86dc6133e4c5a8baab 657846 misc optional postgresql-contrib-8.3_8.3.17-0lenny1_amd64.deb bebd0f79cb255a45289672265eaf86b0 323100 misc optional postgresql-plperl-8.3_8.3.17-0lenny1_amd64.deb 01a5c713024c5a613199f546e11e85d4 315502 misc optional postgresql-plpython-8.3_8.3.17-0lenny1_amd64.deb 5ce1e45cfd58ec478b4469e38f21ce10 313208 misc optional postgresql-pltcl-8.3_8.3.17-0lenny1_amd64.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iQIcBAEBCAAGBQJO2k4MAAoJEPmIJawmtHufPBoQAJsQDAH/e/jiNJR6wtVx36gG kb08wNkln5mSxIWfNjYWqBhm42tNi/Ne7L62HeN22YPvA+m+tOS3dBSutvbxOx+3 HKDctqoIV3ehEvZ+M/mqKH1WSqvVhi5dQ/YM9LVHcCxCnCOgSW/aml8xOK/16/Rz jcMHY9hoD0nvWtWTZ/IQEfpuu1h6BYyRuJnYs/IR/lcB1LCDLEt91jxxRr08IKYk 1mb9ffAcsy8uypNynohzzYYVpPZ+eM8MDSGo/k1ag5htBGdZVyB1fd8Ke+qIsNro XOeDRHcyGZcpTwM/Ts7yswR3Wa2dCS4i7xj+CHtsl5+sYmll5+N59NVyei7nM8gu 30CpJpiVW8JEnLEvLYeMkMphwylaWR/x/Znl/ksC4h0Qs+ZGAisnk6fbFMXiJHmO Y95MwjDvWBZMsCkyIf9XBbeursa9+CYIy1bzstySGAcrGnNv7VsZh71+RXXMdVZ1 TC2C0wagslVk8vlPlSb7yqI1rb8QXDkOFhVTrLRMTZuy1OH+AWTJvUTsiBiIov35 6Bbe0tMJ67wmoCFDuxXM6bQyn6ZsuVMrw2PAV4N0jogevmhLwxmWqaKCUR9qBrIn VLdyw2tOrs8pfSvuUVeyDku5dH/q5lSipJpU+ZecUOalEawWHis4+PX9F+UyQq1g g4+0HLDNWpEKrDeNAbr7 =cI35 -----END PGP SIGNATURE-----