Your message dated Thu, 02 Jun 2011 01:52:26 +0000
with message-id <e1qrx5g-0002ot...@franck.debian.org>
and subject line Bug#626559: fixed in postgresql-8.4 8.4.8-0squeeze1
has caused the Debian Bug report #626559,
regarding postgresql-8.4: pg_upgrade_fix/8.4.8 needed for stable/squeeze
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
626559: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=626559
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: postgresql-8.4
Version: 8.4.7-0squeeze2
Severity: critical
Tags: squeeze
Justification: causes serious data loss
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
8.4.8 (or a backport of the fix) should be included in stable-updates.
--- End Message ---
--- Begin Message ---
Source: postgresql-8.4
Source-Version: 8.4.8-0squeeze1
We believe that the bug you reported is fixed in the latest version of
postgresql-8.4, which is due to be installed in the Debian FTP archive:
libecpg-compat3_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg-compat3_8.4.8-0squeeze1_amd64.deb
libecpg-dev_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg-dev_8.4.8-0squeeze1_amd64.deb
libecpg6_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libecpg6_8.4.8-0squeeze1_amd64.deb
libpgtypes3_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpgtypes3_8.4.8-0squeeze1_amd64.deb
libpq-dev_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpq-dev_8.4.8-0squeeze1_amd64.deb
libpq5_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/libpq5_8.4.8-0squeeze1_amd64.deb
postgresql-8.4_8.4.8-0squeeze1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze1.diff.gz
postgresql-8.4_8.4.8-0squeeze1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze1.dsc
postgresql-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-client-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-client_8.4.8-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-client_8.4.8-0squeeze1_all.deb
postgresql-contrib-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-contrib_8.4.8-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-contrib_8.4.8-0squeeze1_all.deb
postgresql-doc-8.4_8.4.8-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.8-0squeeze1_all.deb
postgresql-doc_8.4.8-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql-doc_8.4.8-0squeeze1_all.deb
postgresql-plperl-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-plpython-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-pltcl-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.8-0squeeze1_amd64.deb
postgresql-server-dev-8.4_8.4.8-0squeeze1_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.8-0squeeze1_amd64.deb
postgresql_8.4.8-0squeeze1_all.deb
to main/p/postgresql-8.4/postgresql_8.4.8-0squeeze1_all.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 626...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Martin Pitt <mp...@debian.org> (supplier of updated postgresql-8.4 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Sun, 22 May 2011 15:12:47 +0200
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.8-0squeeze1
Distribution: stable
Urgency: low
Maintainer: Martin Pitt <mp...@debian.org>
Changed-By: Martin Pitt <mp...@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
Closes: 616180 626559
Changes:
postgresql-8.4 (8.4.8-0squeeze1) stable; urgency=low
.
* New upstream bug fix release: (Closes: #626559)
- If your installation was upgraded from a previous major release by
running pg_upgrade, you should take action to prevent possible data loss
due to a now-fixed bug in pg_upgrade. The recommended solution is to run
"VACUUM FREEZE" on all TOAST tables. More information is available at
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix.
- Fix pg_upgrade's handling of TOAST tables.
This error poses a significant risk of data loss for installations
that have been upgraded with pg_upgrade. This patch corrects the
problem for future uses of pg_upgrade, but does not in itself cure
the issue in installations that have been processed with a buggy
version of pg_upgrade.
- Suppress incorrect "PD_ALL_VISIBLE flag was incorrectly set"
warning.
- Disallow including a composite type in itself.
- Avoid potential deadlock during catalog cache initialization.
- Fix dangling-pointer problem in BEFORE ROW UPDATE trigger handling
when there was a concurrent update to the target tuple.
- Disallow "DROP TABLE" when there are pending deferred trigger
events for the table.
Formerly the "DROP" would go through, leading to "could not open
relation with OID nnn" errors when the triggers were eventually
fired.
- Prevent crash triggered by constant-false WHERE conditions during
GEQO optimization.
- Improve planner's handling of semi-join and anti-join cases.
- Fix selectivity estimation for text search to account for NULLs.
- Improve PL/pgSQL's ability to handle row types with dropped columns.
- Fix PL/Python memory leak involving array slices.
- Fix pg_restore to cope with long lines (over 1KB) in TOC files.
- Put in more safeguards against crashing due to division-by-zero
with overly enthusiastic compiler optimization. (Closes: #616180)
Checksums-Sha1:
d036dd7e8af5564ffbcb22324d207a2a7cd85ca2 2499
postgresql-8.4_8.4.8-0squeeze1.dsc
2f9fd441098753f9ccaef8cffbd596e40afea379 17658079
postgresql-8.4_8.4.8.orig.tar.gz
d0ccf1466ec88b106cf6b4f5d3388a4b23d2463a 42103
postgresql-8.4_8.4.8-0squeeze1.diff.gz
a7ed37c59a9ad9eba83af0584cc97249de903214 2150136
postgresql-doc-8.4_8.4.8-0squeeze1_all.deb
f5fb47feaa05f602ccf194f0358f6501b6faaf27 20526
postgresql_8.4.8-0squeeze1_all.deb
8c9a97a0f5d4490c990d0ba36d0854d5b2b84d09 20494
postgresql-client_8.4.8-0squeeze1_all.deb
694a0c521d305d81c772fb71f7f15daed4ca872c 20330
postgresql-doc_8.4.8-0squeeze1_all.deb
859ebe3e64be0f4cfb87d6fc73ac6d76101ee73d 20390
postgresql-contrib_8.4.8-0squeeze1_all.deb
0edc966c52c14a50341484b048f9714052e28c3c 237876
libpq-dev_8.4.8-0squeeze1_amd64.deb
0a52560d268e07260e8afda17dff799bef54284f 153690
libpq5_8.4.8-0squeeze1_amd64.deb
16a28a57c70eb99ebe6ba549f78b1fb0b5b23407 89868
libecpg6_8.4.8-0squeeze1_amd64.deb
6ffe6410a6d61c3db0f3f531d6d345e805638f6b 258948
libecpg-dev_8.4.8-0squeeze1_amd64.deb
2da54abc405d7da33730704fa416624e25f86a32 28452
libecpg-compat3_8.4.8-0squeeze1_amd64.deb
633b8e4823e56b3b47c1c3c0f094fec1c89bd806 52334
libpgtypes3_8.4.8-0squeeze1_amd64.deb
6a13794583b0099a90b1ac0eb28bb5d19e487e4e 5339164
postgresql-8.4_8.4.8-0squeeze1_amd64.deb
5164d967048d6a10cbfbef2f349fb35cd60f02ff 1473350
postgresql-client-8.4_8.4.8-0squeeze1_amd64.deb
a9b122fda53d1474e2c21350875169165a08b3b6 640710
postgresql-server-dev-8.4_8.4.8-0squeeze1_amd64.deb
094afc607c556e4680fc09a5144812cbca22679f 430754
postgresql-contrib-8.4_8.4.8-0squeeze1_amd64.deb
046a580e8abce2eb539164fce4ec2d6e77c93282 56880
postgresql-plperl-8.4_8.4.8-0squeeze1_amd64.deb
efcc60ae8cc396a6158bc1340b4db86be325739c 57072
postgresql-plpython-8.4_8.4.8-0squeeze1_amd64.deb
7f2966b0b6be3970b3f894a9d1511258c3af8705 43138
postgresql-pltcl-8.4_8.4.8-0squeeze1_amd64.deb
Checksums-Sha256:
6ee31160a418053d14aba2706a9b2515c4f5f287cd381faf7bec13984a9d693c 2499
postgresql-8.4_8.4.8-0squeeze1.dsc
774c0d1f06a216d9534e3724630a96b063009ad1f4ece3fa92ce1f26457bfea4 17658079
postgresql-8.4_8.4.8.orig.tar.gz
e33a037d17bd3c87ef1212d09a2afaba458f6a0dcc913d946d094914726c54c6 42103
postgresql-8.4_8.4.8-0squeeze1.diff.gz
4fbebd016dd92e9156f723470472191845e5cc50b021bdd0d5cf391f79387dd6 2150136
postgresql-doc-8.4_8.4.8-0squeeze1_all.deb
4714e2ac88b7df4319a08987ad9aea99dc91df7650cd39a5c7416f326746eb4b 20526
postgresql_8.4.8-0squeeze1_all.deb
09788f103e2c4aa91db0f14c46de9269d10dd8bc5db9c6fa10e4819ce012c4be 20494
postgresql-client_8.4.8-0squeeze1_all.deb
6360dfb0a0fdd1b29bab71f2288963c4010f5ccaaf79a164b10a301e7701c531 20330
postgresql-doc_8.4.8-0squeeze1_all.deb
858488a936a0f4914b84b62005fe0b9efb11fb8bb7c42353a21978ca8cacb6b3 20390
postgresql-contrib_8.4.8-0squeeze1_all.deb
6bb11525891a3d655938419b25be8fde0d7153a93f36096c3c68197103ec918f 237876
libpq-dev_8.4.8-0squeeze1_amd64.deb
5bdfca49e236c86616150503fe853f7b9d3206d4493ecf56a49cb004c0f7da77 153690
libpq5_8.4.8-0squeeze1_amd64.deb
fbf09f9187ce079cadca82f5a438c45535f9366874e65fb2c3e2d5868d29ef89 89868
libecpg6_8.4.8-0squeeze1_amd64.deb
d10dfad2082dc89033f57a6ca3f7f27883df4506fbe5332f9a6c51425e5e849e 258948
libecpg-dev_8.4.8-0squeeze1_amd64.deb
0e21fd56f61ce101dc9fbc79b5f937ae6bac21a82e8f847d6245136ddbf9e8fd 28452
libecpg-compat3_8.4.8-0squeeze1_amd64.deb
a9a0aa39b038b8912dd4396361f3f024e375eb93c7ef2de8d051bbecd6d5ac35 52334
libpgtypes3_8.4.8-0squeeze1_amd64.deb
d67f67d8170c37450f624677d4209195784f33dd46aaf5c92035d3406663fe24 5339164
postgresql-8.4_8.4.8-0squeeze1_amd64.deb
420e5a4fdede2b10202fa568aa5049d1c69455c5a0e89f78c11ae3374a3ccf32 1473350
postgresql-client-8.4_8.4.8-0squeeze1_amd64.deb
b4be4c9a96e371b9a5c878b954f38ee163ed99168397afd786f11ae1a45a42b2 640710
postgresql-server-dev-8.4_8.4.8-0squeeze1_amd64.deb
aa1fd8211381c430ca89c8a4ce630a2b53ef6b9b0fff559d058f6f1df463a00a 430754
postgresql-contrib-8.4_8.4.8-0squeeze1_amd64.deb
cf7913c35e646ee4174bfa2a894f176f2b436487598a19417ef7fc1da396b593 56880
postgresql-plperl-8.4_8.4.8-0squeeze1_amd64.deb
fe1ef10a4c2b138a5527bde7424c902ccdee12e6eabeca0536b3f8814606c95e 57072
postgresql-plpython-8.4_8.4.8-0squeeze1_amd64.deb
9eabc6883af65c2d2035722e49798b229fda5f694e7064b2e48cec6e1450000b 43138
postgresql-pltcl-8.4_8.4.8-0squeeze1_amd64.deb
Files:
e53eeccfcfa202cd6cd298979916fb1a 2499 database optional
postgresql-8.4_8.4.8-0squeeze1.dsc
a387ef3727e62b6e082fd2dd02d7a374 17658079 database optional
postgresql-8.4_8.4.8.orig.tar.gz
546b7f182c233d84f5570772894145cd 42103 database optional
postgresql-8.4_8.4.8-0squeeze1.diff.gz
e76385f3ebef078738a6e9baf6374cd3 2150136 doc optional
postgresql-doc-8.4_8.4.8-0squeeze1_all.deb
7c42c31354b8975b8d6830416c5f344c 20526 database optional
postgresql_8.4.8-0squeeze1_all.deb
e776870c9a82092a1985d22b7948af69 20494 database optional
postgresql-client_8.4.8-0squeeze1_all.deb
2289cd6ccf639b0b2de1299909260d3d 20330 doc optional
postgresql-doc_8.4.8-0squeeze1_all.deb
5ffc0193a70cbac358fa23daee9e9a7e 20390 database optional
postgresql-contrib_8.4.8-0squeeze1_all.deb
0af05a635447a39d523d68f73ed52094 237876 libdevel optional
libpq-dev_8.4.8-0squeeze1_amd64.deb
3498eac7f4357f07a1e057b0516951f4 153690 libs optional
libpq5_8.4.8-0squeeze1_amd64.deb
21672bf80d453c44c00e93ce439abb2c 89868 libs optional
libecpg6_8.4.8-0squeeze1_amd64.deb
3e6fc4725e7e55fc45c2c87de263c369 258948 libdevel optional
libecpg-dev_8.4.8-0squeeze1_amd64.deb
0d48caeb6a8aea2489ad367b779a81ae 28452 libs optional
libecpg-compat3_8.4.8-0squeeze1_amd64.deb
7e3bb7c8ae51c16af5ef9d00831ded60 52334 libs optional
libpgtypes3_8.4.8-0squeeze1_amd64.deb
72cc79e709fce76e26a153789e4674bc 5339164 database optional
postgresql-8.4_8.4.8-0squeeze1_amd64.deb
0e33ede498769ee69ce09f39b0385cdf 1473350 database optional
postgresql-client-8.4_8.4.8-0squeeze1_amd64.deb
753aa2b683a8a6043aca1b7ebf12cf85 640710 libdevel optional
postgresql-server-dev-8.4_8.4.8-0squeeze1_amd64.deb
e5765252be5db8b98e1cc1e427dfbb54 430754 database optional
postgresql-contrib-8.4_8.4.8-0squeeze1_amd64.deb
617c3e68ab4afa0b8a70807bea0cac2a 56880 database optional
postgresql-plperl-8.4_8.4.8-0squeeze1_amd64.deb
953b525c7712138ab62c37efdef91fbb 57072 database optional
postgresql-plpython-8.4_8.4.8-0squeeze1_amd64.deb
c82e7f5ff5c82720203839a40a6bbaea 43138 database optional
postgresql-pltcl-8.4_8.4.8-0squeeze1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCAAGBQJN2RBKAAoJEPmIJawmtHufv9kQAJ8nQpqDvYdkEkY0ZsZnyVf8
xKGjgaBcYS2mOaJ/L6ajGOnVNiqbqZqi7Cbgd3UZeLvNr9ttJkUFmwh8Tu2cUGn2
Zqb7IkQyzAyt9kru8fvY5n8vVtBEYUsZ3NINoUh+lecDPnYCR2inwLkw3uCRmkLb
X+TMqU6pSdvCMxBpRXwxPpb33LRyi5X3TSXsFbt0PpC7w7y+2q5Zk09Aj2fKl7Ms
6UltTr/lxsB1OADL0IAa2cyQfQ0g4t+T+d7C+CKmBbza1CGEjS2BiB+kArzMKRzs
GBkrlnu+d59kOIoGSEpYXFIqMP7z7cz2BtJNny3qhri5qkQBfIPxxv1eCME5Q/qW
u0N/DqfMU5Ob+8YOXQLlg1bgu8t+Z7dStEnc2Y+yO/26EFcEkOJp0u5bfV8Jn7KN
81McAXl8YS/xlr8PXZ1C/hUBSt5/xdbNK5l1oK/OQMuQ/Qjw3QWCfNKBvsMIfVK8
XahlHl8iWf8Z4re/JAj+2xHaiZIWVEl2X2qRQVSv2B67FQB3xc2Slf79wau0x1a3
yOQDSRFqoU4ZjTLwKatxMFE9F4pjeV7rI15ReReM0I5SPXL+apwxMnjOxKE8eZt9
rU4rnklbwyNANLv7yVqf7uIAzD8dJZlYgSLYBzOzHfmXyIyseVw6mHELVa0ZJLU9
dinsY/lIQbFfRFFNyqme
=3phm
-----END PGP SIGNATURE-----
--- End Message ---
