Accepted postgresql-9.0 9.0.6-1 (source all amd64)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 02 Dec 2011 14:39:25 +0100
Source: postgresql-9.0
Binary: postgresql-9.0 postgresql-9.0-dbg 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
Architecture: source all amd64
Version: 9.0.6-1
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <mpitt@debian.org>
Changed-By: Martin Pitt <mpitt@debian.org>
Description:
postgresql-9.0 - object-relational SQL database, version 9.0 server
postgresql-9.0-dbg - debug symbols for postgresql-9.0
postgresql-client-9.0 - front-end programs for PostgreSQL 9.0
postgresql-contrib-9.0 - additional facilities for PostgreSQL
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.6-1) unstable; urgency=low
.
* New upstream bug fix release.
- Fix bugs in information_schema.referential_constraints view.
This view was being insufficiently careful about matching the
foreign-key constraint to the depended-on primary or unique key
constraint. That could result in failure to show a foreign key
constraint at all, or showing it multiple times, or claiming that
it depends on a different constraint than the one it really does.
Since the view definition is installed by initdb, merely upgrading
will not fix the problem. If you need to fix this in an existing
installation, you can (as a superuser) drop the information_schema
schema then re-create it by sourcing
"SHAREDIR/information_schema.sql". (Run pg_config --sharedir if
you're uncertain where "SHAREDIR" is.) This must be repeated in
each database to be fixed.
- Fix possible crash during "UPDATE" or "DELETE" that joins to the
output of a scalar-returning function. A crash could only occur if the
target row had been concurrently updated, so this problem surfaced only
intermittently.
- Fix incorrect replay of WAL records for GIN index updates.
This could result in transiently failing to find index entries
after a crash, or on a hot-standby server. The problem would be
repaired by the next "VACUUM" of the index, however.
- Fix TOAST-related data corruption during CREATE TABLE dest AS
SELECT - FROM src or INSERT INTO dest SELECT * FROM src.
If a table has been modified by "ALTER TABLE ADD COLUMN", attempts
to copy its data verbatim to another table could produce corrupt
results in certain corner cases. The problem can only manifest in
this precise form in 8.4 and later, but we patched earlier versions
as well in case there are other code paths that could trigger the
same bug.
- Fix possible failures during hot standby startup.
- Start hot standby faster when initial snapshot is incomplete.
- Fix race condition during toast table access from stale syscache
entries. The typical symptom was transient errors like "missing chunk
number 0 for toast value NNNNN in pg_toast_2619", where the cited toast
table would always belong to a system catalog.
- Track dependencies of functions on items used in parameter default
expressions. Previously, a referenced object could be dropped without
having dropped or modified the function, leading to misbehavior when the
function was used. Note that merely installing this update will not fix
the missing dependency entries; to do that, you'd need to "CREATE OR
REPLACE" each such function afterwards. If you have functions whose
defaults depend on non-built-in objects, doing so is recommended.
- Allow inlining of set-returning SQL functions with multiple OUT
parameters.
- Don't trust deferred-unique indexes for join removal. A deferred
uniqueness constraint might not hold intra-transaction, so assuming that
it does could give incorrect query results.
- Make DatumGetInetP() unpack inet datums that have a 1-byte header,
and add a new macro, DatumGetInetPP(), that does not.
This change affects no core code, but might prevent crashes in
add-on code that expects DatumGetInetP() to produce an unpacked
datum as per usual convention.
- Improve locale support in money type's input and output. Aside from not
supporting all standard lc_monetary formatting options, the input and
output functions were inconsistent, meaning there were locales in which
dumped money values could not be re-read.
- Don't let transform_null_equals affect CASE foo WHEN NULL ...
constructs.
- Change foreign-key trigger creation order to better support
self-referential foreign keys.
For a cascading foreign key that references its own table, a row
update will fire both the ON UPDATE trigger and the CHECK trigger
as one event. The ON UPDATE trigger must execute first, else the
CHECK will check a non-final state of the row and possibly throw an
inappropriate error. However, the firing order of these triggers is
determined by their names, which generally sort in creation order
since the triggers have auto-generated names following the
convention "RI_ConstraintTrigger_NNNN". A proper fix would require
modifying that convention, which we will do in 9.2, but it seems
risky to change it in existing releases. So this patch just changes
the creation order of the triggers. Users encountering this type of
error should drop and re-create the foreign key constraint to get
its triggers into the right order.
- Avoid floating-point underflow while tracking buffer allocation
rate.
- Fix incorrect field alignment in ecpg's SQLDA area.
- Preserve blank lines within commands in psql's command history.
The former behavior could cause problems if an empty line was
removed from within a string literal, for example.
- Fix pg_dump to dump user-defined casts between auto-generated
types, such as table rowtypes.
- Assorted fixes for pg_upgrade. Handle exclusion constraints correctly,
don't complain about mismatched toast table names in 8.4 databases.
- Use the preferred version of xsubpp to build PL/Perl, not
necessarily the operating system's main copy.
- Fix incorrect coding in "contrib/dict_int" and "contrib/dict_xsyn".
- Fix assorted errors in "contrib/unaccent"'s configuration file
parsing.
- Honor query cancel interrupts promptly in pgstatindex().
- Ensure VPATH builds properly install all server header files.
- Shorten file names reported in verbose error messages.
Regular builds have always reported just the name of the C file
containing the error message call, but VPATH builds formerly
reported an absolute path name.
Checksums-Sha1:
50d21e63a02037b5d14538af070b6cc7af586f18 2762 postgresql-9.0_9.0.6-1.dsc
4a9a7d5579d3683ca1992b2ba116a4356094b3ca 14777282 postgresql-9.0_9.0.6.orig.tar.bz2
58da10ffdf0275d88100510684f45929ce6462a5 27823 postgresql-9.0_9.0.6-1.debian.tar.gz
f03e8573176b7f015f9236e55ddaf28b20ff00b0 2618988 postgresql-doc-9.0_9.0.6-1_all.deb
6fd300e57b744bc094f5325e58774dfe81460c61 6063468 postgresql-9.0_9.0.6-1_amd64.deb
c6a4391913fdb89df7bc0f59ede2388411b92e39 7813646 postgresql-9.0-dbg_9.0.6-1_amd64.deb
edffaf5b76690dcf13f8e2fbc9ca3e5a5e3fef81 1826590 postgresql-client-9.0_9.0.6-1_amd64.deb
05038d929e33f04fccd2d765f07c3a6d8147965e 983484 postgresql-server-dev-9.0_9.0.6-1_amd64.deb
ce83ee8acc7dc1e00bf5a62d919c060c74e97122 781610 postgresql-contrib-9.0_9.0.6-1_amd64.deb
9556e20fbf8f3c2b48c530dcc863107ab5639ee1 388342 postgresql-plperl-9.0_9.0.6-1_amd64.deb
bcbc0e3497f121b2528fb5445619764a8cc41e3d 393762 postgresql-plpython-9.0_9.0.6-1_amd64.deb
b26b9cb8866e6e8129a562d48fdf5fa7e4f21cac 366224 postgresql-pltcl-9.0_9.0.6-1_amd64.deb
Checksums-Sha256:
a662c02f2e8950e8c565e4cf16d76baf103391fa6dd5f0a6ac3fd9be63f09d2a 2762 postgresql-9.0_9.0.6-1.dsc
317d99d2ff9e1de8da0cae107bc06c9fd455b1df0c0fb77b8fbb61fb08276056 14777282 postgresql-9.0_9.0.6.orig.tar.bz2
2d54c4c272e5a2e903f3ec342f4e918320c0ff5b7c0b808a130b88cc4a4929b2 27823 postgresql-9.0_9.0.6-1.debian.tar.gz
65f6d0a379709705ba557873e727ff992da6f5f882b68071badc64761de52428 2618988 postgresql-doc-9.0_9.0.6-1_all.deb
5ce0088d6084d8eed63e2c6fa3deeca6ce2951dd6ef0d68586023ed39c19d6d3 6063468 postgresql-9.0_9.0.6-1_amd64.deb
1a343bae3d318de5495ddc21a8d963efa1c0e2a36bbeda0816de7281cbd5f3e7 7813646 postgresql-9.0-dbg_9.0.6-1_amd64.deb
122d9a23e9114aed0829b022d50861edd7b7a565a0bfa253b7a92af3f242c637 1826590 postgresql-client-9.0_9.0.6-1_amd64.deb
0a6cd8205037c2d9cd0657564773cafb6a0c6bbfddac25a557dc49e59ed3f171 983484 postgresql-server-dev-9.0_9.0.6-1_amd64.deb
afc8b9275fcd584f76dff0e32efa667d51674cad2416b34e560c5ab6f85e492e 781610 postgresql-contrib-9.0_9.0.6-1_amd64.deb
5826cb4c8adb125d46d432a54c98d78105fdc856bd4827be3b045b2c323d74fd 388342 postgresql-plperl-9.0_9.0.6-1_amd64.deb
39be700125fb61ab30e4ffc93e61d285f22e52ed6368c340fd17f9694aacfa5b 393762 postgresql-plpython-9.0_9.0.6-1_amd64.deb
3e1b2040da4f060e3b0690d6b75cec4eb2cebd32b7829647c8df6c00973681e7 366224 postgresql-pltcl-9.0_9.0.6-1_amd64.deb
Files:
1cdb24d2b03f0e6d76b329f2397e3bc1 2762 database optional postgresql-9.0_9.0.6-1.dsc
4ad7e4fc31ef8b8a75a3e4243933963f 14777282 database optional postgresql-9.0_9.0.6.orig.tar.bz2
5222857cc6e3932aacb94f5e4bd42780 27823 database optional postgresql-9.0_9.0.6-1.debian.tar.gz
788ad0795639f79cb0f24a041cfb63e3 2618988 doc optional postgresql-doc-9.0_9.0.6-1_all.deb
542a6b9eed9267835d9a51dbae245aa6 6063468 database optional postgresql-9.0_9.0.6-1_amd64.deb
f65e74a6a554d0d1870e63a9815329b5 7813646 debug extra postgresql-9.0-dbg_9.0.6-1_amd64.deb
620d138171e95c985b37382667cfe68b 1826590 database optional postgresql-client-9.0_9.0.6-1_amd64.deb
92cad8236f2a77bd8d1d1330cc2147d1 983484 libdevel optional postgresql-server-dev-9.0_9.0.6-1_amd64.deb
01de5ea6d6296ca0c8662eee005b51e9 781610 database optional postgresql-contrib-9.0_9.0.6-1_amd64.deb
a4d765aba824cf7089957d2b4e22badb 388342 database optional postgresql-plperl-9.0_9.0.6-1_amd64.deb
1425fb4c2ac6acc745e093aa1a8ec409 393762 database optional postgresql-plpython-9.0_9.0.6-1_amd64.deb
b4d9cc1e2e7e8a917977863c9591ad63 366224 database optional postgresql-pltcl-9.0_9.0.6-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iQIcBAEBCAAGBQJO2NeIAAoJEPmIJawmtHufNbgP/23PyDLFgwIYl+s9A/Lb7ClU
vS0yfOp12O0Wh8Q9W3I9iM8LaBX+NPd/qa7K6I6SIQCt2ybabXzKQsN6AoiOuFwk
7Zvi1HXbdeeO/P/PFw7m0P8zdxTKDdjd6Pntkkop21PMpjS3IJa2yzRZKEsxZs1I
jmEZ8Irwf8/y2kvTvOXVNiSeR7uJPD5YSHYM7/h0RhmQg72BCe2+2UE99ydiWV5H
oXVOd/5pZZ9ADI7HtK/JQ0I2QPZkaK4On15m1U3FByD7ULCmBs9mn+HjIzOqZSXm
aaqPjVxc6FyX5slMYDALyzZPko1dglzB7ZgToogysTlBiuW1t5zc5ncS+rV2rykp
qHdYH2ry3/UJTF/ft87K7WFp4jD5O7UYQHyagnWKHlca1Svsg6KGqrZQXJcJTAcG
KGbEEeZg1kLMMAfayZ9Pvbv+sJZ9gYNasMRG9/ZEtvX/x/9H03sYdN6L7kguw+JY
bhK4foej4iJ9HJ6yCZ7NhvBJ34HtI6QfAuelI3x+jle3jBvn6D1i7CCe6OpfUpoP
pQqZoQfdws7r4Mn5JgmPlB500pgPR5lVwfSf05tWUj+RxkL+zqjnTnhSPkFIoWqJ
jlfAMsAyaBqi3DndKqqnrxroK+4dfF6ViZtoDcpNooYpHAGTD2VZ5gburZluIkfh
a63AqER68CPZOiEPXQri
=FGJA
-----END PGP SIGNATURE-----
Accepted:
postgresql-9.0-dbg_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-9.0-dbg_9.0.6-1_amd64.deb
postgresql-9.0_9.0.6-1.debian.tar.gz
to main/p/postgresql-9.0/postgresql-9.0_9.0.6-1.debian.tar.gz
postgresql-9.0_9.0.6-1.dsc
to main/p/postgresql-9.0/postgresql-9.0_9.0.6-1.dsc
postgresql-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-9.0_9.0.6-1_amd64.deb
postgresql-9.0_9.0.6.orig.tar.bz2
to main/p/postgresql-9.0/postgresql-9.0_9.0.6.orig.tar.bz2
postgresql-client-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-client-9.0_9.0.6-1_amd64.deb
postgresql-contrib-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-contrib-9.0_9.0.6-1_amd64.deb
postgresql-doc-9.0_9.0.6-1_all.deb
to main/p/postgresql-9.0/postgresql-doc-9.0_9.0.6-1_all.deb
postgresql-plperl-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-plperl-9.0_9.0.6-1_amd64.deb
postgresql-plpython-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-plpython-9.0_9.0.6-1_amd64.deb
postgresql-pltcl-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-pltcl-9.0_9.0.6-1_amd64.deb
postgresql-server-dev-9.0_9.0.6-1_amd64.deb
to main/p/postgresql-9.0/postgresql-server-dev-9.0_9.0.6-1_amd64.deb
Reply to: