-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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: kfreebsd-i386 Version: 8.4.10-0squeeze1 Distribution: squeeze Urgency: low Maintainer: kfreebsd-i386 Build Daemon (field) 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: bf7a260b01365658fabc54ac557630c55dfb645a 235744 libpq-dev_8.4.10-0squeeze1_kfreebsd-i386.deb 78839a99fcff7bde2275de0efb7e8c1b16c23d20 155336 libpq5_8.4.10-0squeeze1_kfreebsd-i386.deb 7eab8743510c8fe1d8d00680110a928408f7c8ef 95424 libecpg6_8.4.10-0squeeze1_kfreebsd-i386.deb e43ad4a88adc104ef3d413516e5b2e2efb914888 246976 libecpg-dev_8.4.10-0squeeze1_kfreebsd-i386.deb 2e903143a763f5cee0469e72322574ccf314a55a 32518 libecpg-compat3_8.4.10-0squeeze1_kfreebsd-i386.deb 52072c1707b1744f28342ce13dd73fdcc4826f4f 56260 libpgtypes3_8.4.10-0squeeze1_kfreebsd-i386.deb 20fa8d0b670cd774f9a7c3b6b838a8c4ad2740ee 5322350 postgresql-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb fbddc7228be4471fdf94946877e149c46ebaf2dd 1474064 postgresql-client-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 437d7da16e6308ee35c5375cd4a76c62603ac182 633286 postgresql-server-dev-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 1e521ea95dd8c66f3f911a01ffebc3762d8da2e9 391164 postgresql-contrib-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb d548c9f043ca5694e60b65806e64724ca02e8b69 61402 postgresql-plperl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb f07d77700d634cd7a322f2c38a9000c452968812 61554 postgresql-plpython-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb ecb27e2bd9dc2e0a8e71e109b4b3e85a8077d141 47740 postgresql-pltcl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb Checksums-Sha256: 2ba1dc169c2b7652edd78baacb163268c74fc637c2b26c4cc95919789804532b 235744 libpq-dev_8.4.10-0squeeze1_kfreebsd-i386.deb 288e96136d6043dc649b5f1f8293699a7930a5b264b0dcf51d7304b8625aeb10 155336 libpq5_8.4.10-0squeeze1_kfreebsd-i386.deb a1ce708055da090dd7ed44c47d6f7cafa6574010a245f6a85085c729643bd36c 95424 libecpg6_8.4.10-0squeeze1_kfreebsd-i386.deb fb90b5096871f391904dd908ec45e55bd5644c0231db5f400f011b50342fd2a0 246976 libecpg-dev_8.4.10-0squeeze1_kfreebsd-i386.deb 1208aaa3195d56e7ddd35df3171f1766660cc4344eb7932370ebf89bf049d1f0 32518 libecpg-compat3_8.4.10-0squeeze1_kfreebsd-i386.deb dc5a481838ed2f2c30f99f8983e56c0a09c4f3e80e3914c990115f8a19256aa5 56260 libpgtypes3_8.4.10-0squeeze1_kfreebsd-i386.deb df7db425007c3ad09eb90bb2a3fe983ddbaa21e2fd8e58b11b66c1734a64b0f4 5322350 postgresql-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb d276e17d16242740a60161dbf366e775bc6be520045c71a32fb5eb2167a15792 1474064 postgresql-client-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb e944053ea2fc52c0fd2cc71f68b95756c44c53a3972742ec6db5fcbedccb76c6 633286 postgresql-server-dev-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 86605ff2471479a3f25fdc4d27c61cafd52549cfd53ae3414ff86b4e60068a5c 391164 postgresql-contrib-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 4406a0fb6e1c0d5641436ae18b1570c3a8219e6033510e81e535950442cb1c19 61402 postgresql-plperl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 70ebb726f691104bec0f3cb5b7d787e5bf7c60e0eeb85b9340d7003682b132f3 61554 postgresql-plpython-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 6fbd785ef0f30dd72c8bd06612731f741bc6ab3113e509669cd5937c147348d0 47740 postgresql-pltcl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb Files: 19b73b21b210e33fafa8c25e782b78c6 235744 libdevel optional libpq-dev_8.4.10-0squeeze1_kfreebsd-i386.deb 06f1317534c0f010d4c118525ae32650 155336 libs optional libpq5_8.4.10-0squeeze1_kfreebsd-i386.deb ce9386c374e74a37cf8f5508118757d6 95424 libs optional libecpg6_8.4.10-0squeeze1_kfreebsd-i386.deb 180aa40df52a270b02d220dab4899991 246976 libdevel optional libecpg-dev_8.4.10-0squeeze1_kfreebsd-i386.deb ae6efeec52017d4fc330d0726de21cca 32518 libs optional libecpg-compat3_8.4.10-0squeeze1_kfreebsd-i386.deb 812b9f2b15535b8a50fd62e832452f22 56260 libs optional libpgtypes3_8.4.10-0squeeze1_kfreebsd-i386.deb c6e8127df878de2312491f67e5b6f587 5322350 database optional postgresql-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 2451883c4bfa711fe989679744aed230 1474064 database optional postgresql-client-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb d3f7e96525dacd5985a0f131ad6a4df6 633286 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb a9e07732996061890b04f108dc13f649 391164 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 36ecd5f16cb7e72ddfa5df4e02a79a0f 61402 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb f4681553f0d559445114502c2d96a423 61554 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb 8346fb8caad57ff264f9e44dd7fbeaaf 47740 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_kfreebsd-i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/kFreeBSD) iQIcBAEBAgAGBQJO7L+iAAoJEEzv3ERlujMclLkP/j5ojmLc3hK7kdGI7dc2fPvR nBYHVwzsx2kkyGDoPKQ8Cy54FjhyypLzMTD61WFIg1T+cwH6BEHh5sGRH7RDnw3r H9EbuTHjq0ZwfB9TFuZeXpNURLVKiCPoV5ZaVaejok/0vPw6ntlUkHRD72csNT/I 1dDTxaPZqGumV27GNdHoXbsBYQT4zOo0dWJl+2KNYM3mWiaxGpOkRXiQShVqEY7b hzvZLwE41Lf9eNeLNoEOf9xJMWBUbQfXrnu7CZ/1WejeJokxZDX3KvAkR31kfdV9 R5kP9Xal9AGoVMjuJ/2cY4wptjzv7tTJ1RTzE/0q8MCLTx5LtbSb2aMBadqtb34V ROaeCCICzxg5thXb08JvofCB3xmbjYfTJuZQ2iM0JEky5QbINwVnrRcKC04w5yxf hiLHBmLPtAXCW4oJ7iuuCZoa6c6EpJ6KLP06A4PUlyj2w4ZWf4gmWdXY53Ugv6Bd MgOGsk4iqiEjMW28XSrT5/4g5RGpB2zxWIYfFvaEj+tIw7Gen//URLxdl5FuLQ7x QkotStcPMEdQqPPbX6VlxFdjo3hB6ue1B4cryOVvojyYzDd4yTUOXZUwhYyDtcXf la8lcxNN2k8sEVKYBLGVTIklj5YEbN6Iz93n0htkc6rSk1jzdBglw0N12I+TRJ0X iUvWpyHyTrm8T3P0CyqJ =ziTv -----END PGP SIGNATURE-----