Accepted postgresql-9.1 9.1.4-1 (source all amd64)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Mon, 04 Jun 2012 06:47:45 +0200
Source: postgresql-9.1
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.1 postgresql-9.1-dbg postgresql-client-9.1 postgresql-server-dev-9.1 postgresql-doc-9.1 postgresql-contrib-9.1 postgresql-plperl-9.1 postgresql-plpython-9.1 postgresql-plpython3-9.1 postgresql-pltcl-9.1
Architecture: source amd64 all
Version: 9.1.4-1
Distribution: unstable
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.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 9.1
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-9.1 - object-relational SQL database, version 9.1 server
postgresql-9.1-dbg - debug symbols for postgresql-9.1
postgresql-client-9.1 - front-end programs for PostgreSQL 9.1
postgresql-contrib-9.1 - additional facilities for PostgreSQL
postgresql-doc-9.1 - documentation for the PostgreSQL database management system
postgresql-plperl-9.1 - PL/Perl procedural language for PostgreSQL 9.1
postgresql-plpython-9.1 - PL/Python procedural language for PostgreSQL 9.1
postgresql-plpython3-9.1 - PL/Python 3 procedural language for PostgreSQL 9.1
postgresql-pltcl-9.1 - PL/Tcl procedural language for PostgreSQL 9.1
postgresql-server-dev-9.1 - development files for PostgreSQL 9.1 server-side programming
Changes:
postgresql-9.1 (9.1.4-1) unstable; urgency=medium
.
* Urgency medium due to security fixes.
* New upstream bug fix/security 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)
- Make "contrib/citext"'s upgrade script fix collations of citext
arrays and domains over citext.
Release 9.1.2 provided a fix for collations of citext columns and
indexes in databases upgraded or reloaded from pre-9.1
installations, but that fix was incomplete: it neglected to handle
arrays and domains over citext. This release extends the module's
upgrade script to handle these cases. As before, if you have
already run the upgrade script, you'll need to run the collation
update commands by hand instead. See the 9.1.2 release notes for
more information about doing this.
- 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().
- Ensure txid_current() reports the correct epoch when executed in
hot standby.
- 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 planning of UNION ALL subqueries with output columns that are
not simple variables.
Planning of such cases got noticeably worse in 9.1 as a result of a
misguided fix for "MergeAppend child's targetlist doesn't match
MergeAppend" errors. Revert that fix and do it another way.
- 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.
- Fix "EXPLAIN VERBOSE" for writable CTEs containing RETURNING
clauses.
- Fix "PREPARE TRANSACTION" to work correctly in the presence of
advisory locks.
Historically, "PREPARE TRANSACTION" has simply ignored any
session-level advisory locks the session holds, but this case was
accidentally broken in 9.1.
- Fix truncation of unlogged tables.
- Ignore missing schemas during non-interactive assignments of
search_path.
This re-aligns 9.1's behavior with that of older branches.
Previously 9.1 would throw an error for nonexistent schemas
mentioned in search_path settings obtained from places such as
"ALTER DATABASE SET".
- Fix bugs with temporary or transient tables used in extension
scripts.
This includes cases such as a rewriting "ALTER TABLE" within an
extension update script, since that uses a transient table behind
the scenes.
- 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 "too many LWLocks taken" failure in GiST indexes.
- Fix WAL replay logic for GIN indexes to not fail if the index was
subsequently dropped.
- Correctly detect SSI conflicts of prepared transactions after a
crash.
- Avoid synchronous replication delay when committing a transaction
that only modified temporary tables.
In such a case the transaction's commit record need not be flushed
to standby servers, but some of the code didn't know that and
waited for it to happen anyway.
- Fix error handling in pg_basebackup.
- Fix walsender to not go into a busy loop if connection is
terminated.
- 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.
- Ensure that PL/Perl package-qualifies the _TD variable.
This bug caused trigger invocations to fail when they are nested
within a function invocation that changes the current package.
- Fix PL/Python functions returning composite types to accept a
string for their result value.
This case was accidentally broken by the 9.1 additions to allow a
composite result value to be supplied in other formats, such as
dictionaries.
- 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 memory and file descriptor leaks in pg_restore when reading a
directory-format archive.
- Fix pg_upgrade for the case that a database stored in a non-default
tablespace contains a table in the cluster's default tablespace.
- In ecpg, fix rare memory leaks and possible overwrite of one byte
after the sqlca_t structure.
- 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.
- Fix "contrib/vacuumlo" to use multiple transactions when dropping
many large objects.
This change avoids exceeding max_locks_per_transaction when many
objects need to be dropped. The behavior can be adjusted with the
new -l (limit) option.
* debian/control: Bump debhelper build dependency to >= 8, as it does not
build with earlier versions.
* 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:
0cdb934ffe224d03184e79353330bacebd209a05 3253 postgresql-9.1_9.1.4-1.dsc
c75fd5696af02a275a104260eac8b3a4abe35682 15631894 postgresql-9.1_9.1.4.orig.tar.bz2
462f5f77942827f7390d8ff0d7e19c80e2e390ad 32905 postgresql-9.1_9.1.4-1.debian.tar.gz
983e79b9becece46b5ba58d009278e0a73e93e95 612026 libpq-dev_9.1.4-1_amd64.deb
21d669ff9861cb5d74bd738558daac125bb7683e 526374 libpq5_9.1.4-1_amd64.deb
84456d571b3d3a0640bd1beb3e471fa88713c667 471888 libecpg6_9.1.4-1_amd64.deb
0717478e82488daff43f022c425bf5327d48e7d6 639102 libecpg-dev_9.1.4-1_amd64.deb
9d638aa602bb9393820cc88ac49172399e86ce2c 388960 libecpg-compat3_9.1.4-1_amd64.deb
e678a5e416d6a7a2d041f57819428829469a32cc 413078 libpgtypes3_9.1.4-1_amd64.deb
9a5c0636f3eabb16bdd94bd338217f4226f6f9b5 6286650 postgresql-9.1_9.1.4-1_amd64.deb
100c590d98b2b204a6e8015004283979b6d5f943 11352238 postgresql-9.1-dbg_9.1.4-1_amd64.deb
578ba097b4d7ede0828a04fa38f2efa55f024945 1951604 postgresql-client-9.1_9.1.4-1_amd64.deb
97c06837a22f79fe1b77d4dc90697358c3f71e99 1055346 postgresql-server-dev-9.1_9.1.4-1_amd64.deb
8c81a7c8f54fccc3001266cc885883c7248fb92f 2928692 postgresql-doc-9.1_9.1.4-1_all.deb
0f06f4969dc86cd8b653d0c789bd942f1260b8a0 851256 postgresql-contrib-9.1_9.1.4-1_amd64.deb
39f23ef1e12e123a2b15005507821b112e2c1d0c 436690 postgresql-plperl-9.1_9.1.4-1_amd64.deb
358a81564ce49fffd52123bd049578625a9a393e 419588 postgresql-plpython-9.1_9.1.4-1_amd64.deb
89eaeb605605071750dea69bb618e0f676353323 419370 postgresql-plpython3-9.1_9.1.4-1_amd64.deb
4f1dc5ebab79ad8dcfd5174dc503b9bb654373fc 405994 postgresql-pltcl-9.1_9.1.4-1_amd64.deb
Checksums-Sha256:
89f35141930a0891250861534b4f63108475a9f980c661d01daf4f0b5a20e390 3253 postgresql-9.1_9.1.4-1.dsc
a0795a8eb3ae2d1a2914b63bf143d20182835d90699915ff43567c041d3c9712 15631894 postgresql-9.1_9.1.4.orig.tar.bz2
accde0f2d4b12c8e24541a2fbfc45b7b8a084a6f80ec6a4b8559d832b66686b4 32905 postgresql-9.1_9.1.4-1.debian.tar.gz
6ce2bb888e6002369497f02b63ac2f0c483036b07a9579c4ae83ae4868ddf712 612026 libpq-dev_9.1.4-1_amd64.deb
0aa1341fb00bbe0eb4820b05296e94358b28877a54ccf029952b11d944ffab60 526374 libpq5_9.1.4-1_amd64.deb
95573afffc717ae4ce1a48bde2c9f9a98ddc62aaf9f1c18925fd2eaf6402cbdd 471888 libecpg6_9.1.4-1_amd64.deb
badef494fdacaa481c610c3565a626e13ea09105e9c4d17b9384128543a4d7b3 639102 libecpg-dev_9.1.4-1_amd64.deb
fbf471430a8e8f5a07bfc7faa624e21443458aa1036cd9e9fdb98e43b76afafc 388960 libecpg-compat3_9.1.4-1_amd64.deb
97428d8b13ab728b7b38ec4210c8c2473aea7463beb1de71c0dacdb2c3ea6437 413078 libpgtypes3_9.1.4-1_amd64.deb
88fb7fc5c3729017cedf5a7f72c2abbdaf6b0d9c3341ef8f2ceaf6e6650a9bd2 6286650 postgresql-9.1_9.1.4-1_amd64.deb
3102de70b27887b555d7ee8d9aa277d7ac6cc389e4e08ccfe6812ce71ec2a2f6 11352238 postgresql-9.1-dbg_9.1.4-1_amd64.deb
35c1aa8bc03c2f50f5f42aad1cc70aee6fd7b1e071c04b0c377527d9d90e5386 1951604 postgresql-client-9.1_9.1.4-1_amd64.deb
e0c4dd43c8af07c0258b436cc58f58e850266bad97d71f82356342136b0035b9 1055346 postgresql-server-dev-9.1_9.1.4-1_amd64.deb
078604c3ebab694d816293bb83fa47e7cd24ff345510cb944ab6f6b296199382 2928692 postgresql-doc-9.1_9.1.4-1_all.deb
ce83d6c9fc2291ce135f2d9c34135dc0eac21a7609414c6a841b20dfdf0f4961 851256 postgresql-contrib-9.1_9.1.4-1_amd64.deb
f6c9ff73ffabe33588c218fe74375dfb79eaeb4997d575f383de5cab191506b3 436690 postgresql-plperl-9.1_9.1.4-1_amd64.deb
e1f4e855921943816bf1430af76d9e94c41b51c7afd3e0336f3738fe502881a5 419588 postgresql-plpython-9.1_9.1.4-1_amd64.deb
cdd57d8753c1301d2a5053f23dee4cc5cfe263989e5f57a0cc466d2424399d83 419370 postgresql-plpython3-9.1_9.1.4-1_amd64.deb
17548415df2c3c49d9c8ca7d33aff8436b41afe5ae624e2b17232d82c08aec09 405994 postgresql-pltcl-9.1_9.1.4-1_amd64.deb
Files:
0c9e024ac55ce8cc965996d90b828d12 3253 database optional postgresql-9.1_9.1.4-1.dsc
a8035688dba988b782725ac1aec60186 15631894 database optional postgresql-9.1_9.1.4.orig.tar.bz2
f1c4af446c72fa23ec30d039b4f12fe5 32905 database optional postgresql-9.1_9.1.4-1.debian.tar.gz
7d936f9592a2e14101729609c9d8c220 612026 libdevel optional libpq-dev_9.1.4-1_amd64.deb
b25d65621df33032c43a5cf469ffe402 526374 libs optional libpq5_9.1.4-1_amd64.deb
dd304bb6d66685b63f2905a16ff3fe9e 471888 libs optional libecpg6_9.1.4-1_amd64.deb
210a093d09ca9d09952f48ec8adae4c0 639102 libdevel optional libecpg-dev_9.1.4-1_amd64.deb
1b1fe092eb65c13885894ce40a9bdbcb 388960 libs optional libecpg-compat3_9.1.4-1_amd64.deb
4aeb35d7bf74d7202ce758aeaa34f557 413078 libs optional libpgtypes3_9.1.4-1_amd64.deb
e83a04dc60253f9a8bfeb4a48f505edb 6286650 database optional postgresql-9.1_9.1.4-1_amd64.deb
900ec9f0c4fa3ea2890c3b59f57773e8 11352238 debug extra postgresql-9.1-dbg_9.1.4-1_amd64.deb
62af49f68750fcc6ebc2e84f9c9239d0 1951604 database optional postgresql-client-9.1_9.1.4-1_amd64.deb
86f61d6113f63d02d040984730acb2bb 1055346 libdevel optional postgresql-server-dev-9.1_9.1.4-1_amd64.deb
55718c3953ea5a33d34e6cc45d675d87 2928692 doc optional postgresql-doc-9.1_9.1.4-1_all.deb
1b6c2a02950ebaac5faaac3548075420 851256 database optional postgresql-contrib-9.1_9.1.4-1_amd64.deb
6c82b7b6ba6672002a23d5d2a0665428 436690 database optional postgresql-plperl-9.1_9.1.4-1_amd64.deb
fbbec2e12deb9c4eec5e010db7b80abc 419588 database optional postgresql-plpython-9.1_9.1.4-1_amd64.deb
bbd7a7a85b7f100654597d6ff56b1129 419370 database optional postgresql-plpython3-9.1_9.1.4-1_amd64.deb
34841258e8dfd38d268dd13c89469f61 405994 database optional postgresql-pltcl-9.1_9.1.4-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iQIcBAEBCAAGBQJPzEbvAAoJEPmIJawmtHufGSIP/1LEL+ftdrhJnDCUozeUyO7M
phYbJYJgsSM2N/CnWyYqyjEaT4nxBvFgMmpul+bYOkE5OijTumBIhdQW3ytxmpHy
sVSwe7hIZS4P/SXtEazPK7q4fi30iKjB4ziFxXE+Db7QgM8BxEG3Ed4Guoml2Ih5
2HfXGxCg+qbnIIlTwxFgb+3rLLHVHKyKmhabm7SGGuB2XI4AJBo/ymqTgcVymje2
N8BnjU0hyeFOh48A+BPGAK6qGwuF4cHlYKJuieZxpeQx6OGupgBIlRZfQMaiHDIj
8pVAbhNlTDhOCWXHutNMjaq1fBvjd8zSdPRFi6Zt045kcn2zrKUmtcDPzOfs/tOi
juE7l3m1LPg4O4L8PwwRJ7XeqTPXOr1kRaqYexhXntZSngptQMH3yeGPrN69RfJi
kh3zQjJuN11BaYS2OwzbzsfHAcbv5rIibwJDM3FIuPo2l8EgH0SM2w6RCTeBrtIK
0QBYTtMdIh111fLrLA9gn45Xi+T67lKJ2ye+EK9JPnMdu2bokDxxC3ZCQZep+y/7
xaJF6EXeZICdYlrom65TZSFl0YQ2Z9exxJs/CHYiCHltJ74dLJDlqgm9q1u1gLaN
Et68Fp4nzkTQaeiLvulnDHxj8wmhwkJZQ/hTPIQt3cv/HPqVMyHaDXm9ri64hXzx
NX8dZJNzBOZLmkE4qT8h
=PaIS
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libecpg-compat3_9.1.4-1_amd64.deb
libecpg-dev_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libecpg-dev_9.1.4-1_amd64.deb
libecpg6_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libecpg6_9.1.4-1_amd64.deb
libpgtypes3_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libpgtypes3_9.1.4-1_amd64.deb
libpq-dev_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libpq-dev_9.1.4-1_amd64.deb
libpq5_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/libpq5_9.1.4-1_amd64.deb
postgresql-9.1-dbg_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-9.1-dbg_9.1.4-1_amd64.deb
postgresql-9.1_9.1.4-1.debian.tar.gz
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1.debian.tar.gz
postgresql-9.1_9.1.4-1.dsc
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1.dsc
postgresql-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1_amd64.deb
postgresql-9.1_9.1.4.orig.tar.bz2
to main/p/postgresql-9.1/postgresql-9.1_9.1.4.orig.tar.bz2
postgresql-client-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-client-9.1_9.1.4-1_amd64.deb
postgresql-contrib-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-contrib-9.1_9.1.4-1_amd64.deb
postgresql-doc-9.1_9.1.4-1_all.deb
to main/p/postgresql-9.1/postgresql-doc-9.1_9.1.4-1_all.deb
postgresql-plperl-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-plperl-9.1_9.1.4-1_amd64.deb
postgresql-plpython-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-plpython-9.1_9.1.4-1_amd64.deb
postgresql-plpython3-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-plpython3-9.1_9.1.4-1_amd64.deb
postgresql-pltcl-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-pltcl-9.1_9.1.4-1_amd64.deb
postgresql-server-dev-9.1_9.1.4-1_amd64.deb
to main/p/postgresql-9.1/postgresql-server-dev-9.1_9.1.4-1_amd64.deb
Reply to: