-----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: alpha Version: 8.3.17-0lenny1 Distribution: lenny Urgency: low Maintainer: alpha Build Daemon (goetz) 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: f0ccd9369ff5f317978789f15ad8e98f8d4a6bae 519398 libpq-dev_8.3.17-0lenny1_alpha.deb c914e716fbef7426902cdf14027db5edabeeeebd 435222 libpq5_8.3.17-0lenny1_alpha.deb bb4b3731c479093243d01f405e2a5d70248ff2c7 322202 libecpg6_8.3.17-0lenny1_alpha.deb 6c505fe85ddd3ba3d364be413b66894178e45e61 515960 libecpg-dev_8.3.17-0lenny1_alpha.deb f32d3e6383e12c655e40374680704dc5e317e9ce 301734 libecpg-compat3_8.3.17-0lenny1_alpha.deb 7bc1bdf542528abfd2cf77e0400584c29bcfbdcc 322968 libpgtypes3_8.3.17-0lenny1_alpha.deb 5d2fb04d8b349e9b5af4a1f171d701b1e9461bc2 5356916 postgresql-8.3_8.3.17-0lenny1_alpha.deb ae81e2ced2e28debf97a8b9800ba6ff096efa09b 1748908 postgresql-client-8.3_8.3.17-0lenny1_alpha.deb bcbfafc356714ca823fd71751533fbe0f756b41d 870570 postgresql-server-dev-8.3_8.3.17-0lenny1_alpha.deb 666a33b9be4d55de7d9d0b0644e6218b04c1087a 658474 postgresql-contrib-8.3_8.3.17-0lenny1_alpha.deb ed91272f57f95ff9e97d0e57c5b9b9f128f9e0c2 323126 postgresql-plperl-8.3_8.3.17-0lenny1_alpha.deb c0481dc5f120b78725591434ec50e0845a3ab437 313544 postgresql-plpython-8.3_8.3.17-0lenny1_alpha.deb 0b946b78b75263311344799bfff74a6659a23546 312408 postgresql-pltcl-8.3_8.3.17-0lenny1_alpha.deb Checksums-Sha256: 0bbf726604d1db0a4a57e1be406178dac996c63dd74bf933b1571edc47e0e460 519398 libpq-dev_8.3.17-0lenny1_alpha.deb 04e4096ed8dfc26e8ed98bcc9384923d315613998862cdf69046f348f5c95b1b 435222 libpq5_8.3.17-0lenny1_alpha.deb 4fa9fc4560bfe1dd8351511433e150ba6fb048eb4fa8f98e9cd101ac52abcde2 322202 libecpg6_8.3.17-0lenny1_alpha.deb c7fa4a508c4985f3cf1272b06dc013b59fbb936bc6c05a8063378d072895edec 515960 libecpg-dev_8.3.17-0lenny1_alpha.deb 31c203e4debb557508f08b5db24534aa08b47eceaf97e4433f4d449fd1be64ec 301734 libecpg-compat3_8.3.17-0lenny1_alpha.deb 2e6f6ed8c61e24692388b24f436b5bba7888a2a4a37d5431ce0b15d3f71d372f 322968 libpgtypes3_8.3.17-0lenny1_alpha.deb 284507d3697da85bfd72c08b9d2b24079e8d0ff5846593380d1fc1de91a93fe4 5356916 postgresql-8.3_8.3.17-0lenny1_alpha.deb 82eff539e0d3105bed356675cb8f999239550610a6ee4945056217253978e31c 1748908 postgresql-client-8.3_8.3.17-0lenny1_alpha.deb f3a362824a4fdbc75aaeb57fcd5f84aa5b55e4890ab58fa0ef659fb7425cd931 870570 postgresql-server-dev-8.3_8.3.17-0lenny1_alpha.deb f91f7b0040502e95e7b02fc0457ff12e21a01cecf6be9b57ea2969f67dc7430c 658474 postgresql-contrib-8.3_8.3.17-0lenny1_alpha.deb 1daa5c672d67b47e5256c525647391b38c5259c78042d1bf277b7249548d850c 323126 postgresql-plperl-8.3_8.3.17-0lenny1_alpha.deb 9a4c2d7cdbbce24b79fa4151c3761394fac2667912f4899d93b3bb79493faac3 313544 postgresql-plpython-8.3_8.3.17-0lenny1_alpha.deb 221744e5eb07d9bf781270348ee0268b224f47eba9c08cebd375934b8a4d0da6 312408 postgresql-pltcl-8.3_8.3.17-0lenny1_alpha.deb Files: 3e6cc561c7d9a0b0ff6be4861be8eca8 519398 libdevel optional libpq-dev_8.3.17-0lenny1_alpha.deb d3c6da3d807e18c3c9820d9b16482c99 435222 libs optional libpq5_8.3.17-0lenny1_alpha.deb 64b683866de257ac55dd48035b54b011 322202 libs optional libecpg6_8.3.17-0lenny1_alpha.deb dafaa84d760237b574af1540c5d70ade 515960 libdevel optional libecpg-dev_8.3.17-0lenny1_alpha.deb bff767d0dab48a2332f9d560b45fcf16 301734 libs optional libecpg-compat3_8.3.17-0lenny1_alpha.deb 2bac817cbeed89b3798a8db0b8d8d915 322968 libs optional libpgtypes3_8.3.17-0lenny1_alpha.deb 10efe5799c9fec639e6fc8e0dff41b12 5356916 misc optional postgresql-8.3_8.3.17-0lenny1_alpha.deb 8a4f7f4285c536c269ecc90f64293831 1748908 misc optional postgresql-client-8.3_8.3.17-0lenny1_alpha.deb 932c5c52d2c68152003084e9d61fe0e1 870570 libdevel optional postgresql-server-dev-8.3_8.3.17-0lenny1_alpha.deb 3f3b82eb6f221927852aefc3101f1cd2 658474 misc optional postgresql-contrib-8.3_8.3.17-0lenny1_alpha.deb 71ffc132f40f3b41433e4f272abf71c5 323126 misc optional postgresql-plperl-8.3_8.3.17-0lenny1_alpha.deb 9a6d5a176ace10de306b2ed39ac69a67 313544 misc optional postgresql-plpython-8.3_8.3.17-0lenny1_alpha.deb 0d2e57d6cdbf7bd6f5bb78569be2ec97 312408 misc optional postgresql-pltcl-8.3_8.3.17-0lenny1_alpha.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iQIcBAEBCAAGBQJO7Sk1AAoJEH02CAy5o2TLopQP/iBYnqd+2r5ASm7Nb+JiTTh8 bXzyMnmEb98JLZEIwClqWbYrJhrJeMdKTjDTDmAze9TXoHi2py4rlOH7+RCqVaJN 0Ni964DLJ3xq2eOkxNgq+KpfHbnxAOeNJeTUE/H1sSaLSsoHODhLiw6cRRuizzNg i5pqs8Qdu1ZLpTlMuOLjsQGpZ/4JVtQd9EaJOD7z+ZLPN8XXhViS2HHsinucV87K zMeJ/yS+bQryT1xGXfWxLGPegAZ1HwS+nmrQWKeNLCkkd1tC0BRGn120bBRsH959 hdeWKhHl8dgQL3gss/uyrWlX+sss9Xaimi7lifNEc2Fm8CyLXMWsk1ozEMZThUT6 gG/dGTEp5ZA9AYAjVomlsZW6SJ71yW1qjCNIddI6W7sfBdw0Jb218XbTKXPNFSqu VKZeXJn3YCe8xWriLwFWMAXK3NDYJLURFTqqT5rWqf+XPPXvrWyADdUizVzZjDYp ejs9e10vFlXtrRp6Gng0D0gai85XOIMKf4ydfrGl3rCrjVKUPmLzwPtT/BvBpNyW B4Cf79WwyBA9nb3V9It/dRsCdlMXggXwZImtJw8e5VcaxJzXVJmq3mOXIga379Dv fIAv9PZGpBEKmAeO9kimyU8utwi6HZynKN8E/nXDN9DFGmrzmSwe84qdNGNmzJPK fYLGavfkVvBFHTmf86ZK =1mP6 -----END PGP SIGNATURE-----