Accepted postgresql-9.1 9.1.4-1~bpo60+1 (source all amd64)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Mon, 11 Jun 2012 11:48:33 +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~bpo60+1
Distribution: squeeze-backports
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public@lists.alioth.debian.org>
Changed-By: Christoph Berg <myon@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~bpo60+1) squeeze-backports; urgency=low
.
* Rebuild for squeeze-backports.
.
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:
e07a05e70a32fa4b6dbe4a7bf45f43914b4e9b29 2643 postgresql-9.1_9.1.4-1~bpo60+1.dsc
c75fd5696af02a275a104260eac8b3a4abe35682 15631894 postgresql-9.1_9.1.4.orig.tar.bz2
8bf13b1b55e4762b4bd96ca78f3444867cde14ff 34668 postgresql-9.1_9.1.4-1~bpo60+1.debian.tar.gz
571c172de98c4a7eec6fcc260abc23109b39e85c 613326 libpq-dev_9.1.4-1~bpo60+1_amd64.deb
b990674dc8cc2bda535fde9f3a945817c6e095be 527120 libpq5_9.1.4-1~bpo60+1_amd64.deb
c4d2d16ae50d614eb58ec6f4327cea610b9722bb 470678 libecpg6_9.1.4-1~bpo60+1_amd64.deb
eb095415f305a7a3152286da1f091b930905ab54 642552 libecpg-dev_9.1.4-1~bpo60+1_amd64.deb
e8f3ed4570f08220f8656e922d0707b741724d6e 389404 libecpg-compat3_9.1.4-1~bpo60+1_amd64.deb
5e878dc298d1b86c8618c30e31b793cb488eadb9 413742 libpgtypes3_9.1.4-1~bpo60+1_amd64.deb
79aba0b89a2a74ca4250f9b6ba022242d3475ea6 6317710 postgresql-9.1_9.1.4-1~bpo60+1_amd64.deb
7f12c18659f3adad49c1015fad6b28fbb7203b74 8160686 postgresql-9.1-dbg_9.1.4-1~bpo60+1_amd64.deb
2bb04415f522549bbdcd5b55b506062a38435e02 1986250 postgresql-client-9.1_9.1.4-1~bpo60+1_amd64.deb
96960a4eddd3409070fa3541bbea0a9041d8680e 1058770 postgresql-server-dev-9.1_9.1.4-1~bpo60+1_amd64.deb
b0713a4829cf3cb8f09b3760dddf53724d95cc0f 2926960 postgresql-doc-9.1_9.1.4-1~bpo60+1_all.deb
7a939b199d94ab744d19fc323be4cf39370d75e4 850172 postgresql-contrib-9.1_9.1.4-1~bpo60+1_amd64.deb
4e0ea40c11289c9df6c0ecb33bf5abb55317a8bb 436810 postgresql-plperl-9.1_9.1.4-1~bpo60+1_amd64.deb
ca17d0b01c85b3916618fdf31e92b87471146cfd 420588 postgresql-plpython-9.1_9.1.4-1~bpo60+1_amd64.deb
0b7aeccac2212ac6c959420d57d39fb8c0d998a5 420414 postgresql-plpython3-9.1_9.1.4-1~bpo60+1_amd64.deb
9f3ad77707570533212e3f46578f8a43fe1c8d1d 406220 postgresql-pltcl-9.1_9.1.4-1~bpo60+1_amd64.deb
Checksums-Sha256:
3a4c83a06713056858d762635818eea88adb77441ae3a96b3197a9e2f80ac208 2643 postgresql-9.1_9.1.4-1~bpo60+1.dsc
a0795a8eb3ae2d1a2914b63bf143d20182835d90699915ff43567c041d3c9712 15631894 postgresql-9.1_9.1.4.orig.tar.bz2
ee3fa59424f0e06a7fc0e3db2552092498f634464a783dab003afed0a06cfd15 34668 postgresql-9.1_9.1.4-1~bpo60+1.debian.tar.gz
0315decf15bef361d13b3553ec08e265432456a17f1661e79ca3c0fc3574b9e2 613326 libpq-dev_9.1.4-1~bpo60+1_amd64.deb
79d0475aead690d82ca6bb398b5d26810bbadfd915cdb8bbd2c54897fb2207f3 527120 libpq5_9.1.4-1~bpo60+1_amd64.deb
841ca5bdb09a256eb7e587763ff3bf15d8568d07c57760f7918c7c45a1051537 470678 libecpg6_9.1.4-1~bpo60+1_amd64.deb
08f182d189c2b26b2f310cf2fe82d21b96b30c8e8a6cf0547ea04118dca2432d 642552 libecpg-dev_9.1.4-1~bpo60+1_amd64.deb
2cfad239a19570078591ec953786c986034bfb03bcc59328b6af80b69603ee34 389404 libecpg-compat3_9.1.4-1~bpo60+1_amd64.deb
7c0650416699b13d821cca04eb68dc795436a3e1e18227520be1c170e9f7f1a5 413742 libpgtypes3_9.1.4-1~bpo60+1_amd64.deb
71da79d73e6e8c412ae806cdf9bb2d0960a9b9a01a3c11b8237643472f83f492 6317710 postgresql-9.1_9.1.4-1~bpo60+1_amd64.deb
d30213d91b34a8674478d094f4a982271090e6ff322c6342dcb9eff6ae4c93c3 8160686 postgresql-9.1-dbg_9.1.4-1~bpo60+1_amd64.deb
06dbee5577075971404f5f5ed5bfbc45a10b9d437b08cb573cbc0459c0cb04db 1986250 postgresql-client-9.1_9.1.4-1~bpo60+1_amd64.deb
891797030a9e91648a8ce8e66e02f5d1c1aa20f36af2a381815c0a1c18a1aef3 1058770 postgresql-server-dev-9.1_9.1.4-1~bpo60+1_amd64.deb
79dcabe6662fb0c59d5c66428cfeeaa556106c335d8557a47b37e7bc94b38547 2926960 postgresql-doc-9.1_9.1.4-1~bpo60+1_all.deb
d369b554f07757e6522d8b8eddc365cc1dea96ca4345a93a6e7c81cdf292984e 850172 postgresql-contrib-9.1_9.1.4-1~bpo60+1_amd64.deb
4111e9d156a62cd03c53bf06ec93779415da78963cd819192cbd2988764dfc9b 436810 postgresql-plperl-9.1_9.1.4-1~bpo60+1_amd64.deb
b71adfa9d6178fba2b9650b9edecfe860d7e9f09cd16742c2cf68c09d235587b 420588 postgresql-plpython-9.1_9.1.4-1~bpo60+1_amd64.deb
bf1e7b329d06ea0bc1f25143c556246eb3f8aafeea7b06ae05a14a8b817be3e9 420414 postgresql-plpython3-9.1_9.1.4-1~bpo60+1_amd64.deb
3a2d037b824d53d2c2d16295a83e77dde24811b42d80527e518bd16e72d59010 406220 postgresql-pltcl-9.1_9.1.4-1~bpo60+1_amd64.deb
Files:
214181266e5a38ae5e97452a5a491d51 2643 database optional postgresql-9.1_9.1.4-1~bpo60+1.dsc
a8035688dba988b782725ac1aec60186 15631894 database optional postgresql-9.1_9.1.4.orig.tar.bz2
dddd36b69457b4510dc5b49148b8041d 34668 database optional postgresql-9.1_9.1.4-1~bpo60+1.debian.tar.gz
c02ccb798cc7472d8ddb4a08f127d49d 613326 libdevel optional libpq-dev_9.1.4-1~bpo60+1_amd64.deb
b870624d04e579ade5ef4c7dce019d62 527120 libs optional libpq5_9.1.4-1~bpo60+1_amd64.deb
1a41f4290a4464fd28f9d9da49b78152 470678 libs optional libecpg6_9.1.4-1~bpo60+1_amd64.deb
a51aac4408c056ad1f384b855c4916f3 642552 libdevel optional libecpg-dev_9.1.4-1~bpo60+1_amd64.deb
a04ef7cdf59e928de3906243d37efe1d 389404 libs optional libecpg-compat3_9.1.4-1~bpo60+1_amd64.deb
ebe92b7b2d2afa60fbe9293a38892784 413742 libs optional libpgtypes3_9.1.4-1~bpo60+1_amd64.deb
063734a868eb0f234d93df674ae6a67f 6317710 database optional postgresql-9.1_9.1.4-1~bpo60+1_amd64.deb
173b53dc8fee14b8a5ec42413a46faf3 8160686 debug extra postgresql-9.1-dbg_9.1.4-1~bpo60+1_amd64.deb
2fa1333269078406210a338c2a452906 1986250 database optional postgresql-client-9.1_9.1.4-1~bpo60+1_amd64.deb
814700a3bd91069caf54b2e698fb391c 1058770 libdevel optional postgresql-server-dev-9.1_9.1.4-1~bpo60+1_amd64.deb
fbe735c99e15b00d2ac99b41bf0bc703 2926960 doc optional postgresql-doc-9.1_9.1.4-1~bpo60+1_all.deb
c81259098b6c982fd934d2047052d555 850172 database optional postgresql-contrib-9.1_9.1.4-1~bpo60+1_amd64.deb
59a134c97d42565eb1626bf1cfd455bb 436810 database optional postgresql-plperl-9.1_9.1.4-1~bpo60+1_amd64.deb
a4beba8cdf552654e261eff9f5a8df63 420588 database optional postgresql-plpython-9.1_9.1.4-1~bpo60+1_amd64.deb
d93e0036ea6a112cf81995bab4978004 420414 database optional postgresql-plpython3-9.1_9.1.4-1~bpo60+1_amd64.deb
c8b56f2e744bbaf6670e6bc669a98f52 406220 database optional postgresql-pltcl-9.1_9.1.4-1~bpo60+1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iQIcBAEBCAAGBQJP1dZKAAoJEExaa6sS0qeu184P/2n8roks5PCTipq20o+G5OpA
2PSDrgwpedL69kxmrOPibB72IQMpz5gDB6I3SDkGaCEKeKGMZ46feK6FORqHahVi
6ysbqHuYLFA5SaR9v8Z65hV6K1faFScTtXJjTLky4m8ZxwqEetGPU/+FQxeKl17U
Evudpzyr3wdQ1BT5tGXgYc7yu8ICIEKOfGelLV4pJbqrEls53kFtMrt8ZgViBWc2
Inyu0Zi7OfmY5L5a/Ab9qyPGOZiC45gaXR2qPtiDK4Jz6NXQ8ECHGElkqWPrEbYG
Vnmf6xDPppg5wQolxzntHFr1Vt+MMqI4AVez5sWXfl3nqUxTX/nCuuAKdd/RZrLp
17ESESdUXs8Wagt7zmVD5sWZb3mZVjF2RX6dtNlBBViAzpeIpYqeT4OaAIuVG/oe
UbQzaEko7PNsDVFtwfqhilqauQdCoCgz4q81ZloeqH0kkaFoFUmgf+1xg5w56X6N
yFS8lFpe/hJHP3xROURgbYf1s7Lk+Y5FzEIoeqnNIokuel8/D60TTaxSrn+zzSV/
Vvb2WQG4wm9KTGg9cyLW6kJUA16Iw7l2L3+QCJaH6dIPWI8d7ZuhVqTkFCNHgbvr
TVGWr2BTV21vEimceKSYCnGlYh/N6GOJa/3gRE/B0XAOB0p+GMxEw5P7W7sq7mRV
bolLT3Kj+JNA/JTtDNsO
=E2Ji
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libecpg-compat3_9.1.4-1~bpo60+1_amd64.deb
libecpg-dev_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libecpg-dev_9.1.4-1~bpo60+1_amd64.deb
libecpg6_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libecpg6_9.1.4-1~bpo60+1_amd64.deb
libpgtypes3_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libpgtypes3_9.1.4-1~bpo60+1_amd64.deb
libpq-dev_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libpq-dev_9.1.4-1~bpo60+1_amd64.deb
libpq5_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/libpq5_9.1.4-1~bpo60+1_amd64.deb
postgresql-9.1-dbg_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-9.1-dbg_9.1.4-1~bpo60+1_amd64.deb
postgresql-9.1_9.1.4-1~bpo60+1.debian.tar.gz
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1~bpo60+1.debian.tar.gz
postgresql-9.1_9.1.4-1~bpo60+1.dsc
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1~bpo60+1.dsc
postgresql-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-9.1_9.1.4-1~bpo60+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~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-client-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-contrib-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-contrib-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-doc-9.1_9.1.4-1~bpo60+1_all.deb
to main/p/postgresql-9.1/postgresql-doc-9.1_9.1.4-1~bpo60+1_all.deb
postgresql-plperl-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-plperl-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-plpython-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-plpython-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-plpython3-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-plpython3-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-pltcl-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-pltcl-9.1_9.1.4-1~bpo60+1_amd64.deb
postgresql-server-dev-9.1_9.1.4-1~bpo60+1_amd64.deb
to main/p/postgresql-9.1/postgresql-server-dev-9.1_9.1.4-1~bpo60+1_amd64.deb
Reply to: