Accepted postgresql-8.4 8.4.12-1 (source all amd64)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Mon, 04 Jun 2012 07:18:59 +0200
Source: postgresql-8.4
Binary: 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
Architecture: source all amd64
Version: 8.4.12-1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>
Changed-By: Martin Pitt <mpitt@debian.org>
Description:
postgresql-8.4 - object-relational SQL database, version 8.4 server
postgresql-client-8.4 - front-end programs for PostgreSQL 8.4
postgresql-contrib-8.4 - additional facilities for PostgreSQL
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.12-1) unstable; urgency=medium
.
* Urgency medium due to security fixes.
* New upstream security/bug fix release:
- Fix incorrect password transformation in "contrib/pgcrypto"'s DES
crypt() function.
If a password string contained the byte value 0x80, the remainder
of the password was ignored, causing the password to be much weaker
than it appeared. With this fix, the rest of the string is properly
included in the DES hash. Any stored password values that are
affected by this bug will thus no longer match, so the stored
values may need to be updated. (CVE-2012-2143)
- Ignore SECURITY DEFINER and SET attributes for a procedural
language's call handler.
Applying such attributes to a call handler could crash the server.
(CVE-2012-2655)
- Allow numeric timezone offsets in timestamp input to be up to 16
hours away from UTC.
Some historical time zones have offsets larger than 15 hours, the
previous limit. This could result in dumped data values being
rejected during reload.
- Fix timestamp conversion to cope when the given time is exactly the
last DST transition time for the current timezone.
This oversight has been there a long time, but was not noticed
previously because most DST-using zones are presumed to have an
indefinite sequence of future DST transitions.
- Fix text to name and char to name casts to perform string
truncation correctly in multibyte encodings.
- Fix memory copying bug in to_tsquery().
- Fix planner's handling of outer PlaceHolderVars within subqueries.
This bug concerns sub-SELECTs that reference variables coming from
the nullable side of an outer join of the surrounding query. In
9.1, queries affected by this bug would fail with "ERROR:
Upper-level PlaceHolderVar found where not expected". But in 9.0
and 8.4, you'd silently get possibly-wrong answers, since the value
transmitted into the subquery wouldn't go to null when it should.
- Fix slow session startup when pg_attribute is very large.
If pg_attribute exceeds one-fourth of shared_buffers, cache
rebuilding code that is sometimes needed during session start would
trigger the synchronized-scan logic, causing it to take many times
longer than normal. The problem was particularly acute if many new
sessions were starting at once.
- Ensure sequential scans check for query cancel reasonably often.
A scan encountering many consecutive pages that contain no live
tuples would not respond to interrupts meanwhile.
- Ensure the Windows implementation of PGSemaphoreLock() clears
ImmediateInterruptOK before returning.
This oversight meant that a query-cancel interrupt received later
in the same query could be accepted at an unsafe time, with
unpredictable but not good consequences.
- Show whole-row variables safely when printing views or rules.
Corner cases involving ambiguous names (that is, the name could be
either a table or column name of the query) were printed in an
ambiguous way, risking that the view or rule would be interpreted
differently after dump and reload. Avoid the ambiguous case by
attaching a no-op cast.
- Fix "COPY FROM" to properly handle null marker strings that
correspond to invalid encoding.
A null marker string such as E'\\0' should work, and did work in
the past, but the case got broken in 8.4.
- Ensure autovacuum worker processes perform stack depth checking
properly.
Previously, infinite recursion in a function invoked by
auto-"ANALYZE" could crash worker processes.
- Fix logging collector to not lose log coherency under high load.
The collector previously could fail to reassemble large messages if
it got too busy.
- Fix logging collector to ensure it will restart file rotation after
receiving SIGHUP.
- Fix WAL replay logic for GIN indexes to not fail if the index was
subsequently dropped>
- Fix memory leak in PL/pgSQL's "RETURN NEXT" command.
- Fix PL/pgSQL's "GET DIAGNOSTICS" command when the target is the
function's first variable.
- Fix potential access off the end of memory in psql's expanded
display ("\x") mode.
- Fix several performance problems in pg_dump when the database
contains many objects.
pg_dump could get very slow if the database contained many schemas,
or if many objects are in dependency loops, or if there are many
owned sequences.
- Fix "contrib/dblink"'s dblink_exec() to not leak temporary database
connections upon error.
- Fix "contrib/dblink" to report the correct connection name in error
messages.
* debian/control: Move bzr branches to alioth, so that other members of
pkg-postgresql can commit. Update Vcs-* tags.
* debian/control: Set Maintainer: to pkg-postgresql group, and move myself
to Uploaders:.
Checksums-Sha1:
d9bad1036fcd1ec668bd4b53482f1c67548f6c94 2827 postgresql-8.4_8.4.12-1.dsc
53a17cd0f104bcad112925d3c6fc2e29e1f89c8e 18193373 postgresql-8.4_8.4.12.orig.tar.gz
d33dcf32d90dc1774d8bb30f1075fcbae486bfea 49375 postgresql-8.4_8.4.12-1.diff.gz
0e6dd55107fd59bdbf41c854e5266ad15fd6f5ce 2193622 postgresql-doc-8.4_8.4.12-1_all.deb
195a2cb7d33622cfd0d59bc1c9540249fcaa9b29 5507300 postgresql-8.4_8.4.12-1_amd64.deb
760188247343e72d76fe55fc1b7fc9e3cf72ef75 1541502 postgresql-client-8.4_8.4.12-1_amd64.deb
918e3cd448d3175c1ebc92baaf37fb8800c8991f 651740 postgresql-server-dev-8.4_8.4.12-1_amd64.deb
5e622560c13d99d755aa24c491ffea06eb4931fa 447066 postgresql-contrib-8.4_8.4.12-1_amd64.deb
35f187db45e32d925de350eb96de090944859820 71106 postgresql-plperl-8.4_8.4.12-1_amd64.deb
14782d08cdc82055cf1bd84e7a52d9d0c43f9f4c 72502 postgresql-plpython-8.4_8.4.12-1_amd64.deb
0d515bab6676d0e74a4f2156d9cfe75173becc93 57102 postgresql-pltcl-8.4_8.4.12-1_amd64.deb
Checksums-Sha256:
79104f01ec697466698cda66a8754887dcc7ac3659a07f0c7f414d610912cf88 2827 postgresql-8.4_8.4.12-1.dsc
0cd614f0f0f149d683aa1fbdefd7d873282cfdefada5a687d2644457c855d4f2 18193373 postgresql-8.4_8.4.12.orig.tar.gz
5a95b93dd2028b79bcc84597161e75c03836d8e6ac0c5e847aecb999b88f2df6 49375 postgresql-8.4_8.4.12-1.diff.gz
e909ec147b26e3da0ee976d792615bd770c58c625206fd2294ccf92ee9e88271 2193622 postgresql-doc-8.4_8.4.12-1_all.deb
88c33a3dd5c264764bd740cf6943a0d6a502ceab61cfdb43bedaaeeb9cff5eb1 5507300 postgresql-8.4_8.4.12-1_amd64.deb
bb85e35b602292ad2896f230225cfe1280823bfad24ded40fa58e4ca08df80cf 1541502 postgresql-client-8.4_8.4.12-1_amd64.deb
4d96967e24065f686722b772093bc39f8f226bb2c01a9285bffc07c9be16e3b2 651740 postgresql-server-dev-8.4_8.4.12-1_amd64.deb
01c518d74276928b1ccf82af2add4be17c2ed3f98ab7682871fc869424bfff62 447066 postgresql-contrib-8.4_8.4.12-1_amd64.deb
536534f041ecaf1d7e5814397a7be6e9f0080819850daea402b2de4760260c78 71106 postgresql-plperl-8.4_8.4.12-1_amd64.deb
495d06ec0f5cdf6e945b8073e59c6e38c10e5efcea0d97817de5819f41df9011 72502 postgresql-plpython-8.4_8.4.12-1_amd64.deb
49730c9c3fb6720cdd3bb99a47a596ad1857f91dd8e2eefb4d8e0a596e4ca17c 57102 postgresql-pltcl-8.4_8.4.12-1_amd64.deb
Files:
31a1226d9a6e78fcf2b8a35c9a44229a 2827 database optional postgresql-8.4_8.4.12-1.dsc
2e7c6e16fe19e9597e2882fe47c7d3fd 18193373 database optional postgresql-8.4_8.4.12.orig.tar.gz
d154c189625ada7d46ccaa841b1eba11 49375 database optional postgresql-8.4_8.4.12-1.diff.gz
fb07f7ccd1f9949cec9b793e7edc5bc6 2193622 doc optional postgresql-doc-8.4_8.4.12-1_all.deb
46c57a9f4b1cd5598171db34635b2fd2 5507300 database optional postgresql-8.4_8.4.12-1_amd64.deb
fedd802a8e93d9117f5fe8aefb1bc07b 1541502 database optional postgresql-client-8.4_8.4.12-1_amd64.deb
a3d25c093ca32eb0eda7de20a9c21500 651740 libdevel optional postgresql-server-dev-8.4_8.4.12-1_amd64.deb
b11020a780ad2a969f09fb7da648984b 447066 database optional postgresql-contrib-8.4_8.4.12-1_amd64.deb
dacc1505512f6bb45deb7ce452813e76 71106 database optional postgresql-plperl-8.4_8.4.12-1_amd64.deb
de6b4067a854b6503686486395327600 72502 database optional postgresql-plpython-8.4_8.4.12-1_amd64.deb
911fc4d94b1c19bdb565e601c348eff0 57102 database optional postgresql-pltcl-8.4_8.4.12-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iQIcBAEBCAAGBQJPzF8MAAoJEPmIJawmtHufOgwP/3e+34MxavTyarswrUqZhhpB
ooKHgh0i5tBcoXjHQkfbMhlxRvHAVWfeetMp6mbiAghSgNkrg0N2pixitPW+1al8
rYR9+t1w/IYmz4zzLgjpgexKY5TrFgqXqWlWTVrRClCTPTe6YMZbXYBXIZMKS4eC
E1KVGGKROpsmTRkU0M7jBtUFuhxpLbwefaju4BceqjegIW8826PHq8xYpLO2l4pS
iolqJkqRz2StcX9aKI+xKvqvKznp5xBEDHxsXc+hCFRVaPMNT1gEhErCgiR8M/RO
NMD7hDVF+lJLsORY4h90YUFSXiNY48s3uMNVybejH177J+7bIHVKGLniHYoht4SH
IOaxz4lLeRD223K+OrBIgRlufPeVw1TwF+2y6OjHZ5yqfZvTowCUlMaKF79LSE2E
1ApGDDb+FHNyWQvGIMV7o+K3lG2Jks89K0jfbPvIiVeloQXe2waNFN21Riw+bSgu
2MM1GMNyiqWnbAw8JlZ5+XX2VoyRO6+CN+z0DpH5XARdDetgWPnYvlr9a8yEArcM
i0bUXmdTa0pbuBmVa+LgmASTYLXED2PZkv1D/QaW8tJH1/krOOylemp2/Oeb7SID
BxG7Iv/twvOkidf6d3x8RMYOP5RXJNlTS70Hlntrj0FyG/b+lu1BVHcqrUCY0gao
j8xVoh+pPbuWE9qdyNiM
=HzY7
-----END PGP SIGNATURE-----
Accepted:
postgresql-8.4_8.4.12-1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.12-1.diff.gz
postgresql-8.4_8.4.12-1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.12-1.dsc
postgresql-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.12-1_amd64.deb
postgresql-8.4_8.4.12.orig.tar.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.12.orig.tar.gz
postgresql-client-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.12-1_amd64.deb
postgresql-contrib-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.12-1_amd64.deb
postgresql-doc-8.4_8.4.12-1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.12-1_all.deb
postgresql-plperl-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.12-1_amd64.deb
postgresql-plpython-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.12-1_amd64.deb
postgresql-pltcl-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.12-1_amd64.deb
postgresql-server-dev-8.4_8.4.12-1_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.12-1_amd64.deb
Reply to: