Your message dated Thu, 30 Jun 2011 01:57:26 +0000
with message-id <e1qc6vs-0001x1...@franck.debian.org>
and subject line Bug#632028: fixed in postgresql-8.4 8.4.8-0squeeze2
has caused the Debian Bug report #632028,
regarding postgresql 8.4.8 regression - failure to handle char(4) = bpchar
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.)
--
632028: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=632028
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: postgresql-8.4
Version: 8.4.8-0squeeze1
Severity: grave
Hi there,
Unfortunately this "stable" upgrade of PostgreSQL 8.4.7-0squeeze2 to
8.4.8-0squeeze1 introduced a bug apparently from the 9.0 branch that is
now consistently breaking queries on our production "stable" machines.
Upstream it's registered as bug #6020 and confirmed:
http://archives.postgresql.org/pgsql-bugs/2011-05/msg00080.php
I've told them about it again and so far they've ignored me:
http://archives.postgresql.org/pgsql-bugs/2011-06/msg00122.php
I'm filing this in Debian because the severity of the problem for us
has now gone from "possible future upgrade delay" to "WTF" :<
Anyway, this kind of a query fails under PostgreSQL 9.0.4 and 8.4.8:
SELECT * FROM acl_get_list('news', 258, 0);
ERROR: wrong record type supplied in RETURN NEXT
DETAIL: Returned type bpchar does not match expected type character(4) in
column 3.
CONTEXT: PL/pgSQL function "acl_get_list" line 9 at RETURN NEXT
Where the code is:
CREATE TYPE acl_list AS (
ugid integer,
isuser boolean,
acl_id CHAR(4)
[...]
);
CREATE OR REPLACE FUNCTION acl_get_list(CHAR(4), INTEGER, INTEGER) RETURNS
SETOF acl_list AS '
DECLARE
p_acl_id ALIAS FOR $1;
p_acl_object_id ALIAS FOR $2;
p_lev ALIAS FOR $3;
rec RECORD;
rec1 RECORD;
BEGIN
[...]
FOR rec IN SELECT * FROM acl_inherits WHERE acl_id = p_acl_id AND object_id
= p_acl_object_id LOOP
FOR rec1 IN SELECT * FROM acl_get_list(rec.parent_acl_id,
rec.parent_object_id, p_lev + 1) LOOP
RETURN NEXT rec1;
END LOOP;
END LOOP;
[...]
This worked just fine in 8.1, 8.3, earlier 8.4, and doesn't seem wrong.
Please revert this bad change ASAP...
TIA.
--
2. That which causes joy or happiness.
--- End Message ---
--- Begin Message ---
Source: postgresql-8.4
Source-Version: 8.4.8-0squeeze2
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-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libecpg-compat3_8.4.8-0squeeze2_amd64.deb
libecpg-dev_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libecpg-dev_8.4.8-0squeeze2_amd64.deb
libecpg6_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libecpg6_8.4.8-0squeeze2_amd64.deb
libpgtypes3_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libpgtypes3_8.4.8-0squeeze2_amd64.deb
libpq-dev_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libpq-dev_8.4.8-0squeeze2_amd64.deb
libpq5_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/libpq5_8.4.8-0squeeze2_amd64.deb
postgresql-8.4_8.4.8-0squeeze2.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze2.diff.gz
postgresql-8.4_8.4.8-0squeeze2.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze2.dsc
postgresql-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-client-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-client_8.4.8-0squeeze2_all.deb
to main/p/postgresql-8.4/postgresql-client_8.4.8-0squeeze2_all.deb
postgresql-contrib-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-contrib_8.4.8-0squeeze2_all.deb
to main/p/postgresql-8.4/postgresql-contrib_8.4.8-0squeeze2_all.deb
postgresql-doc-8.4_8.4.8-0squeeze2_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.8-0squeeze2_all.deb
postgresql-doc_8.4.8-0squeeze2_all.deb
to main/p/postgresql-8.4/postgresql-doc_8.4.8-0squeeze2_all.deb
postgresql-plperl-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-plpython-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-pltcl-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.8-0squeeze2_amd64.deb
postgresql-server-dev-8.4_8.4.8-0squeeze2_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.8-0squeeze2_amd64.deb
postgresql_8.4.8-0squeeze2_all.deb
to main/p/postgresql-8.4/postgresql_8.4.8-0squeeze2_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 632...@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: Wed, 29 Jun 2011 20:43:50 +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.8-0squeeze2
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: 632028
Changes:
postgresql-8.4 (8.4.8-0squeeze2) stable; urgency=low
.
* Add 15-revert-typmod-check.patch: Back out "Fix plpgsql's issues with
dropped columns in rowtypes in 8.4 branch.", which introduces a
regression. Thanks a lot to Philipp Kern for preparing the fix, and to
Josip Rodin for testing this! (Closes: #632028)
Checksums-Sha1:
5ec9be502fe2bb20b8a81bf2dc9e05ec34cb3c18 2499
postgresql-8.4_8.4.8-0squeeze2.dsc
4c0a64d924ae53affb754c01786c4ed67ae26582 48356
postgresql-8.4_8.4.8-0squeeze2.diff.gz
4cb483ed8b609499aedb9ca4f5b42cb860a9ea9f 2150248
postgresql-doc-8.4_8.4.8-0squeeze2_all.deb
9d3cea0124a2fae1efdb0582cd8b64a9bcce6b90 20734
postgresql_8.4.8-0squeeze2_all.deb
504623b31b0373b01757541407a8049fd854aeaf 20718
postgresql-client_8.4.8-0squeeze2_all.deb
76f13f894e3030904e9f4d64da6843273b9da617 20552
postgresql-doc_8.4.8-0squeeze2_all.deb
a5c525c744655ec6993444ba4492a49018812c04 20608
postgresql-contrib_8.4.8-0squeeze2_all.deb
0a4af4ac71af048e78f431ab929285e507a5a813 238072
libpq-dev_8.4.8-0squeeze2_amd64.deb
0d62add088fffc2cf69947e1a11b44e7690cc5cf 153858
libpq5_8.4.8-0squeeze2_amd64.deb
376a7f3b2a51fb0670c864b70535a0e677d95feb 90036
libecpg6_8.4.8-0squeeze2_amd64.deb
ccd137ad39dd695acea2f5acfcedb26a12ca5d6d 259072
libecpg-dev_8.4.8-0squeeze2_amd64.deb
b383857f5773d2a3c2d9cefe2be350bf46c54a59 28610
libecpg-compat3_8.4.8-0squeeze2_amd64.deb
8328893071ce30a2c520ffeee00150e5ebf0c199 52500
libpgtypes3_8.4.8-0squeeze2_amd64.deb
761f9fa216f3d524ad5f3a75eed3854be323e83b 5338670
postgresql-8.4_8.4.8-0squeeze2_amd64.deb
65a4f68e33e4219142c827139e27730136ddb0ad 1473350
postgresql-client-8.4_8.4.8-0squeeze2_amd64.deb
13c5e4db1e64d96742bbede29834de06104f9df0 640500
postgresql-server-dev-8.4_8.4.8-0squeeze2_amd64.deb
208bc5af36066594780aafc3f2af121a3a8b4e68 430910
postgresql-contrib-8.4_8.4.8-0squeeze2_amd64.deb
821f1d751a12d875e80b84a8bbe3ce284bbec616 57046
postgresql-plperl-8.4_8.4.8-0squeeze2_amd64.deb
3d47448b24a8c627b157d8207a130714db1a09e5 57226
postgresql-plpython-8.4_8.4.8-0squeeze2_amd64.deb
560f3950c17b7a09f82ef2d0b811c053b9273a51 43298
postgresql-pltcl-8.4_8.4.8-0squeeze2_amd64.deb
Checksums-Sha256:
ce30d1875a4d3802647cfe1753ade751be8e441b3de93c2f5e93a4df085d52a3 2499
postgresql-8.4_8.4.8-0squeeze2.dsc
edecb3c046425897d0a6ef2434949a5d865cefc39c2a58eda6546ae92dfcfc11 48356
postgresql-8.4_8.4.8-0squeeze2.diff.gz
e642bfe09f88f5a69e71d26494b3e20b61e6c93c82df9291fb882689982940fe 2150248
postgresql-doc-8.4_8.4.8-0squeeze2_all.deb
e01ab86928c7b5e6359c143ee3ae050da28ed8ae53627b95da048d3ca993e43c 20734
postgresql_8.4.8-0squeeze2_all.deb
2075b3768fa36129296b3a4307234dc4525025abeb84205e2f0f5ce76e12c563 20718
postgresql-client_8.4.8-0squeeze2_all.deb
ccd30f14f7a5e844e2e04a7a90e16a47095c88ef210bd6907beea2775677cd15 20552
postgresql-doc_8.4.8-0squeeze2_all.deb
95180f3ff4ea5875cef538800ddfdfd9710f86f6eb32cdf7cebdb65cd8bdd76f 20608
postgresql-contrib_8.4.8-0squeeze2_all.deb
375dfb8345b0076e7aa718f171ce2a3f0ee0fe9a7eae6b021b512983757827a0 238072
libpq-dev_8.4.8-0squeeze2_amd64.deb
7ed8736ed17d078bee2780f8582dd986b9cd5bf428d541113e919e2ed485cf96 153858
libpq5_8.4.8-0squeeze2_amd64.deb
eb8f057fb0b78ca4f18678fee4f3fdf68947d948540d9a7b60580a9c6a563c22 90036
libecpg6_8.4.8-0squeeze2_amd64.deb
676e1ecf4333211e71c4752e24c90b28de8ee69852fb6c4a78311a7eff089625 259072
libecpg-dev_8.4.8-0squeeze2_amd64.deb
94cc5d02b7fc6a853329d73b812652bef780bbe334a7d654238aec608d5bee58 28610
libecpg-compat3_8.4.8-0squeeze2_amd64.deb
b5794061def70dd7a06c0756cd1069f1df6a81f4bcf3a41cf6551757f123d9f8 52500
libpgtypes3_8.4.8-0squeeze2_amd64.deb
c5395d9b50983318db371152b459e041ac471c6d708ce76ba12495520aa77db4 5338670
postgresql-8.4_8.4.8-0squeeze2_amd64.deb
727614e936285e84cb1d2b3bb7cf39433476aa30df511f241ef2282a715366fb 1473350
postgresql-client-8.4_8.4.8-0squeeze2_amd64.deb
88e0da81f8abc3f35def27ba58b1685acd00fc5a81e87b9b9f5b42962314ef05 640500
postgresql-server-dev-8.4_8.4.8-0squeeze2_amd64.deb
908e660c49af74c03b483f614375da7620836e85fe34bb315ef81e4b3e57aaa3 430910
postgresql-contrib-8.4_8.4.8-0squeeze2_amd64.deb
9a555ff3edbf40f413d97f73ed70785b511e0a0b83bdcd4fd7be618702fd58d0 57046
postgresql-plperl-8.4_8.4.8-0squeeze2_amd64.deb
454dc85ee2230150c80bcc99d9b6b12d030fb98f53708e130886c62535b6c85d 57226
postgresql-plpython-8.4_8.4.8-0squeeze2_amd64.deb
d3e31c74ed48ccadc34d061cf2cdeb844b66fb45d2074ca5c9b41764d71841cd 43298
postgresql-pltcl-8.4_8.4.8-0squeeze2_amd64.deb
Files:
4b8f81787bfafdee4d546e46e32e817a 2499 database optional
postgresql-8.4_8.4.8-0squeeze2.dsc
0d26a85b906ebf6f140adc279e1af73b 48356 database optional
postgresql-8.4_8.4.8-0squeeze2.diff.gz
ca1c3f9e9be64b5724967eb15de7d776 2150248 doc optional
postgresql-doc-8.4_8.4.8-0squeeze2_all.deb
72571a4dae4b891870a2abdd2df6a0ac 20734 database optional
postgresql_8.4.8-0squeeze2_all.deb
e73a8f424bc46ca4c758177fcc791bb9 20718 database optional
postgresql-client_8.4.8-0squeeze2_all.deb
ba77947f390ae248933da15bf8f42f04 20552 doc optional
postgresql-doc_8.4.8-0squeeze2_all.deb
09b3aafaa3edacea4523f74c6f63da60 20608 database optional
postgresql-contrib_8.4.8-0squeeze2_all.deb
17b8677c71ebf14558d49ad1b2c174e9 238072 libdevel optional
libpq-dev_8.4.8-0squeeze2_amd64.deb
ac636efdbbd1f5069ce61316f605722b 153858 libs optional
libpq5_8.4.8-0squeeze2_amd64.deb
42f245c12e8943b6dc5f2e6b5f346b58 90036 libs optional
libecpg6_8.4.8-0squeeze2_amd64.deb
acd6a62dad2bff60d00e45b7d02e134b 259072 libdevel optional
libecpg-dev_8.4.8-0squeeze2_amd64.deb
741b7dfcffc946050cb0b710de1f8b41 28610 libs optional
libecpg-compat3_8.4.8-0squeeze2_amd64.deb
1fe1e637a730d00c3fa0bef6594cf60b 52500 libs optional
libpgtypes3_8.4.8-0squeeze2_amd64.deb
d53202f66798c8df238610cbdad0e88d 5338670 database optional
postgresql-8.4_8.4.8-0squeeze2_amd64.deb
8f992973d20663e5d2edfe4cb642b1c8 1473350 database optional
postgresql-client-8.4_8.4.8-0squeeze2_amd64.deb
341ae0edad9892455f096034575eac84 640500 libdevel optional
postgresql-server-dev-8.4_8.4.8-0squeeze2_amd64.deb
40f72ba5ba6eb5a46504a46fa3b85cec 430910 database optional
postgresql-contrib-8.4_8.4.8-0squeeze2_amd64.deb
21c8379f66996757929cf3d14db65625 57046 database optional
postgresql-plperl-8.4_8.4.8-0squeeze2_amd64.deb
9dd2b3b54c3603bbad78789f6af9ae78 57226 database optional
postgresql-plpython-8.4_8.4.8-0squeeze2_amd64.deb
4bf170061cd1bfb18167819e7c331426 43298 database optional
postgresql-pltcl-8.4_8.4.8-0squeeze2_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCAAGBQJOC4PIAAoJEPmIJawmtHufCQUQAJUz3719A7Txi4IcHfXfMYMd
kIfWWVG5Iiq3bd6fqSlPJOzVI3THHi3Xt2OJLCb2iwIoIRAjxOdJU6vGHbKZk3tQ
EvdshPwGn3tbie4jLVoBl8r9c14avX/RWejF0iIbamBRx4OaY8mswMQQb1Ho57L8
JkMRkiVg/1O7Ot2fxqzeyr0F7Izln4us7JdH8wpofveNEzJF1ZNj2q2dKYpZslmJ
+MVQSC8J2LnSgDk350JPV3qjz8xangHyuZcM8CtU+vgRxZ4uXwwXUNjpuTl6A8G/
I9Q9NUOSyCr+WuAgeDCvA4wTI9UozFaFO8jMHmmIK34h0Xvj9u+MAd6lizZ/m1N0
rOLK8vdCbiSG6HO1pZGqev133o7vOy3YwAZT5QfiTlCz5ix9P29YyKORIlzbOSiK
wmfFVFxWvQqtF2fUZWoXw4Cvqsr4zvO0CSJ/zKP6axMaGx0XttHVpycgYOzwGv7f
UGXhUN7z1E79qUGt8bVYy+PiPgZotarEFQMSeJIChUn2fa+VSx/hu6TRxowlVPWf
+lwDOkS46KrqKfj4Fz9OwFBkBAqmlOJwR/LVkPu+i6kO3LH1XJVEUheqjI0RVkfM
lU3QzCtEsDHUdyZ32mhNc9yutY0mNXhrWGxM89DOjqSLsAbA6FTnmss96cQegwBG
FJlcXCg0tlOHvKho4Gf/
=XAgl
-----END PGP SIGNATURE-----
--- End Message ---
