Accepted postgresql-9.1 9.1.2-1~bpo50+1 (source i386 all)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Thu, 22 Dec 2011 13:30:00 +0100
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-pltcl-9.1
Architecture: source i386 all
Version: 9.1.2-1~bpo50+1
Distribution: lenny-backports-sloppy
Urgency: low
Maintainer: Martin Pitt <mpitt@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-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
Closes: 643645 643646 646079
Changes:
postgresql-9.1 (9.1.2-1~bpo50+1) lenny-backports-sloppy; urgency=low
.
* Rebuild for lenny-backports-sloppy.
* Disable python3 support.
.
postgresql-9.1 (9.1.2-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.
- Make "contrib/citext"'s upgrade script fix collations of citext
columns and indexes.
Existing citext columns and indexes aren't correctly marked as
being of a collatable data type during pg_upgrade from a pre-9.1
server. That leads to operations on them failing with errors such
as "could not determine which collation to use for string
comparison". This change allows them to be fixed by the same script
that upgrades the citext module into a proper 9.1 extension during
CREATE EXTENSION citext FROM unpackaged.
If you have a previously-upgraded database that is suffering from
this problem, and you already ran the "CREATE EXTENSION" command,
you can manually run (as superuser) the "UPDATE" commands found at
the end of "SHAREDIR/extension/citext--unpackaged--1.0.sql". (Run
pg_config --sharedir if you're uncertain where "SHAREDIR" is.)
- Fix possible crash during "UPDATE" or "DELETE" that joins to the
output of a scalar-returning function.
- Fix incorrect replay of WAL records for GIN index updates.
- Fix TOAST-related data corruption during CREATE TABLE dest AS
SELECT - FROM src or INSERT INTO dest SELECT * FROM src.
- 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.
- Fix incorrect management of placeholder variables in nestloop joins.
This bug is known to lead to "variable not found in subplan target
list" planner errors, and could possibly result in wrong query
output when outer joins are involved.
- Fix window functions that sort by expressions involving aggregates.
- Fix "MergeAppend child's targetlist doesn't match MergeAppend"
planner errors.
- Fix index matching for operators with both collatable and
noncollatable inputs. In 9.1.0, an indexable operator that has a
non-collatable left-hand input type and a collatable right-hand input
type would not be recognized as matching the left-hand column's index.
An example is the hstore ? text operator.
- Allow inlining of set-returning SQL functions with multiple OUT
parameters.
- Don't trust deferred-unique indexes for join removal.
- 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.
- Fix IF EXISTS to work correctly in "DROP OPERATOR FAMILY".
- Disallow dropping of an extension from within its own script.
- Don't mark auto-generated types as extension members.
- Cope with invalid pre-existing search_path settings during "CREATE
EXTENSION".
- Avoid floating-point underflow while tracking buffer allocation
rate.
- Prevent autovacuum transactions from running in serializable mode.
Autovacuum formerly used the cluster-wide default transaction
isolation level, but there is no need for it to use anything higher
than READ COMMITTED, and using SERIALIZABLE could result in
unnecessary delays for other processes.
- Ensure walsender processes respond promptly to SIGTERM.
- Exclude "postmaster.opts" from base backups.
- 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.
- Avoid platform-specific infinite loop in pg_dump.
- Fix compression of plain-text output format in pg_dump.
pg_dump has historically understood -Z with no -F switch to mean
that it should emit a gzip-compressed version of its plain text
output. Restore that behavior.
- Fix pg_dump to dump user-defined casts between auto-generated
types, such as table rowtypes.
- Fix missed quoting of foreign server names in pg_dump.
- Assorted fixes for pg_upgrade. Handle exclusion constraints correctly,
avoid failures on Windows, don't complain about mismatched toast table
names in 8.4 databases.
- In PL/pgSQL, allow foreign tables to define row types.
- Fix up conversions of PL/Perl functions' results.
Restore the pre-9.1 behavior that PL/Perl functions returning void
ignore the result value of their last Perl statement; 9.1.0 would
throw an error if that statement returned a reference. Also, make
sure it works to return a string value for a composite type, so
long as the string meets the type's input format. In addition,
throw errors for attempts to return Perl arrays or hashes when the
function's declared result type is not an array or composite type,
respectively. (Pre-9.1 versions rather uselessly returned strings
like ARRAY(0x221a9a0) or HASH(0x221aa90) in such cases.)
- Ensure PL/Perl strings are always correctly UTF8-encoded.
- Use the preferred version of xsubpp to build PL/Perl, not
necessarily the operating system's main copy.
- Correctly propagate SQLSTATE in PL/Python exceptions.
- Do not install PL/Python extension files for Python major versions
other than the one built against.
- Change all the "contrib" extension script files to report a useful
error message if they are fed to psql. This should help teach people
about the new method of using "CREATE EXTENSION" to load these files.
In most cases, sourcing the scripts directly would fail anyway, but
with harder-to-interpret messages.
- Fix incorrect coding in "contrib/dict_int" and "contrib/dict_xsyn".
- Remove "contrib/sepgsql" tests from the regular regression test
mechanism. Since these tests require root privileges for setup, they're
impractical to run automatically. Switch over to a manual approach
instead, and provide a testing script to help with that.
- Fix assorted errors in "contrib/unaccent"'s configuration file
parsing.
- Honor query cancel interrupts promptly in pgstatindex().
- Revert unintentional enabling of WAL_DEBUG. Fortunately, as debugging
tools go, this one is pretty cheap; but it's not intended to be enabled
by default, so revert.
- 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.
* debian/rules: Fix build failure for binary-indep-only builds.
(Closes: #646079)
.
postgresql-9.1 (9.1.1-3) unstable; urgency=low
.
* debian/rules: Build with LINUX_OOM_ADJ=0 on Linux, to allow the OOM killer
to slay the backends when the postmaster gets marked as unkillable.
(LP: #854590)
.
postgresql-9.1 (9.1.1-2) unstable; urgency=low
.
[ Peter Eisentraut ]
* Fix FTBFS twice with dpkg-dev >= 1.16.1, because of leftover file
src/backend/gettext-files. Clean that one explicitly. (Closes: #643645)
* Fix lintian reports: (Closes: #643646)
- brace-expansion-in-debhelper-config-file
- maintainer-script-without-set-e
.
[ Martin Pitt ]
* debian/*.install, debian/rules: Compress manpages in debian/tmp instead of
just two binary packages and forgetting the others.
* Build a new postgresql-plpython3-9.1 package for Python 3 support. This
requires some reorganization of debian/rules to do multiple builds.
* debian/postgresql-9.1.postrm: Clean up /var/log/postgresql/ on purge.
Spotted by piuparts.
.
postgresql-9.1 (9.1.1-1~bpo50+1) lenny-backports-sloppy; urgency=low
.
* Rebuild for lenny-backports-sloppy.
Checksums-Sha1:
4f9ef99ba97608037fcb06213774d9546d9e9dc4 2489 postgresql-9.1_9.1.2-1~bpo50+1.dsc
7d57b96eb1c764ec234c72b70511a5f7e23fb2b0 15424814 postgresql-9.1_9.1.2.orig.tar.bz2
b87bee8cef8d067bd3345c0c07365dfbd48e1542 25054 postgresql-9.1_9.1.2-1~bpo50+1.debian.tar.gz
4016b218783a5cba4c009e0b59c3a5e90f52c34d 572124 libpq-dev_9.1.2-1~bpo50+1_i386.deb
ba0c0e5b9240728a29c1950854904a17e5e27900 488752 libpq5_9.1.2-1~bpo50+1_i386.deb
6e36733540dd0005c4d2e242acdc7058852890c2 433362 libecpg6_9.1.2-1~bpo50+1_i386.deb
edb2d8970e867ed3601fb2ed038fa9fdde49300f 602798 libecpg-dev_9.1.2-1~bpo50+1_i386.deb
cb54217bdf2b9dc2bb3ac27f0d01830ec951a35e 357796 libecpg-compat3_9.1.2-1~bpo50+1_i386.deb
c5e2580d713c55b856a6d1a915b112c389ae8d12 381916 libpgtypes3_9.1.2-1~bpo50+1_i386.deb
f90b6000b3ef90fe4892ba5ef9aed84f4004d0e0 5934568 postgresql-9.1_9.1.2-1~bpo50+1_i386.deb
6ff5f04a755f36b6d544781ee56239d1bf63ad82 7950158 postgresql-9.1-dbg_9.1.2-1~bpo50+1_i386.deb
53d1afb4011464fe50edefe0f9617499864c1433 1805088 postgresql-client-9.1_9.1.2-1~bpo50+1_i386.deb
c04c10003f13586b5a4e445dd3e0a781db50c5cc 1023708 postgresql-server-dev-9.1_9.1.2-1~bpo50+1_i386.deb
45f887c96a07620fcabdc7b0609e5cba26a1b49b 2860886 postgresql-doc-9.1_9.1.2-1~bpo50+1_all.deb
6f3a6833dfc397eb0f0477f92d59291e177ea7dc 770010 postgresql-contrib-9.1_9.1.2-1~bpo50+1_i386.deb
818b15ba71ea1ded8e862dec29cd664ac96734d9 399240 postgresql-plperl-9.1_9.1.2-1~bpo50+1_i386.deb
d6b5d62da1c8063caeac2de81d1429a64a829cef 406738 postgresql-plpython-9.1_9.1.2-1~bpo50+1_i386.deb
4654f6eac52cf276cbf66a5743802c4947e288d9 373476 postgresql-pltcl-9.1_9.1.2-1~bpo50+1_i386.deb
Checksums-Sha256:
262d9a6cca68182885b3f7f07920d3b8110f16719afd6531248ac3b8fee96ec2 2489 postgresql-9.1_9.1.2-1~bpo50+1.dsc
8d54ff514f5b2754e6e36b008c43d7bbf7daf541da608767cc5bdedb1de5db30 15424814 postgresql-9.1_9.1.2.orig.tar.bz2
8def2073f0df72e2d2370f6963c3783fc3cd158cc213845022494612f5ce6d0e 25054 postgresql-9.1_9.1.2-1~bpo50+1.debian.tar.gz
43c8ffac341a9ff9006468f529a11cc373898bf38e7e29f77ba4a59d14ddaa47 572124 libpq-dev_9.1.2-1~bpo50+1_i386.deb
7710f81280e4d81bf857a2a60de0f26a31ad5fd011f94df8050bf008f43d4857 488752 libpq5_9.1.2-1~bpo50+1_i386.deb
f7a27374c22215ce3cb2dc3c19301491350f65894eda7162974b4b1514341e84 433362 libecpg6_9.1.2-1~bpo50+1_i386.deb
75269207ecd7fd59b7f62db56a1812ad5267690d5e86aac1de3e4571231fde80 602798 libecpg-dev_9.1.2-1~bpo50+1_i386.deb
e65dba29ab5407e2943e9aa0287b54439af8bbe9774abe7217bb4be1b7b14a67 357796 libecpg-compat3_9.1.2-1~bpo50+1_i386.deb
4275fbba7d8d39d085797e09a7d85caa4a27bb87cd294da2bf4178ee26d5c3d0 381916 libpgtypes3_9.1.2-1~bpo50+1_i386.deb
d25c9417414b20a7fc4cbfc63d590998473057f41d1f5bcf0c82224ac4f7e6b7 5934568 postgresql-9.1_9.1.2-1~bpo50+1_i386.deb
842c1917e33be49dcc3e57907817792a9faa285de4f328bbd51b89cc05d604d1 7950158 postgresql-9.1-dbg_9.1.2-1~bpo50+1_i386.deb
8c8b0fbfe25867f0403cdaecddc713446d1e543c1bb8994dc44c97b0e781ce74 1805088 postgresql-client-9.1_9.1.2-1~bpo50+1_i386.deb
1e44d4a6c97023d17f8bf91658d17176633a776c46cea8b53ec0428c36231ace 1023708 postgresql-server-dev-9.1_9.1.2-1~bpo50+1_i386.deb
9000bcd61b2296a4cd402728b1926b5286c70eba565e283c48d8c39acf1d2dbc 2860886 postgresql-doc-9.1_9.1.2-1~bpo50+1_all.deb
a781f4227febf812a1b73a3f3c9a055d10a44be0959d190ee5848641b43e514e 770010 postgresql-contrib-9.1_9.1.2-1~bpo50+1_i386.deb
b79aea9e7107c4ea60653607b44012605f06de43aed9c81063f8e3b87dd43f9c 399240 postgresql-plperl-9.1_9.1.2-1~bpo50+1_i386.deb
1e8faefe811504d2b1d42a626622061dcac81532423261943c3f055aa2430d2c 406738 postgresql-plpython-9.1_9.1.2-1~bpo50+1_i386.deb
2b05ec738fa91e28038848244262e45eb7313264e8f3dd4cf408ce2aea815df2 373476 postgresql-pltcl-9.1_9.1.2-1~bpo50+1_i386.deb
Files:
5ac0267537f83f18d11dd198ec1c066e 2489 database optional postgresql-9.1_9.1.2-1~bpo50+1.dsc
7dbff52221954c46595313eb7f92c3e0 15424814 database optional postgresql-9.1_9.1.2.orig.tar.bz2
aa0fffee1091b5cbb6b21e85bc793f50 25054 database optional postgresql-9.1_9.1.2-1~bpo50+1.debian.tar.gz
63fec2baaf7acfc9b8768ffc0040187a 572124 libdevel optional libpq-dev_9.1.2-1~bpo50+1_i386.deb
7a90bb23de5e1d162769af0a8d781237 488752 libs optional libpq5_9.1.2-1~bpo50+1_i386.deb
2f9e80e7b7e8d4c9b67c52f88e34dc5e 433362 libs optional libecpg6_9.1.2-1~bpo50+1_i386.deb
5e6fa01464cf5e4702bedc75f25d30f4 602798 libdevel optional libecpg-dev_9.1.2-1~bpo50+1_i386.deb
ef3e420f5069b87795ed2f670fa22bfe 357796 libs optional libecpg-compat3_9.1.2-1~bpo50+1_i386.deb
96160281fea2f45477ce0c5e3ff98d02 381916 libs optional libpgtypes3_9.1.2-1~bpo50+1_i386.deb
080184bdab4d6fa8df03d2c77dbfb679 5934568 database optional postgresql-9.1_9.1.2-1~bpo50+1_i386.deb
7d9ba66f44e6b22c4356a7a51e985dd8 7950158 debug extra postgresql-9.1-dbg_9.1.2-1~bpo50+1_i386.deb
cf333bae81a1b67cf8ab1476dcadde7e 1805088 database optional postgresql-client-9.1_9.1.2-1~bpo50+1_i386.deb
9f93518fc686a946cfae50903955be35 1023708 libdevel optional postgresql-server-dev-9.1_9.1.2-1~bpo50+1_i386.deb
a816eb2e31d3a6dbfe91898d34655d03 2860886 doc optional postgresql-doc-9.1_9.1.2-1~bpo50+1_all.deb
b782e0d7aec28615efaae2049111eec4 770010 database optional postgresql-contrib-9.1_9.1.2-1~bpo50+1_i386.deb
92e634b5e007255d29ba78ec6f7ae66e 399240 database optional postgresql-plperl-9.1_9.1.2-1~bpo50+1_i386.deb
f25233e8892b4768ed6c44e2f743ebc6 406738 database optional postgresql-plpython-9.1_9.1.2-1~bpo50+1_i386.deb
efc53fd169946f401f47160ea0480de3 373476 database optional postgresql-pltcl-9.1_9.1.2-1~bpo50+1_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iQIcBAEBCAAGBQJO80dsAAoJEExaa6sS0qeuQlAP/1wMYRKiofeY0Eh/wKzyMtfB
Z6ct6N8e9lCKSnm38V0ucsTpqSz73QATvsDSs6/GHlhRNmn1DTOXvCWY4sZ8scVm
qqxswBr/WztHhHbIaK/w4RuSc7uUmKu5ruWyNAyg0YrnCIVwAD/pM89RZLCr3Tum
Ltu93y61nOrKxBleyn7bPRPBiCKnLxnadPF72Nz8MhJ7H72FkFBLB1PqkbltL5Wr
HkTkGxZtvpzWPSCuRkqF0RyCrtm6RID0M9kEFwhU2IUOAlNMeneiGAOR63qCgo7y
iXhxIJq8O7Gszg/ROrr6fxY7fr6vW+16/0o3kh8TXySj8cD6fZNkYnr8YMdxwkeQ
7Ez47FZCAV+3VRQ24FSi74umU3rnasIis3YxrNVMhZ9GR1xxIliVTNyEv1jMiopu
tXPRZKL9RE3LX7I1b4h0t7ailaSBSL9p6Y1cqXDBxbHE+4yp8sw72xlyK8/v0dwF
jZLZZO1H9DM6/mGEsKaQH9H6/1cwfLhhkZoTiyjivdGgMCpIll0Ly5PXI4Fps4kC
x7VaDUzfgWFJA8YUZtWb/wDFvm0lqq6PTxnRfVdIa+bmWsfwrx/UT+pPC0H2lEeJ
gJGIZNvmnCMH+iAk5l6HQcXEfSY4/T9CompcL7cx7qSpLsayM0DsIWZtrUTF3ugr
d8KNv7FvmvtYF1U3I0Or
=5w5J
-----END PGP SIGNATURE-----
Accepted:
libecpg-compat3_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libecpg-compat3_9.1.2-1~bpo50+1_i386.deb
libecpg-dev_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libecpg-dev_9.1.2-1~bpo50+1_i386.deb
libecpg6_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libecpg6_9.1.2-1~bpo50+1_i386.deb
libpgtypes3_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libpgtypes3_9.1.2-1~bpo50+1_i386.deb
libpq-dev_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libpq-dev_9.1.2-1~bpo50+1_i386.deb
libpq5_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/libpq5_9.1.2-1~bpo50+1_i386.deb
postgresql-9.1-dbg_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-9.1-dbg_9.1.2-1~bpo50+1_i386.deb
postgresql-9.1_9.1.2-1~bpo50+1.debian.tar.gz
to main/p/postgresql-9.1/postgresql-9.1_9.1.2-1~bpo50+1.debian.tar.gz
postgresql-9.1_9.1.2-1~bpo50+1.dsc
to main/p/postgresql-9.1/postgresql-9.1_9.1.2-1~bpo50+1.dsc
postgresql-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-client-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-client-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-contrib-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-contrib-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-doc-9.1_9.1.2-1~bpo50+1_all.deb
to main/p/postgresql-9.1/postgresql-doc-9.1_9.1.2-1~bpo50+1_all.deb
postgresql-plperl-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-plperl-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-plpython-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-plpython-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-pltcl-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-pltcl-9.1_9.1.2-1~bpo50+1_i386.deb
postgresql-server-dev-9.1_9.1.2-1~bpo50+1_i386.deb
to main/p/postgresql-9.1/postgresql-server-dev-9.1_9.1.2-1~bpo50+1_i386.deb
Reply to: