Accepted postgresql-7.4 1:7.4.23-0etch1 (source i386 all)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Fri, 31 Oct 2008 20:23:35 +0100
Source: postgresql-7.4
Binary: postgresql-plpython-7.4 postgresql-client-7.4 postgresql-7.4 postgresql-contrib-7.4 postgresql-doc-7.4 postgresql-plperl-7.4 postgresql-server-dev-7.4 postgresql-pltcl-7.4
Architecture: source i386 all
Version: 1:7.4.23-0etch1
Distribution: stable
Urgency: low
Maintainer: Martin Pitt <mpitt@debian.org>
Changed-By: Martin Pitt <mpitt@debian.org>
Description:
postgresql-7.4 - object-relational SQL database, version 7.4 server
postgresql-client-7.4 - front-end programs for PostgreSQL 7.4
postgresql-contrib-7.4 - additional facilities for PostgreSQL
postgresql-doc-7.4 - documentation for the PostgreSQL database management system
postgresql-plperl-7.4 - PL/Perl procedural language for PostgreSQL 7.4
postgresql-plpython-7.4 - PL/Python procedural language for PostgreSQL 7.4
postgresql-pltcl-7.4 - PL/Tcl procedural language for PostgreSQL 7.4
postgresql-server-dev-7.4 - development files for PostgreSQL 7.4 server-side programming
Changes:
postgresql-7.4 (1:7.4.23-0etch1) stable; urgency=low
.
* New upstream bug fix release 7.4.23:
- Fix backend crash when the client encoding cannot represent a
localized error message.
- Fix incorrect tsearch2 headline generation when single query item
matches first word of text.
- Fix improper display of fractional seconds in interval values when
using a non-ISO datestyle in an "--enable-integer-datetimes" build.
- Ensure SPI_getvalue and SPI_getbinval behave correctly when the
passed tuple and tuple descriptor have different numbers of columns.
This situation is normal when a table has had columns added or
removed, but these two functions didn't handle it properly. The
only likely consequence is an incorrect error indication.
- Fix ecpg's parsing of "CREATE USER".
* New upstream bug fix release 7.4.22:
- Fix datetime input functions to correctly detect integer overflow
when running on a 64-bit platform.
- Improve performance of writing very long log messages to syslog.
- Fix bug in backwards scanning of a cursor on a SELECT DISTINCT ON
query.
- Fix planner to estimate that GROUP BY expressions yielding boolean
results always result in two groups, regardless of the expressions'
contents. This is very substantially more accurate than the regular
GROUP BY estimate for certain boolean tests like "col" IS NULL.
- Improve pg_dump and pg_restore's error reporting after failure to
send a SQL command.
* New upstream bug fix release 7.4.21:
- Make pg_get_ruledef() parenthesize negative constants.
Before this fix, a negative constant in a view or rule might be
dumped as, say, -42::integer, which is subtly incorrect: it should
be (-42)::integer due to operator precedence rules. Usually this
would make little difference, but it could interact with another
recent patch to cause PostgreSQL to reject what had been a valid
"SELECT DISTINCT" view query. Since this could result in pg_dump
output failing to reload, it is being treated as a high-priority
fix. The only released versions in which dump output is actually
incorrect are 8.3.1 and 8.2.7.
* New upstream bug fix release 7.4.20:
- Fix conversions between ISO-8859-5 and other encodings to handle
Cyrillic "Yo" characters (e and E with two dots).
- Fix a few datatype input functions that were allowing unused bytes
in their results to contain uninitialized, unpredictable values.
This could lead to failures in which two apparently identical
literal values were not seen as equal, resulting in the parser
complaining about unmatched ORDER BY and DISTINCT expressions.
- Fix a corner case in regular-expression substring matching
(substring(string from pattern)). The problem occurs when there is a
match to the pattern overall but the user has specified a parenthesized
subexpression and that subexpression hasn't got a match. An example is
substring('foo' from 'foo(bar)?'). This should return NULL, since (bar)
isn't matched, but it was mistakenly returning the whole-pattern match
instead (ie, foo).
- Fix incorrect result from ecpg's PGTYPEStimestamp_sub() function.
- Fix longstanding "LISTEN"/"NOTIFY" race condition. In rare cases a
session that had just executed a "LISTEN" might not get a notification,
even though one would be expected because the concurrent transaction
executing "NOTIFY" was observed to commit later.
A side effect of the fix is that a transaction that has executed a
not-yet-committed "LISTEN" command will not see any row in
pg_listener for the "LISTEN", should it choose to look; formerly it
would have. This behavior was never documented one way or the
other, but it is possible that some applications depend on the old
behavior.
- Fix display of constant expressions in ORDER BY and GROUP BY.
An explictly casted constant would be shown incorrectly. This could
for example lead to corruption of a view definition during dump and
reload.
- Fix libpq to handle NOTICE messages correctly during COPY OUT.
This failure has only been observed to occur when a user-defined
datatype's output routine issues a NOTICE, but there is no
guarantee it couldn't happen due to other causes.
Files:
da5d71fe8b2d868413928dd8d22ff7e2 1134 misc optional postgresql-7.4_7.4.23-0etch1.dsc
4fb4096dff65d402df1c053de964adb3 10014112 misc optional postgresql-7.4_7.4.23.orig.tar.gz
4253797ec56aba1c7be2dbb1ffb7943f 34981 misc optional postgresql-7.4_7.4.23-0etch1.diff.gz
6b8f3fe0b1c941f26ed753fe9dd98911 1186230 doc optional postgresql-doc-7.4_7.4.23-0etch1_all.deb
e75233eb06a80b229742901328dd1f14 528560 libdevel optional postgresql-server-dev-7.4_7.4.23-0etch1_all.deb
5076d22aa2a87c06e63a17a9d5d892b0 3387440 misc optional postgresql-7.4_7.4.23-0etch1_i386.deb
c23aa1f2192843a01d5b87920914eebc 1113434 misc optional postgresql-client-7.4_7.4.23-0etch1_i386.deb
ecf27fdec47196b45645017540ca5640 571286 misc optional postgresql-contrib-7.4_7.4.23-0etch1_i386.deb
7a6cdf28a7ce9fd3b15d017ecce7c884 126048 misc optional postgresql-plperl-7.4_7.4.23-0etch1_i386.deb
b07a688a49899511fbf4eb6de814ae88 128416 misc optional postgresql-plpython-7.4_7.4.23-0etch1_i386.deb
05a3cd60ee4b35d59739e033fa275b0c 130284 misc optional postgresql-pltcl-7.4_7.4.23-0etch1_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkkauM4ACgkQDecnbV4Fd/LmzgCgrKZpp5xh8fgIAcGVsCsYuYr6
4+QAoO4DI6YhTWZCf40p8EN05W95fHwB
=ygxe
-----END PGP SIGNATURE-----
Accepted:
postgresql-7.4_7.4.23-0etch1.diff.gz
to pool/main/p/postgresql-7.4/postgresql-7.4_7.4.23-0etch1.diff.gz
postgresql-7.4_7.4.23-0etch1.dsc
to pool/main/p/postgresql-7.4/postgresql-7.4_7.4.23-0etch1.dsc
postgresql-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-7.4_7.4.23-0etch1_i386.deb
postgresql-7.4_7.4.23.orig.tar.gz
to pool/main/p/postgresql-7.4/postgresql-7.4_7.4.23.orig.tar.gz
postgresql-client-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-client-7.4_7.4.23-0etch1_i386.deb
postgresql-contrib-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-contrib-7.4_7.4.23-0etch1_i386.deb
postgresql-doc-7.4_7.4.23-0etch1_all.deb
to pool/main/p/postgresql-7.4/postgresql-doc-7.4_7.4.23-0etch1_all.deb
postgresql-plperl-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-plperl-7.4_7.4.23-0etch1_i386.deb
postgresql-plpython-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-plpython-7.4_7.4.23-0etch1_i386.deb
postgresql-pltcl-7.4_7.4.23-0etch1_i386.deb
to pool/main/p/postgresql-7.4/postgresql-pltcl-7.4_7.4.23-0etch1_i386.deb
postgresql-server-dev-7.4_7.4.23-0etch1_all.deb
to pool/main/p/postgresql-7.4/postgresql-server-dev-7.4_7.4.23-0etch1_all.deb
Reply to: