Format: 1.8
Date: Thu, 15 Dec 2011 10:47:04 +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: all i386_translations i386
Version: 8.4.10-0ubuntu0.10.10
Distribution: maverick-proposed
Urgency: low
Maintainer: Ubuntu/amd64 Build Daemon <buildd@roseapple.buildd>
Changed-By: Martin Pitt <martin.pitt@ubuntu.com>
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
Launchpad-Bugs-Fixed: 904631
Changes: 
 postgresql-8.4 (8.4.10-0ubuntu0.10.10) maverick-proposed; urgency=low
 .
   * New upstream release (LP: #904631)
     - 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: 
 f354d5ebe0f33e4439c7dcec5d37ddff5447c444 2164860 postgresql-doc-8.4_8.4.10-0ubuntu0.10.10_all.deb
 3d27430007495a82e808033c5486b069b1c8fc2d 2155170 postgresql-8.4_8.4.10-0ubuntu0.10.10_i386_translations.tar.gz
 a186fb750ee4aa6b8e5132710b2633c443948d6c 25192 postgresql_8.4.10-0ubuntu0.10.10_all.deb
 b10d3e454fc0ad6221bd58ec9bbbff3aecebe63f 25170 postgresql-client_8.4.10-0ubuntu0.10.10_all.deb
 2099512bca778716c4e7e387120d6d2934b2c475 3420 postgresql-doc_8.4.10-0ubuntu0.10.10_all.deb
 7fc49512edee988674943ff50c67f272fa8dd059 25062 postgresql-contrib_8.4.10-0ubuntu0.10.10_all.deb
 2cd8d9580680a4136ce189954999a4d3b1c1c38e 193530 libpq-dev_8.4.10-0ubuntu0.10.10_i386.deb
 26200830e698350b907759b3d0d058fb07a5f35f 90502 libpq5_8.4.10-0ubuntu0.10.10_i386.deb
 27263f4a7f768d264d0e02e5758d9a6acdfba1b8 32046 libecpg6_8.4.10-0ubuntu0.10.10_i386.deb
 6102452c8a3601b38af4e39d0970b1fdd3779a11 225862 libecpg-dev_8.4.10-0ubuntu0.10.10_i386.deb
 93196bc0f1f2cbd0f8fc8b3907a3d4e5e475df3d 10278 libecpg-compat3_8.4.10-0ubuntu0.10.10_i386.deb
 dcaf6ad320581c4445ceaa787ea63bb6e2a7387d 55778 libpgtypes3_8.4.10-0ubuntu0.10.10_i386.deb
 7698df347167bf1786b3355fcd4eb221d3e636d0 3886634 postgresql-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 10cbd86a5b050e0757992031324db735f9ca4926 781412 postgresql-client-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 556d1d1c7752e66d885f208dd34918e3e5ddff3f 640304 postgresql-server-dev-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 6a43f3fcc4b4ceb20bfcf2f6dde07ae870b518f8 364080 postgresql-contrib-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 502f53eb54986685802a78e7cc04225706859b04 52754 postgresql-plperl-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 785878ae00cb9209dcbf1ba45cf0ca335df594f3 45052 postgresql-plpython-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 e47c2aec8ce4e65e8c46c99b68e71f226af4b659 44246 postgresql-pltcl-8.4_8.4.10-0ubuntu0.10.10_i386.deb
Checksums-Sha256: 
 80003ae662e40cdae1148a5b980db69af6bdb0e631de3eea3019a08aa9875588 2164860 postgresql-doc-8.4_8.4.10-0ubuntu0.10.10_all.deb
 b2d626a754b38147af9e73d9a53604dd4bce021f76af2ee768a57535e7c5d78d 2155170 postgresql-8.4_8.4.10-0ubuntu0.10.10_i386_translations.tar.gz
 4c0999845889c1602d83307e9e03e00519fe6a3b79c125a3cb9ff03bd5ac3525 25192 postgresql_8.4.10-0ubuntu0.10.10_all.deb
 d44bbd38902639115895d2e470f2a49ff621f8f2976cb95ab976a378039892d4 25170 postgresql-client_8.4.10-0ubuntu0.10.10_all.deb
 15671d76faeba68010082b241887718927a616180ecfd5a6d5d23c56d42e6c4e 3420 postgresql-doc_8.4.10-0ubuntu0.10.10_all.deb
 8c24527f167805553337af78f00dd202674dfb3b22ceed778bdff71382cf4a00 25062 postgresql-contrib_8.4.10-0ubuntu0.10.10_all.deb
 38bf3673a9c94692610eb76235703c7edfed5a3cf6954e21bc56f378f7e380eb 193530 libpq-dev_8.4.10-0ubuntu0.10.10_i386.deb
 e1569dd4d9df6f8c132dc065a5708f6c9de714260e034d3c323a91487667f3c1 90502 libpq5_8.4.10-0ubuntu0.10.10_i386.deb
 8e003292dc687980612f6c465b01837e3e843a71c8bce99fdd9028a55ace6950 32046 libecpg6_8.4.10-0ubuntu0.10.10_i386.deb
 46d411180b5486b18db067316087b99d5e1c78cd4b743621759c2b4647511fc5 225862 libecpg-dev_8.4.10-0ubuntu0.10.10_i386.deb
 7e7ff9b70cc9fbef7363f1e636853c0dbacdade55e8686b4d8fab90ed1c6844c 10278 libecpg-compat3_8.4.10-0ubuntu0.10.10_i386.deb
 de5c444a16577d87b2c901b3e147bedab6c201bf5b7bacf40d96ba4a0b5c9b28 55778 libpgtypes3_8.4.10-0ubuntu0.10.10_i386.deb
 ba893945c659d4012407a5fda331f27d1fd1293639a28e79fa07fd722b2e0838 3886634 postgresql-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 37c5cdf77c85ec0b3738c072c3c77e3bdc1cf509160effe3d99a14b3b2895ba9 781412 postgresql-client-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 fc919ac4e4d2df69aaef516a4d49b50a0a0349a950b306f1969f4b47388a226b 640304 postgresql-server-dev-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 23a6d510835cfd574d211c71ff8f1a34a93eff300730186e8bf79c12b58283f8 364080 postgresql-contrib-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 27dd97e9da159edc870f9b84e9cb3c46a2dc34c02bf8e89964ebdc69da2a766f 52754 postgresql-plperl-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 54786debac5b2516ae4faf73a1546cccf92a8eee9aaca1e26a8f05515d5343af 45052 postgresql-plpython-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 188564e5a2eeb0eff4536192ba0f287102ab2b5ca8a672d766627ccb50c7af06 44246 postgresql-pltcl-8.4_8.4.10-0ubuntu0.10.10_i386.deb
Files: 
 08e63e9144078b60cf1302ff42a4c84b 2164860 doc optional postgresql-doc-8.4_8.4.10-0ubuntu0.10.10_all.deb
 ace0141ef702f1f8a8db4f80fe865cc8 2155170 raw-translations - postgresql-8.4_8.4.10-0ubuntu0.10.10_i386_translations.tar.gz
 48adcdac9e257ecad7f67daff00ebc16 25192 database optional postgresql_8.4.10-0ubuntu0.10.10_all.deb
 d4295c59629515f9ec7176bf6b4c3d5b 25170 database optional postgresql-client_8.4.10-0ubuntu0.10.10_all.deb
 281b06432eb8801acf65ba29b3e9276a 3420 doc optional postgresql-doc_8.4.10-0ubuntu0.10.10_all.deb
 69a5f306b7c9b4dfafc53fe35b46dd2f 25062 database optional postgresql-contrib_8.4.10-0ubuntu0.10.10_all.deb
 fc65d9d960f8b3a8a8894d24bb25e4cd 193530 libdevel optional libpq-dev_8.4.10-0ubuntu0.10.10_i386.deb
 969f38403b48b0df0e782c6e76bd26d1 90502 libs optional libpq5_8.4.10-0ubuntu0.10.10_i386.deb
 f9f0cbd278b8f6f6fe505b45ba659396 32046 libs optional libecpg6_8.4.10-0ubuntu0.10.10_i386.deb
 ca24f1c50b2cc17ffffda76fcd4a92b4 225862 libdevel optional libecpg-dev_8.4.10-0ubuntu0.10.10_i386.deb
 bfc124e1c8ec08dfbbd64e065657a257 10278 libs optional libecpg-compat3_8.4.10-0ubuntu0.10.10_i386.deb
 284e040157903a319c69c49748ed78a5 55778 libs optional libpgtypes3_8.4.10-0ubuntu0.10.10_i386.deb
 d44738cdecec4ff05e34961b02da331e 3886634 database optional postgresql-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 23227891708f6b3afbd5171cf80ff4f4 781412 database optional postgresql-client-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 2e02aa5e98e9db91a68881c8785d1a25 640304 libdevel optional postgresql-server-dev-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 527e049d1f4944d3c32beb15fe26f666 364080 database optional postgresql-contrib-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 95a2abba5a0392c7e365baa34749960c 52754 database optional postgresql-plperl-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 3a3f9ad97329b12461ad40be8416681d 45052 database optional postgresql-plpython-8.4_8.4.10-0ubuntu0.10.10_i386.deb
 1a8fa246363577f70d2072d54d0faf69 44246 database optional postgresql-pltcl-8.4_8.4.10-0ubuntu0.10.10_i386.deb