-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
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: source all amd64
Version: 8.4.10-0squeeze1
Distribution: stable
Urgency: low
Maintainer: Martin Pitt <mpitt@debian.org>
Changed-By: Martin Pitt <mpitt@debian.org>
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:
090fb9d56d48af0f07160802870d7f4029833599 2506 postgresql-8.4_8.4.10-0squeeze1.dsc
1ae736d90cc84feb8b604f58fa7aa4e3fa415778 18157949 postgresql-8.4_8.4.10.orig.tar.gz
9972014226ebfd7dae4d97e14a934d5b2aa02fae 52659 postgresql-8.4_8.4.10-0squeeze1.diff.gz
7657eae6953ab0047c0aeb50df914e6a54f334bf 2172840 postgresql-doc-8.4_8.4.10-0squeeze1_all.deb
dc02b676ef592b03a9203cb266c9747d626ca086 25294 postgresql_8.4.10-0squeeze1_all.deb
6b9436226b9f2115a0012153689efac8317c15f0 25262 postgresql-client_8.4.10-0squeeze1_all.deb
51c6e9a10731f930b3aebb03950cc2cdab1b58db 25108 postgresql-doc_8.4.10-0squeeze1_all.deb
030359092bd7f2d117de9e87c58c96727d8565e0 25156 postgresql-contrib_8.4.10-0squeeze1_all.deb
9abad6dbf876069ed178caadcd698379a2570f8a 244180 libpq-dev_8.4.10-0squeeze1_amd64.deb
580aa18c2bde43f30704c39352ec3bcb26af20e5 164796 libpq5_8.4.10-0squeeze1_amd64.deb
9366ecfcd40403a9318681bafa685bc754685548 97276 libecpg6_8.4.10-0squeeze1_amd64.deb
6bd7b71bb7f518694a766e541ed4349e6f588e84 263224 libecpg-dev_8.4.10-0squeeze1_amd64.deb
de422632699b5f8aaa08d090940404eab69b7959 33102 libecpg-compat3_8.4.10-0squeeze1_amd64.deb
60c2a034dc9bf17b26eec8161234907c49f89a9d 56978 libpgtypes3_8.4.10-0squeeze1_amd64.deb
39e8791e6ec9645789b59d0a56d59d27f61e0d76 5483590 postgresql-8.4_8.4.10-0squeeze1_amd64.deb
2ef2901983db9840c1a65f5aeef22b06c843816d 1530562 postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb
62da07ceca52672225560afe0b4cd8e595360b54 642276 postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb
8813b8ee7afa805c702100d5e5491098d87436d6 436238 postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb
613161ab125cbec14bd27da835e09a74e6956e2b 62450 postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb
2c6a17eb525e153192a466de7c8a0d61b44d1457 63656 postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb
1f79d0ae46ad47913c23ab75a826521e56b24f69 48212 postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb
Checksums-Sha256:
4e46b8784ce4e7b134b53d0b5b60cb8492afd0d7c06cbf489fb153db28ea9806 2506 postgresql-8.4_8.4.10-0squeeze1.dsc
8da06d33a08004293d70eac1d006c8af3d8aec6e13b509fdcf0ff800e48c4cd7 18157949 postgresql-8.4_8.4.10.orig.tar.gz
e77a170df35e2418ee3bf41f7f66ba48c3cd9d4c56dd383d4ad55a43631d4353 52659 postgresql-8.4_8.4.10-0squeeze1.diff.gz
d6d57e93c9434628bb3cc27688ece3ebb46358df26033996c682bf454f8b53ff 2172840 postgresql-doc-8.4_8.4.10-0squeeze1_all.deb
7cfb1415ff39d99219669c2169e8e4f2c2df6c55948cd4547593f07bcd65369d 25294 postgresql_8.4.10-0squeeze1_all.deb
ef8eaa21dadbf208f58463fdb8e0ca4c085081d4200b5276921ebb1c8107985c 25262 postgresql-client_8.4.10-0squeeze1_all.deb
3653b615053ca0c567844d161b248a94d4dcaf8defab59f72d0da702efe6ae0f 25108 postgresql-doc_8.4.10-0squeeze1_all.deb
9e3eb39c82f4ef0036b9a21624500e498a7f4904fde15a19cb3a134903b16809 25156 postgresql-contrib_8.4.10-0squeeze1_all.deb
bd9fb5bbda43d7c1b021507868a6579b35f0779cc0a441e5ee7c2e0f8813bd2f 244180 libpq-dev_8.4.10-0squeeze1_amd64.deb
d45d1c9a86e328bc52580d834d73face34d7f1f66e1cc1e7d5ab5a503cfc26f2 164796 libpq5_8.4.10-0squeeze1_amd64.deb
923c0b6dd6b4662d23b752e6e689d470f11a7f4e4fa50e3931076eb9a083a93c 97276 libecpg6_8.4.10-0squeeze1_amd64.deb
818c68c86c6205c60930300f6814b7da592fc16cd19d332f242d775adc4448b8 263224 libecpg-dev_8.4.10-0squeeze1_amd64.deb
bea0d117b3bec15f6c7a997c71e1e76a87f9209387bd20ebafc87b7b4e34416a 33102 libecpg-compat3_8.4.10-0squeeze1_amd64.deb
e707e3b311c8552bcadd10b104090a704b28ff76e2c9d0d2e5cf5eeeaa128957 56978 libpgtypes3_8.4.10-0squeeze1_amd64.deb
3e94ea69735c93a1347a85cf9e6ce26a5ae8416353c8cf49822b8500c9941c90 5483590 postgresql-8.4_8.4.10-0squeeze1_amd64.deb
0881526afceb7b4995123c6b338b10dce50540dc6a101f9b065cddc1cc8dcc86 1530562 postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb
e897c95fbd6867e8723ebaeab190cf11e0a51ea51729a5291995046d1243c237 642276 postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb
f416fb91faeeb706bb9541154bd4c4032ab473aa2fd902ccec2ee8f4d35ee341 436238 postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb
8a3d9724a1ff0433aafe45964ed17193a1f9d96b731ee346f6da21dfeac1ba3e 62450 postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb
a6c26fc7e05457ca761f7de2462b2065425835cd35317c8834803a342aaaa293 63656 postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb
f6578c3b372e52f7ca2b864095526b7e072b12a40c2d954d236b3e82cf527a2d 48212 postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb
Files:
83edb1fc396b241ff0d6a109b663478b 2506 database optional postgresql-8.4_8.4.10-0squeeze1.dsc
c2776cf3da7923ac4af0ca5c164016ea 18157949 database optional postgresql-8.4_8.4.10.orig.tar.gz
2352f99e274e10be9783772ba94ec7e3 52659 database optional postgresql-8.4_8.4.10-0squeeze1.diff.gz
33bae55855792bcb06e21cd79ddcec66 2172840 doc optional postgresql-doc-8.4_8.4.10-0squeeze1_all.deb
536dd6428d1878b81b5d923ee25637ef 25294 database optional postgresql_8.4.10-0squeeze1_all.deb
4fe9dca6a707b03ab67545c3e671f2bf 25262 database optional postgresql-client_8.4.10-0squeeze1_all.deb
bb8fd6bede95ae8829a98780f8bc29e9 25108 doc optional postgresql-doc_8.4.10-0squeeze1_all.deb
a40fa122848f3b838a31959553940a5b 25156 database optional postgresql-contrib_8.4.10-0squeeze1_all.deb
ec77fb333865d60b66a8d4216650f6db 244180 libdevel optional libpq-dev_8.4.10-0squeeze1_amd64.deb
c2b057aa40d300b748edfe2fe6e58d82 164796 libs optional libpq5_8.4.10-0squeeze1_amd64.deb
8362f6a1fe4be7ce98407d3c1642f28b 97276 libs optional libecpg6_8.4.10-0squeeze1_amd64.deb
ef6f9cc9e042af39f07e34da8e4edf91 263224 libdevel optional libecpg-dev_8.4.10-0squeeze1_amd64.deb
8c0da0c2912712b185dabf793fa66024 33102 libs optional libecpg-compat3_8.4.10-0squeeze1_amd64.deb
c43dfc6896113b83df1a9b06d776a4e1 56978 libs optional libpgtypes3_8.4.10-0squeeze1_amd64.deb
a805783a8036658794013d511259f58d 5483590 database optional postgresql-8.4_8.4.10-0squeeze1_amd64.deb
093f9bdf353ed602fa6679feaff9344e 1530562 database optional postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb
147dfadf71b1285409b87162f3fd7c39 642276 libdevel optional postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb
76112a27c3cd5bbe043a2dd21489d28e 436238 database optional postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb
30e2016a8136194c4e01fbd1e72ff020 62450 database optional postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb
9137227ec7bee01cf3cdc4eb24d5ada5 63656 database optional postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb
3365f03edb707d339a01b0340218d00b 48212 database optional postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCAAGBQJO6v00AAoJEPmIJawmtHufebkP/iMlUx9IY9/Hbc5rb3ftrVFq
TC42S7fztoowDmhgkfxPiweO6GxB2+3qwZ9iXPdy4ZBVTHCqwnoCjnnr5trm8tC8
PEcg6C7taCi6n0o6OijzO+lSm2EXdOgt4LA8Qjz4R9xbaxXV16J8YRZqQt12ohi9
MVqdpjqQmN7kWpB22v3RNNbpE03M6/2UkNkgwP4Gc40hKLhFuzJJrJRQFFvnJz+m
3C02hS3HuCbobDAs/RjTv/Zpz8UXcHlUQpICD1EMjXYcx2APSmcsQErv0FKOjiJg
qX0FsAMjPlKMx9IRfPJCVANpj6mgYjLhsor88WCQYKIv0gphBzglssPEuwqoXUzX
VXvtoLZZ98/zHRjskS0Zv25seW4iEuSeBa5WsFpdO6ER+jJgAkrkmEPB5p7NPJWB
CyojwR2ikhkds5CHqWrIOjfBeh8kLsQvYo37jyZb8BAy1SFAE4xwDsghURoJ3ayI
hxIy/i6JFZcfTEITZxYyU3dRy5W0YW5D8jwAnJQ9m8bpB42UE/z/TJR8C3cOsdZV
XZKnIjlaM53LacHAm9ClZC6+fb+OuQuluW1nDvgXGiQF1Y8bKsJ12ZQby2LN7Nms
deGxjjsM9ytRc0KaTzc3wmxdLZhF+3sBxLjO90JvRHcwe8PwxyMANtCXIzziUevT
EAsTQqGcfBcWsKOQVTVU
=Qgce
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg-compat3_8.4.10-0squeeze1_amd64.deb
libecpg-dev_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg-dev_8.4.10-0squeeze1_amd64.deb
libecpg6_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg6_8.4.10-0squeeze1_amd64.deb
libpgtypes3_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpgtypes3_8.4.10-0squeeze1_amd64.deb
libpq-dev_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpq-dev_8.4.10-0squeeze1_amd64.deb
libpq5_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpq5_8.4.10-0squeeze1_amd64.deb
postgresql-8.4_8.4.10-0squeeze1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-0squeeze1.diff.gz
postgresql-8.4_8.4.10-0squeeze1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-0squeeze1.dsc
postgresql-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-client_8.4.10-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-client_8.4.10-0squeeze1_all.deb
postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-contrib_8.4.10-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-contrib_8.4.10-0squeeze1_all.deb
postgresql-doc-8.4_8.4.10-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.10-0squeeze1_all.deb
postgresql-doc_8.4.10-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-doc_8.4.10-0squeeze1_all.deb
postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.10-0squeeze1_amd64.deb
postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.10-0squeeze1_amd64.deb
postgresql_8.4.10-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql_8.4.10-0squeeze1_all.deb
