Accepted postgresql-9.0 9.0.2-1 (source all amd64)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Sat, 18 Dec 2010 22:28:42 +0100
Source: postgresql-9.0
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.0 postgresql-client-9.0 postgresql-server-dev-9.0 postgresql-doc-9.0 postgresql-contrib-9.0 postgresql-plperl-9.0 postgresql-plpython-9.0 postgresql-pltcl-9.0 postgresql postgresql-client postgresql-doc postgresql-contrib
Architecture: source all amd64
Version: 9.0.2-1
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <mpitt@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.0
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql - object-relational SQL database (supported version)
postgresql-9.0 - object-relational SQL database, version 9.0 server
postgresql-client - front-end programs for PostgreSQL (supported version)
postgresql-client-9.0 - front-end programs for PostgreSQL 9.0
postgresql-contrib - additional facilities for PostgreSQL (supported version)
postgresql-contrib-9.0 - additional facilities for PostgreSQL
postgresql-doc - documentation for the PostgreSQL database management system
postgresql-doc-9.0 - documentation for the PostgreSQL database management system
postgresql-plperl-9.0 - PL/Perl procedural language for PostgreSQL 9.0
postgresql-plpython-9.0 - PL/Python procedural language for PostgreSQL 9.0
postgresql-pltcl-9.0 - PL/Tcl procedural language for PostgreSQL 9.0
postgresql-server-dev-9.0 - development files for PostgreSQL 9.0 server-side programming
Changes:
postgresql-9.0 (9.0.2-1) unstable; urgency=low
.
* New upstream bug fix release:
- Force the default wal_sync_method to be fdatasync on Linux.
The default on Linux has actually been fdatasync for many years,
but recent kernel changes caused PostgreSQL to choose open_datasync
instead. This choice did not result in any performance improvement,
and caused outright failures on certain filesystems, notably ext4
with the data=journal mount option.
- Fix "too many KnownAssignedXids" error during Hot Standby replay.
- Fix race condition in lock acquisition during Hot Standby.
- Avoid unnecessary conflicts during Hot Standby.
This fixes some cases where replay was considered to conflict with
standby queries (causing delay of replay or possibly cancellation
of the queries), but there was no real conflict.
- Fix assorted bugs in WAL replay logic for GIN indexes.
This could result in "bad buffer id: 0" failures or corruption of
index contents during replication.
- Fix recovery from base backup when the starting checkpoint WAL
record is not in the same WAL segment as its redo point.
- Fix corner-case bug when streaming replication is enabled
immediately after creating the master database cluster.
- Fix persistent slowdown of autovacuum workers when multiple workers
remain active for a long time.
The effective vacuum_cost_limit for an autovacuum worker could drop
to nearly zero if it processed enough tables, causing it to run
extremely slowly.
- Fix long-term memory leak in autovacuum launcher.
- Avoid failure when trying to report an impending transaction
wraparound condition from outside a transaction.
This oversight prevented recovery after transaction wraparound got
too close, because database startup processing would fail.
- Add support for detecting register-stack overrun on IA64.
The IA64 architecture has two hardware stacks. Full prevention of
stack-overrun failures requires checking both.
- Add a check for stack overflow in copyObject().
Certain code paths could crash due to stack overflow given a
sufficiently complex query.
- Fix detection of page splits in temporary GiST indexes.
It is possible to have a "concurrent" page split in a temporary
index, if for example there is an open cursor scanning the index
when an insertion is done. GiST failed to detect this case and
hence could deliver wrong results when execution of the cursor
continued.
- Fix error checking during early connection processing.
The check for too many child processes was skipped in some cases,
possibly leading to postmaster crash when attempting to add the new
child process to fixed-size arrays.
- Improve efficiency of window functions. Certain cases where a large
number of tuples needed to be read in advance, but work_mem was large
enough to allow them all to be held in memory, were unexpectedly slow.
percent_rank(), cume_dist() and ntile() in particular were subject to
this problem.
- Avoid memory leakage while "ANALYZE"'ing complex index expressions.
- Ensure an index that uses a whole-row Var still depends on its
table.
An index declared like create index i on t (foo(t.-)) would not
automatically get dropped when its table was dropped.
- Add missing support in "DROP OWNED BY" for removing foreign data
wrapper/server privileges belonging to a user.
- Do not "inline" a SQL function with multiple OUT parameters.
This avoids a possible crash due to loss of information about the
expected result rowtype.
- Fix crash when inline-ing a set-returning function whose argument
list contains a reference to an inline-able user function.
- Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is
attached to the VALUES part of INSERT ... VALUES.
- Make the OFF keyword unreserved.
This prevents problems with using off as a variable name in
PL/pgSQL. That worked before 9.0, but was now broken because
PL/pgSQL now treats all core reserved words as reserved.
- Fix constant-folding of COALESCE() expressions.
The planner would sometimes attempt to evaluate sub-expressions
that in fact could never be reached, possibly leading to unexpected
errors.
- Fix "could not find pathkey item to sort" planner failure with
comparison of whole-row Vars.
- Fix postmaster crash when connection acceptance (accept() or one of
the calls made immediately after it) fails, and the postmaster was
compiled with GSSAPI support.
- Retry after receiving an invalid response packet from a RADIUS
authentication server.
This fixes a low-risk potential denial of service condition.
- Fix missed unlink of temporary files when log_temp_files is active.
If an error occurred while attempting to emit the log message, the
unlink was not done, resulting in accumulation of temp files.
- Add print functionality for InhRelation nodes.
This avoids a failure when debug_print_parse is enabled and certain
types of query are executed.
- Fix incorrect calculation of distance from a point to a horizontal
line segment.
This bug affected several different geometric distance-measurement
operators.
- Fix incorrect calculation of transaction status in ecpg.
- Fix errors in psql's Unicode-escape support.
- Speed up parallel pg_restore when the archive contains many large
objects (blobs).
- Fix PL/pgSQL's handling of "simple" expressions to not fail in
recursion or error-recovery cases.
- Fix PL/pgSQL's error reporting for no-such-column cases.
As of 9.0, it would sometimes report "missing FROM-clause entry for
table foo" when "record foo has no field bar" would be more
appropriate.
- Fix PL/Python to honor typmod (i.e., length or precision
restrictions) when assigning to tuple fields.
This fixes a regression from 8.4.
- Fix PL/Python's handling of set-returning functions.
Attempts to call SPI functions within the iterator generating a set
result would fail.
- Fix bug in "contrib/cube"'s GiST picksplit algorithm.
This could result in considerable inefficiency, though not actually
incorrect answers, in a GiST index on a cube column. If you have
such an index, consider "REINDEX"ing it after installing this
update.
- Don't emit "identifier will be truncated" notices in
"contrib/dblink" except when creating new connections.
- Fix potential coredump on missing public key in "contrib/pgcrypto".
- Fix buffer overrun in "contrib/pg_upgrade".
- Fix memory leak in "contrib/xml2"'s XPath query functions.
Checksums-Sha1:
abe41ff703c04712b51379747ab371b1d8e466d5 2497 postgresql-9.0_9.0.2-1.dsc
42a9518a2f11fa1d09a23bc628b00e992d3bcf4a 14024244 postgresql-9.0_9.0.2.orig.tar.bz2
c48c0a2de8ad248a75e1ab57b010305c5d27c325 23290 postgresql-9.0_9.0.2-1.debian.tar.gz
a32422898aae67ba9e39b36fe8ac256099672b35 2552816 postgresql-doc-9.0_9.0.2-1_all.deb
de932f1fc9d116692e7d9d4d587668e196d585bb 306594 postgresql_9.0.2-1_all.deb
f4ecd932b177e4437d73275050550ef038a3ff86 306568 postgresql-client_9.0.2-1_all.deb
901aee1e2e21cde6770f740b5634095227af932d 306410 postgresql-doc_9.0.2-1_all.deb
b9e504d24c7cc55279d8899a4ec57e7b68f4ebf7 306470 postgresql-contrib_9.0.2-1_all.deb
dd4ae41b74a5e61e9a8429aa0fe52755fbf75dde 529880 libpq-dev_9.0.2-1_amd64.deb
5744f6f1cc321859709d57b994f42852853763b7 448092 libpq5_9.0.2-1_amd64.deb
1f4bb20a4b458b7c6eeebc8f8eeae891ffa16faf 382842 libecpg6_9.0.2-1_amd64.deb
3dd4eecd9082f28881d25e0b52abe01daeee4b13 560970 libecpg-dev_9.0.2-1_amd64.deb
57ea72cff90a4b943a42124d4d824a373e432c47 314544 libecpg-compat3_9.0.2-1_amd64.deb
5a37bc1508406154a718147b73797349b13ff3f1 338862 libpgtypes3_9.0.2-1_amd64.deb
ab8d2f83657608476129c675c4a6d78a2fae0ef8 5713582 postgresql-9.0_9.0.2-1_amd64.deb
e2157e15e11f3655662c3594794dac2582b9d8fe 1662234 postgresql-client-9.0_9.0.2-1_amd64.deb
74e55446efab4917bf64c76194d7382ae60aab6a 949852 postgresql-server-dev-9.0_9.0.2-1_amd64.deb
b064111bbfb8f09635a44f28c30ae2d64c3cbb51 744132 postgresql-contrib-9.0_9.0.2-1_amd64.deb
5273b5c94f2dfe592c15601125ed6d6707443d29 349346 postgresql-plperl-9.0_9.0.2-1_amd64.deb
9b76c47b1c23cbd226d538925467140728b2ca39 350846 postgresql-plpython-9.0_9.0.2-1_amd64.deb
9f81d25b0a6491362801ff487c5493baa77bfbd8 329720 postgresql-pltcl-9.0_9.0.2-1_amd64.deb
Checksums-Sha256:
52779734b2b2b664e17d1e5bcff1afaff0fc1c1c0eff15a51d119477f948c714 2497 postgresql-9.0_9.0.2-1.dsc
ffb58195850aa0ec9b7b3dcdac51a6dee0c76ea3387b76c805e1c4d186fe2af5 14024244 postgresql-9.0_9.0.2.orig.tar.bz2
e9c6c5cb9e0374d79be4a69088b847bd1dc8d31da5366ce9b6c8b49c3b7a675e 23290 postgresql-9.0_9.0.2-1.debian.tar.gz
349027771b56842177c1a47581a4f8412a2789c2cb172d9cf20689f28085650a 2552816 postgresql-doc-9.0_9.0.2-1_all.deb
e6f0e5eb0437c748cbc37ec0157f02191d5b9545def1e5978a2033ec87589de8 306594 postgresql_9.0.2-1_all.deb
60314fe56571b4f553feb64ade83dbe0fd85fac637a39d2200a01737ca2a7cbb 306568 postgresql-client_9.0.2-1_all.deb
5b03a3b69af5ea3016b6ff001a4314dcc83d24305198100019b2c8edd1fc61d4 306410 postgresql-doc_9.0.2-1_all.deb
3c4135a7f4d37bdd57d8219a368f2910ff985f57de50103ddd5434010ddf3407 306470 postgresql-contrib_9.0.2-1_all.deb
6f4be89c679c4daf24a7ec22e9e61d4703a63dbefb52cee2964e079834548a84 529880 libpq-dev_9.0.2-1_amd64.deb
cf4906c98274409f71718d510cd36a65012126fefcb0b557052fbb7343c2e3c4 448092 libpq5_9.0.2-1_amd64.deb
41c05838cd2e946d09d2ddfdf20fd223359b1a976aa611c13af85383499f901e 382842 libecpg6_9.0.2-1_amd64.deb
ca28e194aa0fce63d25bea77013ca8dcca3ee0fcecb7c86a91f30bd3203d7dfd 560970 libecpg-dev_9.0.2-1_amd64.deb
d8b7447116220ed95cfce1abc0e0cfb41864e146abb4e4b50f6c99295a82df91 314544 libecpg-compat3_9.0.2-1_amd64.deb
2a36ac8c3829277d2dc4ebe15d12c4f6aeec0e62f641d1014a0c4e4255653641 338862 libpgtypes3_9.0.2-1_amd64.deb
aa1f448b46670e4288a0e98898ce303f2c689a1b25080d968cfd5ce7da45c055 5713582 postgresql-9.0_9.0.2-1_amd64.deb
ca36336d4b83b0a8d6c7a08a3a27e4932e81324f412705aa7630287e8e49adc0 1662234 postgresql-client-9.0_9.0.2-1_amd64.deb
231aef22103cd3391648ba7281a03092f8132aaf5dcfa90fa69433bf369ac89e 949852 postgresql-server-dev-9.0_9.0.2-1_amd64.deb
e8d130f3b124538a644790e95d4a2fcd0a9f6ec3f5cd7103296a6d4e636cbf74 744132 postgresql-contrib-9.0_9.0.2-1_amd64.deb
82954fa964fd05f44f165b9f7ac6d8c44eccac912ef654b5a06d74cf313456ad 349346 postgresql-plperl-9.0_9.0.2-1_amd64.deb
126e65e3abd0f3608cfc63ec65786b8c99eeed5e3d091a3642819ebbf5eb2f77 350846 postgresql-plpython-9.0_9.0.2-1_amd64.deb
db55b798599212f0a809aaae77f1840cf793bc94cbfb2507d58264708bea00fe 329720 postgresql-pltcl-9.0_9.0.2-1_amd64.deb
Files:
237850b9c63a5a22f83b55a5fa5eb8b7 2497 database optional postgresql-9.0_9.0.2-1.dsc
fc79ef32b602f75f2ccd37647bc008e9 14024244 database optional postgresql-9.0_9.0.2.orig.tar.bz2
4bb501efe85cb7fdcfb934560568c09a 23290 database optional postgresql-9.0_9.0.2-1.debian.tar.gz
a1252cec8761b44bbd9f6869f4a2a601 2552816 doc optional postgresql-doc-9.0_9.0.2-1_all.deb
17426abc1a95993bf74e54ae4688f881 306594 database optional postgresql_9.0.2-1_all.deb
4e23f45910c8dc51bbd99ca7a2baec09 306568 database optional postgresql-client_9.0.2-1_all.deb
5251e0f03866a8cc43a557ca832df292 306410 doc optional postgresql-doc_9.0.2-1_all.deb
b27fc3e45783c99dd2c621bf618e301a 306470 database optional postgresql-contrib_9.0.2-1_all.deb
2b0b72196297a5ee4651a0acdc42aac9 529880 libdevel optional libpq-dev_9.0.2-1_amd64.deb
1a8be842fe3458d3d9990e539d0d2d6c 448092 libs optional libpq5_9.0.2-1_amd64.deb
54cabc0ef43598a424edc6d80a5e226d 382842 libs optional libecpg6_9.0.2-1_amd64.deb
fa39ab584f05246513d0368acbf513fb 560970 libdevel optional libecpg-dev_9.0.2-1_amd64.deb
6df118cfe6b936960e6571be153f7d0f 314544 libs optional libecpg-compat3_9.0.2-1_amd64.deb
66afad15e69e0a8d4f829ce132e09f79 338862 libs optional libpgtypes3_9.0.2-1_amd64.deb
0d2db854c7872e003c21522630960c45 5713582 database optional postgresql-9.0_9.0.2-1_amd64.deb
6c4957bc0a29963d332f0b55227703c7 1662234 database optional postgresql-client-9.0_9.0.2-1_amd64.deb
24a99fc55444d006050d12d383938237 949852 libdevel optional postgresql-server-dev-9.0_9.0.2-1_amd64.deb
1df23c7a0e3e4f13573d1f5698d2dce3 744132 database optional postgresql-contrib-9.0_9.0.2-1_amd64.deb
0d53263b0377498f0f0e202ed6cc12cc 349346 database optional postgresql-plperl-9.0_9.0.2-1_amd64.deb
47777a45015b7f22674d2ea27d11272d 350846 database optional postgresql-plpython-9.0_9.0.2-1_amd64.deb
81940f047498a950bf53cbdd84e27db6 329720 database optional postgresql-pltcl-9.0_9.0.2-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBCAAGBQJNDSsbAAoJEPmIJawmtHufFOQQAKTyVXk8vJKIFHYtXKsoM9lO
XCzFuxQkPguH4BB4dCmwDvqckH9lbUMoe4Q8eC9adCQ84zOT5Fw3A7mfA/M/Fgu/
ZAOfzKFfDrskvlGwWcsjta9icas6xygt2fSHgQGTy7R5jYXLOBqRpFZbxpprQeoP
ggemH3ywnh3lNTNV3Tyxba7X/K6rWfKWHcEpZeExDOrj7uI6jFzYEj1pEXQkcL5d
/yIaBIkgazlXFkmURIEGWXmj0KIDr1xMDwVya+rd5rfjpsKbmWJmibNasCFLlOtr
9tssOncPd4XyBb6faEGGM1+iCg1KSmwhSr/Hzsr+cFbLE8H07yKZhMrEfsj1Nu6r
a74RSveKFDzTL2zTYGYWmBcRhaoE40YrT3fSeZWOKk9OFfk7dlyNpUJEgOpZREzC
vf8Mq+2+dfEhucRRlDnIAJzeEKOlF/O33p7nifUmNTYAcCffW++kt4JLmwoiYRHZ
0Qi/Fpvo8oGBWNZ2drIxyLH0w163wJ34StczP3MNOQwRaJhOXlRCpL6m77vEX52W
CNRLbBz9n9hBcMksMldNerx0X04afUZHrRchbagW+MYqrYCWkIrC3sc7wQd5s0VZ
qiIkMV1lUm1Bwd6fAC5+yk52tNOzZiY/Drx+b0Xh8WgxZY8mP77vqXKdpDtmyVXs
t1NZIN0aS0l5CoKeXSgo
=Tr/f
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libecpg-compat3_9.0.2-1_amd64.deb
libecpg-dev_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libecpg-dev_9.0.2-1_amd64.deb
libecpg6_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libecpg6_9.0.2-1_amd64.deb
libpgtypes3_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libpgtypes3_9.0.2-1_amd64.deb
libpq-dev_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libpq-dev_9.0.2-1_amd64.deb
libpq5_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/libpq5_9.0.2-1_amd64.deb
postgresql-9.0_9.0.2-1.debian.tar.gz
to main/p/postgresql-9.0/postgresql-9.0_9.0.2-1.debian.tar.gz
postgresql-9.0_9.0.2-1.dsc
to main/p/postgresql-9.0/postgresql-9.0_9.0.2-1.dsc
postgresql-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-9.0_9.0.2-1_amd64.deb
postgresql-9.0_9.0.2.orig.tar.bz2
to main/p/postgresql-9.0/postgresql-9.0_9.0.2.orig.tar.bz2
postgresql-client-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-client-9.0_9.0.2-1_amd64.deb
postgresql-client_9.0.2-1_all.deb
to main/p/postgresql-9.0/postgresql-client_9.0.2-1_all.deb
postgresql-contrib-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-contrib-9.0_9.0.2-1_amd64.deb
postgresql-contrib_9.0.2-1_all.deb
to main/p/postgresql-9.0/postgresql-contrib_9.0.2-1_all.deb
postgresql-doc-9.0_9.0.2-1_all.deb
to main/p/postgresql-9.0/postgresql-doc-9.0_9.0.2-1_all.deb
postgresql-doc_9.0.2-1_all.deb
to main/p/postgresql-9.0/postgresql-doc_9.0.2-1_all.deb
postgresql-plperl-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-plperl-9.0_9.0.2-1_amd64.deb
postgresql-plpython-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-plpython-9.0_9.0.2-1_amd64.deb
postgresql-pltcl-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-pltcl-9.0_9.0.2-1_amd64.deb
postgresql-server-dev-9.0_9.0.2-1_amd64.deb
to main/p/postgresql-9.0/postgresql-server-dev-9.0_9.0.2-1_amd64.deb
postgresql_9.0.2-1_all.deb
to main/p/postgresql-9.0/postgresql_9.0.2-1_all.deb