Accepted postgresql-8.4 8.4.5-1~bpo50+1 (source all powerpc)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Sun, 10 Oct 2010 11:55:21 +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 powerpc
Version: 8.4.5-1~bpo50+1
Distribution: lenny-backports
Urgency: medium
Maintainer: Martin Pitt <mpitt@debian.org>
Changed-By: Gerfried Fuchs <rhonda@debian.at>
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.5-1~bpo50+1) lenny-backports; urgency=low
.
* Rebuild for lenny-backports.
.
postgresql-8.4 (8.4.5-1) unstable; urgency=medium
.
* Urgency medium, since this fixes a security bug (but also a lot of other
bugs, it's not a pinpointed patch).
* New upstream security/bug fix update:
- Use a separate interpreter for each calling SQL userid in PL/Perl
and PL/Tcl.
This change prevents security problems that can be caused by
subverting Perl or Tcl code that will be executed later in the same
session under another SQL user identity (for example, within a
SECURITY DEFINER function). Most scripting languages offer numerous
ways that that might be done, such as redefining standard functions
or operators called by the target function. Without this change,
any SQL user with Perl or Tcl language usage rights can do
essentially anything with the SQL privileges of the target
function's owner.
The cost of this change is that intentional communication among
Perl and Tcl functions becomes more difficult. To provide an escape
hatch, PL/PerlU and PL/TclU functions continue to use only one
interpreter per session. This is not considered a security issue
since all such functions execute at the trust level of a database
superuser already.
It is likely that third-party procedural languages that claim to
offer trusted execution have similar security issues. We advise
contacting the authors of any PL you are depending on for
security-critical purposes.
Our thanks to Tim Bunce for pointing out this issue
(CVE-2010-3433).
- Prevent possible crashes in pg_get_expr() by disallowing it from
being called with an argument that is not one of the system catalog
columns it's intended to be used with.
- Fix incorrect placement of placeholder evaluation.
This bug could result in query outputs being non-null when they
should be null, in cases where the inner side of an outer join is a
sub-select with non-strict expressions in its output list.
- Fix possible duplicate scans of UNION ALL member relations.
- Fix "cannot handle unplanned sub-select" error.
This occurred when a sub-select contains a join alias reference
that expands into an expression containing another sub-select.
- Fix mishandling of whole-row Vars that reference a view or
sub-select and appear within a nested sub-select.
- Fix mishandling of cross-type IN comparisons.
This could result in failures if the planner tried to implement an
IN join with a sort-then-unique-then-plain-join plan.
- Fix computation of "ANALYZE" statistics for tsvector columns.
The original coding could produce incorrect statistics, leading to
poor plan choices later.
- Improve planner's estimate of memory used by array_agg(),
string_agg(), and similar aggregate functions.
The previous drastic underestimate could lead to out-of-memory
failures due to inappropriate choice of a hash-aggregation plan.
- Fix failure to mark cached plans as transient.
If a plan is prepared while "CREATE INDEX CONCURRENTLY" is in
progress for one of the referenced tables, it is supposed to be
re-planned once the index is ready for use. This was not happening
reliably.
- Reduce PANIC to ERROR in some occasionally-reported btree failure
cases, and provide additional detail in the resulting error
messages.
This should improve the system's robustness with corrupted indexes.
- Fix incorrect search logic for partial-match queries with GIN
indexes.
Cases involving AND/OR combination of several GIN index conditions
didn't always give the right answer, and were sometimes much slower
than necessary.
- Prevent show_session_authorization() from crashing within
autovacuum processes.
- Defend against functions returning setof record where not all the
returned rows are actually of the same rowtype.
- Fix possible corruption of pending trigger event lists during
subtransaction rollback.
This could lead to a crash or incorrect firing of triggers.
- Fix possible failure when hashing a pass-by-reference function
result.
- Improve merge join's handling of NULLs in the join columns.
A merge join can now stop entirely upon reaching the first NULL, if
the sort order is such that NULLs sort high.
- Take care to fsync the contents of lockfiles (both "postmaster.pid"
and the socket lockfile) while writing them.
This omission could result in corrupted lockfile contents if the
machine crashes shortly after postmaster start. That could in turn
prevent subsequent attempts to start the postmaster from
succeeding, until the lockfile is manually removed.
- Avoid recursion while assigning XIDs to heavily-nested
subtransactions.
The original coding could result in a crash if there was limited
stack space.
- Avoid holding open old WAL segments in the walwriter process.
The previous coding would prevent removal of no-longer-needed
segments.
- Fix log_line_prefix's %i escape, which could produce junk early in
backend startup.
- Prevent misinterpretation of partially-specified relation options
for TOAST tables.
In particular, fillfactor would be read as zero if any other
reloption had been set for the table, leading to serious bloat.
- Fix inheritance count tracking in "ALTER TABLE ... ADD CONSTRAINT"
- Fix possible data corruption in "ALTER TABLE ... SET TABLESPACE"
when archiving is enabled.
- Allow "CREATE DATABASE" and "ALTER DATABASE ... SET TABLESPACE" to
be interrupted by query-cancel.
- Improve "CREATE INDEX"'s checking of whether proposed index
expressions are immutable.
- Fix "REASSIGN OWNED" to handle operator classes and families.
- Fix possible core dump when comparing two empty tsquery values.
- Fix LIKE's handling of patterns containing % followed by _.
We've fixed this before, but there were still some
incorrectly-handled cases.
- Re-allow input of Julian dates prior to 0001-01-01 AD.
Input such as 'J100000'::date worked before 8.4, but was
unintentionally broken by added error-checking.
- Fix PL/pgSQL to throw an error, not crash, if a cursor is closed
within a FOR loop that is iterating over that cursor.
- In PL/Python, defend against null pointer results from
PyCObject_AsVoidPtr and PyCObject_FromVoidPtr.
- In libpq, fix full SSL certificate verification for the case where
both host and hostaddr are specified.
- Make psql recognize "DISCARD ALL" as a command that should not be
encased in a transaction block in autocommit-off mode.
- Fix some issues in pg_dump's handling of SQL/MED objects.
Notably, pg_dump would always fail if run by a non-superuser, which
was not intended.
- Improve pg_dump and pg_restore's handling of non-seekable archive
files.
This is important for proper functioning of parallel restore.
- Improve parallel pg_restore's ability to cope with selective
restore (-L option).
The original code tended to fail if the -L file commanded a
non-default restore ordering.
- Fix ecpg to process data from RETURNING clauses correctly.
- Fix some memory leaks in ecpg.
- Improve "contrib/dblink"'s handling of tables containing dropped
columns.
- Fix connection leak after "duplicate connection name" errors in
"contrib/dblink".
- Fix "contrib/dblink" to handle connection names longer than 62
bytes correctly.
- Add hstore(text, text) function to "contrib/hstore".
This function is the recommended substitute for the now-deprecated
=> operator. It was back-patched so that future-proofed code can be
used with older server versions. Note that the patch will be
effective only after "contrib/hstore" is installed or reinstalled
in a particular database. Users might prefer to execute the "CREATE
FUNCTION" command by hand, instead.
- Update build infrastructure and documentation to reflect the source
code repository's move from CVS to Git.
* debian/postgresql-8.4.preinst: Add missing debhelper token.
* debian/control: Bump Standards-Version to 3.9.1 (no changes necessary).
Checksums-Sha1:
b4f0ace62c0523c3d28d94438a6c7fe192c142a0 2221 postgresql-8.4_8.4.5-1~bpo50+1.dsc
060284275c11bd8c4a8b7ff1ab49e5a00999b08b 38990 postgresql-8.4_8.4.5-1~bpo50+1.diff.gz
17b83944d892f3e592c615184e41d720239ba596 17590296 postgresql-8.4_8.4.5.orig.tar.gz
0fc4092692f0e36fe7f05fa6813a99dfc3ff5161 1910140 postgresql-doc-8.4_8.4.5-1~bpo50+1_all.deb
5d0b423732dbf74acd2cd86980af445bf2c6ef0d 18178 postgresql_8.4.5-1~bpo50+1_all.deb
7a409ab85eb1abbf7d0e7679bc33ff421f210b78 18146 postgresql-client_8.4.5-1~bpo50+1_all.deb
5e62268e0755d66f529bd4308b1f8551615c915f 17986 postgresql-doc_8.4.5-1~bpo50+1_all.deb
9df00cd4b119c994874b38c538c5afdd3079ede4 18046 postgresql-contrib_8.4.5-1~bpo50+1_all.deb
fefe7c148a1184265c7d66515e1011760d4a67e0 232332 libpq-dev_8.4.5-1~bpo50+1_powerpc.deb
0f79f92a1a7d3b78d386b0fa02f162b6fb8e2c71 145998 libpq5_8.4.5-1~bpo50+1_powerpc.deb
4b1a6663fd3916c791240bf9850fdf6ed1dd0fe6 86812 libecpg6_8.4.5-1~bpo50+1_powerpc.deb
e0fd5d69ce03245ecde48ef4bfe381b9b3fa5b55 253546 libecpg-dev_8.4.5-1~bpo50+1_powerpc.deb
1975669f8aa32efeb766bad4eec2d7429887df25 25762 libecpg-compat3_8.4.5-1~bpo50+1_powerpc.deb
ba7e1f34c279acd06c8425cd395a6f3ebf54688c 52232 libpgtypes3_8.4.5-1~bpo50+1_powerpc.deb
0f941e6ad8dc1970b164f9e4082425f3bd6759d5 5697478 postgresql-8.4_8.4.5-1~bpo50+1_powerpc.deb
dcd4eb324c8522e0332b3d5f1edb44ab9eb9009b 1493368 postgresql-client-8.4_8.4.5-1~bpo50+1_powerpc.deb
f2e38f2d1a27302642daedba2ec86118415923d7 632940 postgresql-server-dev-8.4_8.4.5-1~bpo50+1_powerpc.deb
613a6045672259da91c19be04761f00c092fddee 477696 postgresql-contrib-8.4_8.4.5-1~bpo50+1_powerpc.deb
34e9c1691813b1548213d070d1b08e35f48532e8 55532 postgresql-plperl-8.4_8.4.5-1~bpo50+1_powerpc.deb
618d83bb327ff4a97ebb15f8cd32c41e30cefcfa 56446 postgresql-plpython-8.4_8.4.5-1~bpo50+1_powerpc.deb
b739726995309c53e8637b6d1f439f0c98e1ea5a 42682 postgresql-pltcl-8.4_8.4.5-1~bpo50+1_powerpc.deb
Checksums-Sha256:
de29bc4174227791494a21b58fd5e99d6521139a07b4cc5bc96d3fa662e49fd0 2221 postgresql-8.4_8.4.5-1~bpo50+1.dsc
36396ca939b4a0013216d6c71c7bdcb39f5aa02164b7cc180701b02484560c1f 38990 postgresql-8.4_8.4.5-1~bpo50+1.diff.gz
c2eeb85a871cb7c3f494ce247e729758854e9f4a193fb5aade0e0709e8e466b3 17590296 postgresql-8.4_8.4.5.orig.tar.gz
7a0441e839a26a97760c421172d7cc0a6af60e98f49a6d8599c8bd9809745e91 1910140 postgresql-doc-8.4_8.4.5-1~bpo50+1_all.deb
202c3585cf3645e5ea6a6c09f894d457f7d7304cb21e4db60e7b60c38ccff02b 18178 postgresql_8.4.5-1~bpo50+1_all.deb
929fbd66aa55366c6898dd515af9f8fa03497a7ea69da6efbab537e2fab14dfc 18146 postgresql-client_8.4.5-1~bpo50+1_all.deb
dbc0888373a381d7487359d425e4b6d162176afa72141b2ec409d86e4fa35eb6 17986 postgresql-doc_8.4.5-1~bpo50+1_all.deb
53801297f3e013088cf77137711f4ab5eb4e85de66747dec48172c3c1901793c 18046 postgresql-contrib_8.4.5-1~bpo50+1_all.deb
f25831ca80ba245c5f30a8eb83a51a6cdd2e8f5ef31d994f7e95fbf6c87c42cb 232332 libpq-dev_8.4.5-1~bpo50+1_powerpc.deb
ce4e53bb080d310801711bffa0ded956162775901ce44fdd3a3d1cffa6bf1272 145998 libpq5_8.4.5-1~bpo50+1_powerpc.deb
8d98a071582895a623c812077819ed227317848dcf3a990cf30482b08effb338 86812 libecpg6_8.4.5-1~bpo50+1_powerpc.deb
3d0405f280a810a0665e9bd8f30bf0fa03985a251487d2f8c6563572caed3b94 253546 libecpg-dev_8.4.5-1~bpo50+1_powerpc.deb
230d08d4b04226050acd33eeeb2f6df5b8ae93be67186cb1ae575df9a63d1741 25762 libecpg-compat3_8.4.5-1~bpo50+1_powerpc.deb
45b7d489ee8c59e791b0db719fe6f0c7e75c6a0a2ac8302218493469a863035d 52232 libpgtypes3_8.4.5-1~bpo50+1_powerpc.deb
43edfa5315aec735422ae67065ae26f7976489e53ef869466611ba001109c7fd 5697478 postgresql-8.4_8.4.5-1~bpo50+1_powerpc.deb
b63c456451f0f157d18a8bc85c19a2932f82d57bd8871712b8df30c45576efb6 1493368 postgresql-client-8.4_8.4.5-1~bpo50+1_powerpc.deb
53e1bde5632f5ada69278143359ee4f62172f2a7bafe91ebcf18349e6be71b66 632940 postgresql-server-dev-8.4_8.4.5-1~bpo50+1_powerpc.deb
b71334fffe6a63f137c3b7b289e1ca31bbdb3697f9db776a2fdaa3cc9bf603f2 477696 postgresql-contrib-8.4_8.4.5-1~bpo50+1_powerpc.deb
5d0973da9528683f0d7925b3d149271193bd87102bdc5683cbdf152f92da9d9e 55532 postgresql-plperl-8.4_8.4.5-1~bpo50+1_powerpc.deb
d852bda4b6b25ae77f3e11a9fac399d227b6279d95018cac4c7714a86fbd0ac8 56446 postgresql-plpython-8.4_8.4.5-1~bpo50+1_powerpc.deb
184dd70e289324e3d272e8e7476109d730397d203cad426e92f532ab6099ebae 42682 postgresql-pltcl-8.4_8.4.5-1~bpo50+1_powerpc.deb
Files:
0f7d0e54d05ab76af27507bed1581e7c 2221 database optional postgresql-8.4_8.4.5-1~bpo50+1.dsc
26a918a7eea4389b3177865fc908ba0e 38990 database optional postgresql-8.4_8.4.5-1~bpo50+1.diff.gz
8ddea33493bf5cf6f5ea62212bb079df 17590296 database optional postgresql-8.4_8.4.5.orig.tar.gz
a59360039f486df0ec8bdda344e31ba3 1910140 doc optional postgresql-doc-8.4_8.4.5-1~bpo50+1_all.deb
7a9fb422973395e6e61b0e7dcda893ef 18178 database optional postgresql_8.4.5-1~bpo50+1_all.deb
e1c7390df561f6205308eb6680529c35 18146 database optional postgresql-client_8.4.5-1~bpo50+1_all.deb
eb161a969646dea9d0d931c3a0836637 17986 doc optional postgresql-doc_8.4.5-1~bpo50+1_all.deb
dc31e2c309e6cc133c996cf64c79f985 18046 database optional postgresql-contrib_8.4.5-1~bpo50+1_all.deb
6518245b5e6b96fc5fe56ec6c363e5a9 232332 libdevel optional libpq-dev_8.4.5-1~bpo50+1_powerpc.deb
1a53947c32756a9eda1c6230d1c498df 145998 libs optional libpq5_8.4.5-1~bpo50+1_powerpc.deb
ebbdb1ba0e7c5e11f67bed6739ea3690 86812 libs optional libecpg6_8.4.5-1~bpo50+1_powerpc.deb
08d652d1022b2a187fcada11a89d048c 253546 libdevel optional libecpg-dev_8.4.5-1~bpo50+1_powerpc.deb
ea3eed61fac193a27d70b7b6b59aedb3 25762 libs optional libecpg-compat3_8.4.5-1~bpo50+1_powerpc.deb
9da219a73debbd41bdc5f43858e89f57 52232 libs optional libpgtypes3_8.4.5-1~bpo50+1_powerpc.deb
4a3a1f2118ac53efe8e4d827cf01d156 5697478 database optional postgresql-8.4_8.4.5-1~bpo50+1_powerpc.deb
02423316c2d86294b39f7c7a5611e4c8 1493368 database optional postgresql-client-8.4_8.4.5-1~bpo50+1_powerpc.deb
a309600287aa29756a5dbc76f57a38b8 632940 libdevel optional postgresql-server-dev-8.4_8.4.5-1~bpo50+1_powerpc.deb
9f166c6a68177e6a0e85b2fa9a2d403f 477696 database optional postgresql-contrib-8.4_8.4.5-1~bpo50+1_powerpc.deb
4331d8ac6edfe4398a05abb9e707961d 55532 database optional postgresql-plperl-8.4_8.4.5-1~bpo50+1_powerpc.deb
60e9a8c6901fae5bb6038a262709adb6 56446 database optional postgresql-plpython-8.4_8.4.5-1~bpo50+1_powerpc.deb
87fd61447218f66514f137d00c60a99e 42682 database optional postgresql-pltcl-8.4_8.4.5-1~bpo50+1_powerpc.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQEcBAEBCAAGBQJMsbdZAAoJEDH85+fdB5RhUZ4H/i8MXCqF9TeBhW2FianopiP2
zEFncUPbDvo3H/Hy1sRAURpDvQnPPogGJfWUPYOqB7MMi/m58YZzf1kVemCnTxBk
TtsMCSeImdnjs66fiKfacacuiMoi1Y3yjtgJZuMsU7IeOfjqWJf8slHQRKeTsFPD
MF9KKWO1+Skfk3iwhy8OheRRjY2fKCQlPZgh40MJ9mk2VGr4z3QquGPyTRHHGgTL
8lrcIiQ88KCCCLZEZVY4ahPHp3WSSQ/3V2q/P1hVqPlU+R56IuU79fpW6niKdnqf
r1v6UC8ot3LjTZ65y0OETWYVfLF3uCbBW066BoXezCY4ph94X5Z9HayR28cd1Yo=
=p556
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libecpg-compat3_8.4.5-1~bpo50+1_powerpc.deb
libecpg-dev_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libecpg-dev_8.4.5-1~bpo50+1_powerpc.deb
libecpg6_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libecpg6_8.4.5-1~bpo50+1_powerpc.deb
libpgtypes3_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libpgtypes3_8.4.5-1~bpo50+1_powerpc.deb
libpq-dev_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libpq-dev_8.4.5-1~bpo50+1_powerpc.deb
libpq5_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/libpq5_8.4.5-1~bpo50+1_powerpc.deb
postgresql-8.4_8.4.5-1~bpo50+1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.5-1~bpo50+1.diff.gz
postgresql-8.4_8.4.5-1~bpo50+1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.5-1~bpo50+1.dsc
postgresql-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-8.4_8.4.5.orig.tar.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.5.orig.tar.gz
postgresql-client-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-client_8.4.5-1~bpo50+1_all.deb
to main/p/postgresql-8.4/postgresql-client_8.4.5-1~bpo50+1_all.deb
postgresql-contrib-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-contrib_8.4.5-1~bpo50+1_all.deb
to main/p/postgresql-8.4/postgresql-contrib_8.4.5-1~bpo50+1_all.deb
postgresql-doc-8.4_8.4.5-1~bpo50+1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.5-1~bpo50+1_all.deb
postgresql-doc_8.4.5-1~bpo50+1_all.deb
to main/p/postgresql-8.4/postgresql-doc_8.4.5-1~bpo50+1_all.deb
postgresql-plperl-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-plpython-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-pltcl-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql-server-dev-8.4_8.4.5-1~bpo50+1_powerpc.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.5-1~bpo50+1_powerpc.deb
postgresql_8.4.5-1~bpo50+1_all.deb
to main/p/postgresql-8.4/postgresql_8.4.5-1~bpo50+1_all.deb
Reply to: