-----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: i386 Version: 8.3.17-0lenny1 Distribution: lenny Urgency: low Maintainer: i386 Build Daemon 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: 8927f97fe10cc2af2f0b5923ac7433b4f5cc6149 492112 libpq-dev_8.3.17-0lenny1_i386.deb d8941845814bf6101ce384821ce03d34f4fa19a6 428740 libpq5_8.3.17-0lenny1_i386.deb c403081a787d369a81a7cd36d963b67cad94ceb6 321834 libecpg6_8.3.17-0lenny1_i386.deb c601fc68c3b1c4ae2eef7469ecd62da4a9dacd4a 503448 libecpg-dev_8.3.17-0lenny1_i386.deb 0fa979fb6aebd3e443f6fa0e3069be52acc5698d 300700 libecpg-compat3_8.3.17-0lenny1_i386.deb 44dfd2dd1bb9074aa24f1711045d6ec93ada72f1 322334 libpgtypes3_8.3.17-0lenny1_i386.deb 6970a04b53a5b417a4070bd95cbd7817d2af08ea 5339198 postgresql-8.3_8.3.17-0lenny1_i386.deb fc4840f4b4eca7183398856a0e05e1e43ba5f948 1712058 postgresql-client-8.3_8.3.17-0lenny1_i386.deb 55855e8acc2f1c221956031ed28ef71b9823c0fc 865576 postgresql-server-dev-8.3_8.3.17-0lenny1_i386.deb cfa663b0624f06b833e2559ac18d4329607d7446 622436 postgresql-contrib-8.3_8.3.17-0lenny1_i386.deb 2658bd1f7ae354b00eac39effdb18b6e9e382dfa 321242 postgresql-plperl-8.3_8.3.17-0lenny1_i386.deb 2c01e69a3730e69b8e344eedbdc1954ebf652297 312660 postgresql-plpython-8.3_8.3.17-0lenny1_i386.deb 7ed31f8cdf62b1608f35e1148b9e90e27cf6cd77 311958 postgresql-pltcl-8.3_8.3.17-0lenny1_i386.deb Checksums-Sha256: 21b388a27a91c89b5f9e689f54cde17b08bdcef9fcbdd0d6c4d77cb2bdbe4819 492112 libpq-dev_8.3.17-0lenny1_i386.deb 86adc2911ead39f434ee1310f21520bafe202633bf1140c27c82da9825dd25b2 428740 libpq5_8.3.17-0lenny1_i386.deb bc46722513db7d6df333e733f7f804a278e7726b5a3aa831fe78b1dcc54d8c10 321834 libecpg6_8.3.17-0lenny1_i386.deb 59200f0d765ea3265a6497f138ae80a90d33e95191d2e72bb0c5acff855bf84d 503448 libecpg-dev_8.3.17-0lenny1_i386.deb 253a3a0b7a9d03ef2aa9c89c6bbba7a1682ca5bfd901ea899f31ad7ddab8a8d3 300700 libecpg-compat3_8.3.17-0lenny1_i386.deb 3a56c17e34f07a393f07171a8c22abf3c971cdb9c9db2d8bb83caf9f70b1537c 322334 libpgtypes3_8.3.17-0lenny1_i386.deb 6b397d042e5a9cf9febd293017089548b6737438bdabdd7495e3bd7ada5d1a68 5339198 postgresql-8.3_8.3.17-0lenny1_i386.deb 46379bc1ec55b40ca82b177e9a8e8f6326e486d01330ce4588fa5212761830b5 1712058 postgresql-client-8.3_8.3.17-0lenny1_i386.deb 54e5e293766cf48301647dbc8719f602cd8f4fd91eca079eda17bc6c550f29cc 865576 postgresql-server-dev-8.3_8.3.17-0lenny1_i386.deb ef531bddf440972c5c6f22e86566e4ca7610db9fd0a9b34435d59534c43d482e 622436 postgresql-contrib-8.3_8.3.17-0lenny1_i386.deb d6047dabaed850382dc702337d590708bdf793eec4c4a73f30c48207983f1e7b 321242 postgresql-plperl-8.3_8.3.17-0lenny1_i386.deb b4724ae92e952a14f09680c5f391c9badfe9a4428e25761f230003e4a36cb1ab 312660 postgresql-plpython-8.3_8.3.17-0lenny1_i386.deb b202e21c9b2ebf3e10a938e0de26c21c4c7afb1ebe2b538e39d80e1676b0e2bc 311958 postgresql-pltcl-8.3_8.3.17-0lenny1_i386.deb Files: a75fe106761e4444342e48bf252b990e 492112 libdevel optional libpq-dev_8.3.17-0lenny1_i386.deb 5d3c97f9a518dd2cd19cf26c5de592a8 428740 libs optional libpq5_8.3.17-0lenny1_i386.deb e4ca4522031014b5785b482e5ecab0b5 321834 libs optional libecpg6_8.3.17-0lenny1_i386.deb ab7e0aa618b68e6006d7adfc5af7fdc8 503448 libdevel optional libecpg-dev_8.3.17-0lenny1_i386.deb 7c42ba953a0637825fc84d74952d1f5e 300700 libs optional libecpg-compat3_8.3.17-0lenny1_i386.deb 18cef2e7821445ca12af0fd0415e979d 322334 libs optional libpgtypes3_8.3.17-0lenny1_i386.deb fb1e77325fbaac318a8e051df397b241 5339198 misc optional postgresql-8.3_8.3.17-0lenny1_i386.deb b0fd84ced2cbe20132ec83a34f0396f8 1712058 misc optional postgresql-client-8.3_8.3.17-0lenny1_i386.deb 9084c2dcf9f6ec20c5f824ba8aab7bd0 865576 libdevel optional postgresql-server-dev-8.3_8.3.17-0lenny1_i386.deb 6b5a7fbaf0470552305be01e0f6bdb93 622436 misc optional postgresql-contrib-8.3_8.3.17-0lenny1_i386.deb 92afb3f62adf52d629cf66189631edfe 321242 misc optional postgresql-plperl-8.3_8.3.17-0lenny1_i386.deb dd2bd2ac896e23bc30766d67920cac6b 312660 misc optional postgresql-plpython-8.3_8.3.17-0lenny1_i386.deb d8d985c72067c1c338a4c1ac640afac2 311958 misc optional postgresql-pltcl-8.3_8.3.17-0lenny1_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQIcBAEBCAAGBQJO7LUzAAoJECkckSfIPUEstqoQAJyMLa+0WXAUXBZyco9S1rOC mbKn9RW7AXVxw512JJgSqyO2AHpI2Ca1HcAOWVW1w6d7Da0pEx5WGLBy7S2x/sbU 46rX+L6UJqmaSUnj7+FXnwJnaV+akhZ/0lr8+UtRzERTQ3QqQyfcyjKqzcdNEUDQ gNl6uFwAHm92g9t/Ze8ytTKJGu38B+9dRqZIuzFXyMdqk84xq3oa+9QT5JB1Qh/6 t8jBHj2xV8K/XaT/iDOmIfwe1DGAOb0h35TebwH9XvEnuj8MnHTQnOLdHfuMl/Nq yL/n1ZxxTDwzbkqPVFuJHuIm/KeUYqurUfMyh7+MCQS/1232KhulOpMOFvdQGGGb jvTZzOUZ+4jJDV954rvri05MuC6pBVvURpniaJ6+prjSazd2zhIikH7WNkPx/aPz XB5YTeOPavqqQpCi1e+K3tEaTfUjKC8KYX0vEV+4FhL6K7s6aCuSRVVlPc1/Tyye 9Ct5u8Q1nzITjKTHs1mGOd2vItmDS0BEHLA+wlZu6IeG++JymUmo2ig76/O1/9M2 /Spc7DZBsykLEMFPOScLVyNVPqGGCvyQWuuUhhXpKD5eziRYiFjsHTj3b4CT21Zw T2XxS4fwy42CjB4oLxqVMNZJTiiOrH4kFWxObwuNMRc3zzQGo7zya75MP47hPyqw iTQNzhCfPlYn+i6VA5MU =7Vqk -----END PGP SIGNATURE-----