-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Fri, 02 Dec 2011 14:46:33 +0100
Source: postgresql-8.4
Binary: 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
Architecture: source all amd64
Version: 8.4.10-1
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <mpitt@debian.org>
Changed-By: Martin Pitt <mpitt@debian.org>
Description:
postgresql-8.4 - object-relational SQL database, version 8.4 server
postgresql-client-8.4 - front-end programs for PostgreSQL 8.4
postgresql-contrib-8.4 - additional facilities for PostgreSQL
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.10-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 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 race condition during toast table access from stale syscache
entries.
- 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.
- Make DatumGetInetP() unpack inet datums that have a 1-byte header,
and add a new macro, DatumGetInetPP(), that does not.
- 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. transform_null_equals is only supposed to affect foo = NULL
expressions written directly by the user, not equality checks
generated internally by this form of CASE.
- 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.
- 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.
- 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".
- 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:
8003f9832073970a2672166f6970dbb44c2326b0 2677 postgresql-8.4_8.4.10-1.dsc
1ae736d90cc84feb8b604f58fa7aa4e3fa415778 18157949 postgresql-8.4_8.4.10.orig.tar.gz
77e94b7c13f0730e64e73533ecf9e2dc2502c7c9 45022 postgresql-8.4_8.4.10-1.diff.gz
2c1fd5e114e47d6c039d2cb44e747be71b521a7b 2177856 postgresql-doc-8.4_8.4.10-1_all.deb
917290cf1e3f7dee0294245d92c2cc176e5f6eb5 5490688 postgresql-8.4_8.4.10-1_amd64.deb
fced04bf156a1356ab2c8dd16fe3d4fa649213ae 1532938 postgresql-client-8.4_8.4.10-1_amd64.deb
0faa990c3c534df99f68b5a5622c931dc96a3429 645362 postgresql-server-dev-8.4_8.4.10-1_amd64.deb
2ca4b1cb46fcdc5f3fd03d4b38c31041b0c27b11 441176 postgresql-contrib-8.4_8.4.10-1_amd64.deb
174069527b12904a6eaa304014d8835a29885a7c 66150 postgresql-plperl-8.4_8.4.10-1_amd64.deb
54aa52ba3a6d3cad3be56b0d12cf4510205e51f7 67942 postgresql-plpython-8.4_8.4.10-1_amd64.deb
0bc7de119cefe9f34366570d53aaa8c529e7e2b3 52370 postgresql-pltcl-8.4_8.4.10-1_amd64.deb
Checksums-Sha256:
07cf0025c260275901f2cd0de876aad408517d3a8f06d0a1393a4738c9dc2d56 2677 postgresql-8.4_8.4.10-1.dsc
8da06d33a08004293d70eac1d006c8af3d8aec6e13b509fdcf0ff800e48c4cd7 18157949 postgresql-8.4_8.4.10.orig.tar.gz
8d691a57fa3f5d0be1511a57d345b0098b0b57f065a1eae7b48cf0b63b1731e7 45022 postgresql-8.4_8.4.10-1.diff.gz
5abdc33c543be3f28585e4e45f025b0fd3808be2b8329a0a385d817f2b185188 2177856 postgresql-doc-8.4_8.4.10-1_all.deb
5088ca9aa3efd7566931844832a407c370bc11036437ea4b4639b4d047faaa85 5490688 postgresql-8.4_8.4.10-1_amd64.deb
d3667deccd2df8f035a8cf0370e3d5cc67e33f4c805f1abf3745ab776cdac748 1532938 postgresql-client-8.4_8.4.10-1_amd64.deb
1ccd810f96db3b3e32c5b3fdb74db6ab3b16484086f057bb42234cecc8670d04 645362 postgresql-server-dev-8.4_8.4.10-1_amd64.deb
4138df2295b3b8d483946748ff963e5956e2a119d896b882f99a0b43d2e4d27c 441176 postgresql-contrib-8.4_8.4.10-1_amd64.deb
f46fba2d44701b7c627a90b3b21acf82ec2d83f0db7a3ede95181e42c3b30d06 66150 postgresql-plperl-8.4_8.4.10-1_amd64.deb
77e3b56ea76dd860932469ef2855917b5eefeaf22c35f040b5f638141941720b 67942 postgresql-plpython-8.4_8.4.10-1_amd64.deb
8a4382d2afd50e08ef71503617c013878b242749191d8e1b03ceff8330d09a08 52370 postgresql-pltcl-8.4_8.4.10-1_amd64.deb
Files:
107324420be6fa3775fe0876fd81941b 2677 database optional postgresql-8.4_8.4.10-1.dsc
c2776cf3da7923ac4af0ca5c164016ea 18157949 database optional postgresql-8.4_8.4.10.orig.tar.gz
5b8ceda93ecea361cb9c955ec37060b5 45022 database optional postgresql-8.4_8.4.10-1.diff.gz
5403e333bda6665025885089600df25b 2177856 doc optional postgresql-doc-8.4_8.4.10-1_all.deb
34232c1ec34784d754f04a3d20c3f2fe 5490688 database optional postgresql-8.4_8.4.10-1_amd64.deb
47ff589f57089a3153d0b4651d302e5e 1532938 database optional postgresql-client-8.4_8.4.10-1_amd64.deb
d40b11600b1bb0c55ff0af3a5e6b53c8 645362 libdevel optional postgresql-server-dev-8.4_8.4.10-1_amd64.deb
e0cb46201edac469e32c314e29a3bc64 441176 database optional postgresql-contrib-8.4_8.4.10-1_amd64.deb
eb076d9524adf9cee0651ef4fcf4485c 66150 database optional postgresql-plperl-8.4_8.4.10-1_amd64.deb
26c1726414e634e1b005f15c98d481c4 67942 database optional postgresql-plpython-8.4_8.4.10-1_amd64.deb
6b494d44731bf97cf7e03dbca10a5509 52370 database optional postgresql-pltcl-8.4_8.4.10-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iQIcBAEBCAAGBQJO2lNVAAoJEPmIJawmtHufr7IP/0j8PLUjhXAymSpEjtnMUr+J
yiSD+btgGWnuypQzWrmoYqkuBrZtqONOn7bSqE1l3lY+2IhGFzz0A575DD/WNTdL
LW/mYBh6gOaNuOPKxirz9aOaWWxNCGG0UGMH2AlTzjjYopcXge4h+/106hM2P39D
hcOEGVVZuzcK9bSbTQq+CYov45yyqr797EZJq83Xs2J7WqKnCRcPVyB8uQjf2EaG
NmYTTFc6aJvRWf3eSW7W/5iskGcWc+q89fla62dfMf5c882AUXqMMndHskuaoioj
6XPSDfrgg6g3cMG542szG14ytEcfoY93tMwShztLU/bt8qoqOHGhm7SQvBYLlQht
h0htzMsLHSmSGwOiJ6AJjHEzachGRuIorJbLKxgAj8WedildkxBWzFGrwDNTzXCY
qJxVDfMJHpVHmjNuEnZK0PWHYvk6aJtr4rjzhRoZCVOxtWMVjgrN6Ou5SmcWh+TQ
uhomwo8S43F9aH8N4gNJHZZpQgpsTP1CBfNxHfKzFNfyNnjogAhzoFXaRBqXWwbg
aScuqo+6Y+iucG6dKXbePPlvzoaTQ1eASkPUsIatl19mB/bDPYpkXhq2gc0ME2V5
RkoH1eMF7ZQnbmYisB8SBCa+fyngo+ks6bHIn+KinOFUPIANiyrmGFyB7McSE5ib
mEuE1NOpZYwuu7WgcqP9
=+7g4
-----END PGP SIGNATURE-----
Accepted:
postgresql-8.4_8.4.10-1.diff.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-1.diff.gz
postgresql-8.4_8.4.10-1.dsc
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-1.dsc
postgresql-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-8.4_8.4.10-1_amd64.deb
postgresql-8.4_8.4.10.orig.tar.gz
to main/p/postgresql-8.4/postgresql-8.4_8.4.10.orig.tar.gz
postgresql-client-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-client-8.4_8.4.10-1_amd64.deb
postgresql-contrib-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-contrib-8.4_8.4.10-1_amd64.deb
postgresql-doc-8.4_8.4.10-1_all.deb
to main/p/postgresql-8.4/postgresql-doc-8.4_8.4.10-1_all.deb
postgresql-plperl-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plperl-8.4_8.4.10-1_amd64.deb
postgresql-plpython-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-plpython-8.4_8.4.10-1_amd64.deb
postgresql-pltcl-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-pltcl-8.4_8.4.10-1_amd64.deb
postgresql-server-dev-8.4_8.4.10-1_amd64.deb
to main/p/postgresql-8.4/postgresql-server-dev-8.4_8.4.10-1_amd64.deb
