Your message dated Sat, 14 Apr 2007 12:32:05 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#417160: fixed in postgresql-8.2 8.2.3-4
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: postgresql-8.2
Version: 8.2.3-2
Severity: serious
Hi,
your package failed to build from source.
| Automatic build of postgresql-8.2_8.2.3-2 on odin by sbuild/sparc 98-farm
| Build started at 20070331-1633
| ******************************************************************************
| Checking available source versions...
| Fetching source files...
| Reading Package Lists...
| Building Dependency Tree...
| Need to get 12.2MB of source archives.
| Get:1 http://sinclair.farm.ftbfs.de experimental/main postgresql-8.2 8.2.3-2
(dsc) [1104B]
| Get:2 http://sinclair.farm.ftbfs.de experimental/main postgresql-8.2 8.2.3-2
(tar) [12.2MB]
| Get:3 http://sinclair.farm.ftbfs.de experimental/main postgresql-8.2 8.2.3-2
(diff) [27.4kB]
| Fetched 12.2MB in 1s (10.1MB/s)
| Download complete and in download only mode
| ** Using build dependencies supplied by package:
| Build-Depends: debhelper (>= 5.0.37.2), cdbs (>= 0.4.43), bison, perl (>=
5.8), libperl-dev, tk8.4-dev, flex, libreadline5-dev (>= 4.2), libssl-dev,
zlib1g-dev | libz-dev, libpam0g-dev | libpam-dev, libxml2-dev, libkrb5-dev,
libxslt1-dev, python-dev, python-central (>= 0.5), gettext, bzip2
| Checking for already installed source dependencies...
| debhelper: missing
| Using default version 5.0.42 (Priority: 990)
| cdbs: missing
| Using default version 0.4.48 (Priority: 990)
| bison: missing
| Using default version 1:2.3.dfsg-4 (Priority: 990)
| perl: already installed (5.8.8-7 >= 5.8 is satisfied)
| libperl-dev: missing
| Using default version 5.8.8-7 (Priority: 990)
| tk8.4-dev: missing
| Using default version 8.4.12-1 (Priority: 990)
| flex: missing
| Using default version 2.5.33-11 (Priority: 990)
| libreadline5-dev: missing
| Using default version 5.2-2 (Priority: 990)
| libssl-dev: missing
| Using default version 0.9.8e-4 (Priority: 990)
| zlib1g-dev: missing
| Using default version 1:1.2.3-13 (Priority: 990)
| libz-dev: missing
| No default version. Virtual package?
| libpam0g-dev: missing
| Using default version 0.79-4 (Priority: 990)
| libpam-dev: missing
| No default version. Virtual package?
| libxml2-dev: missing
| Using default version 2.6.27.dfsg-1 (Priority: 990)
| libkrb5-dev: missing
| Using default version 1.4.4-7 (Priority: 990)
| libxslt1-dev: missing
| Using default version 1.1.19-1 (Priority: 990)
| python-dev: missing
| Using default version 2.4.4-2 (Priority: 990)
| python-central: missing
| Using default version 0.5.12 (Priority: 990)
| gettext: missing
| Using default version 0.16.1-1 (Priority: 990)
| bzip2: already installed (1.0.3-6)
| Checking for source dependency conflicts...
[...]
| STATEMENT: alter table anothertab alter column atcol1 type boolean
| using case when atcol1 % 2 = 0 then true else false end;
| NOTICE: CREATE TABLE will create implicit sequence "t1_f1_seq" for serial
column "t1.f1"
| NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for
table "t1"
| NOTICE: drop cascades to composite type alter2.ctype
| NOTICE: drop cascades to type alter2.ctype
| NOTICE: drop cascades to type alter2.posint
| NOTICE: drop cascades to function alter2.plus1(integer)
| NOTICE: drop cascades to view alter2.v1
| NOTICE: drop cascades to rule _RETURN on view alter2.v1
| NOTICE: drop cascades to sequence alter2.t1_f1_seq
| NOTICE: drop cascades to default for table alter2.t1 column f1
| NOTICE: drop cascades to table alter2.t1
| NOTICE: drop cascades to constraint t1_f2_check on table alter2.t1
| ERROR: could not set permissions on directory "/no/such/location": No such
file or directory
| STATEMENT: CREATE TABLESPACE badspace LOCATION '/no/such/location';
| ERROR: tablespace "nosuchspace" does not exist
| STATEMENT: CREATE TABLE bar (i int) TABLESPACE nosuchspace;
| ERROR: tablespace "testspace" is not empty
| STATEMENT: DROP TABLESPACE testspace;
| NOTICE: drop cascades to table testschema.asexecute
| NOTICE: drop cascades to table testschema.asselect
| NOTICE: drop cascades to table testschema.foo
| LOG: received fast shutdown request
| LOG: shutting down
| LOG: database system is shut down
| make: *** [binary-predeb/postgresql-8.2] Error 1
| ******************************************************************************
| Build finished at 20070331-1712
| FAILED [dpkg-buildpackage died]
Full build log(s):
http://experimental.ftbfs.de/build.php?&ver=8.2.3-2&pkg=postgresql-8.2&arch=sparc
Gruesse,
--
Frank Lichtenheld <[EMAIL PROTECTED]>
www: http://www.djpig.de/
--- End Message ---
--- Begin Message ---
Source: postgresql-8.2
Source-Version: 8.2.3-4
We believe that the bug you reported is fixed in the latest version of
postgresql-8.2, which is due to be installed in the Debian FTP archive:
libecpg-compat2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libecpg-compat2_8.2.3-4_i386.deb
libecpg-dev_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libecpg-dev_8.2.3-4_i386.deb
libecpg5_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libecpg5_8.2.3-4_i386.deb
libpgtypes2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libpgtypes2_8.2.3-4_i386.deb
libpq-dev_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libpq-dev_8.2.3-4_i386.deb
libpq5_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/libpq5_8.2.3-4_i386.deb
postgresql-8.2_8.2.3-4.diff.gz
to pool/main/p/postgresql-8.2/postgresql-8.2_8.2.3-4.diff.gz
postgresql-8.2_8.2.3-4.dsc
to pool/main/p/postgresql-8.2/postgresql-8.2_8.2.3-4.dsc
postgresql-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-8.2_8.2.3-4_i386.deb
postgresql-client-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-client-8.2_8.2.3-4_i386.deb
postgresql-contrib-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-contrib-8.2_8.2.3-4_i386.deb
postgresql-doc-8.2_8.2.3-4_all.deb
to pool/main/p/postgresql-8.2/postgresql-doc-8.2_8.2.3-4_all.deb
postgresql-plperl-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-plperl-8.2_8.2.3-4_i386.deb
postgresql-plpython-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-plpython-8.2_8.2.3-4_i386.deb
postgresql-pltcl-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-pltcl-8.2_8.2.3-4_i386.deb
postgresql-server-dev-8.2_8.2.3-4_i386.deb
to pool/main/p/postgresql-8.2/postgresql-server-dev-8.2_8.2.3-4_i386.deb
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Martin Pitt <[EMAIL PROTECTED]> (supplier of updated postgresql-8.2 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Sat, 14 Apr 2007 13:52:28 +0200
Source: postgresql-8.2
Binary: libpq5 postgresql-doc-8.2 postgresql-server-dev-8.2
postgresql-contrib-8.2 libpgtypes2 libpq-dev postgresql-8.2
postgresql-client-8.2 libecpg5 libecpg-compat2 libecpg-dev postgresql-pltcl-8.2
postgresql-plpython-8.2 postgresql-plperl-8.2
Architecture: source i386 all
Version: 8.2.3-4
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description:
libecpg-compat2 - older version of run-time library for ECPG programs
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg5 - run-time library for ECPG programs
libpgtypes2 - shared library libpgtypes for PostgreSQL 8.2
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-8.2 - object-relational SQL database, version 8.2 server
postgresql-client-8.2 - front-end programs for PostgreSQL 8.2
postgresql-contrib-8.2 - additional facilities for PostgreSQL
postgresql-doc-8.2 - documentation for the PostgreSQL database management
system
postgresql-plperl-8.2 - PL/Perl procedural language for PostgreSQL 8.2
postgresql-plpython-8.2 - PL/Python procedural language for PostgreSQL 8.2
postgresql-pltcl-8.2 - PL/Tcl procedural language for PostgreSQL 8.2
postgresql-server-dev-8.2 - development files for PostgreSQL 8.2 server-side
programming
Closes: 308535 308827 353200 393148 400648 408070 408072 417160
Changes:
postgresql-8.2 (8.2.3-4) unstable; urgency=low
.
* First upload to unstable: Welcome, Lenny!
.
postgresql-8.2 (8.2.3-3) experimental; urgency=low
.
* debian/rules: Do not FTBFS on failed test suite on sparc. sparc throws a
'floating point exception' instead of a 'division by zero' error, which is
fine, but differs from expected string output. Closes: #417160
.
postgresql-8.2 (8.2.3-2) experimental; urgency=low
.
* debian/control: Add Perl dependency to p-8.2-plperl, to ensure that
creating plperl functions works (as opposed to plperlu, which only needs
libperl). (see bug #412135)
* debian/control: Do not mention nor suggest 'pgdocs' any more in p-doc's
description since pgdocs is only available for 7.4. (see bug #405097)
* debian/patches/04-timezone-symlinks.patch:
- Use the timezone database from the system tzdata instead of shipping our
own. Towards a single authoritative time zone database in Debian and
Ubuntu... :) (LP: #41159)
- Drop previous hardlink-to-symlink patch to zic, since that is irrelevant
now.
- debian/control: Add tzdata dependency.
* Add debian/patches/12-vacuum-cycle-hang.patch: Properly release our
semaphore lock before erroring out wit elog() to prevent deadlocks on
vacuum errors. Thanks to Heikki Linnakangas!
* debian/rules: Have a test suite failure fail the build again. Let's ignore
the old kernels on the Debian mips[el] buildds for now.
.
postgresql-8.2 (8.2.3-1) experimental; urgency=low
.
* New upstream bug fix release to fix regressions in 8.2.2:
- Remove overly-restrictive check for type length in constraints and
functional indexes.
- Fix optimization so MIN/MAX in subqueries can again use indexes.
.
postgresql-8.2 (8.2.2-1) experimental; urgency=low
.
* New upstream security and bug fix release:
- Fix security vulnerabilities that allowed connected users to
read backend memory.
The vulnerabilities involve suppressing the normal check that a SQL
function returns the data type it's declared to, and changing the
data type of a table column (CVE-2007-0555, CVE-2007-0556). These
errors can easily be exploited to cause a backend crash, and in
principle might be used to read database content that the user
should not be able to access.
- Fix not-so-rare-anymore bug wherein btree index page splits could
fail due to choosing an infeasible split point.
- Properly handle to_char('CC') for years ending in 00.
Year 2000 is in the twentieth century, not the twenty-first.
- "/contrib/tsearch2" localization improvements.
- Fix incorrect permission check in information_schema.key_column_usage
view.
The symptom is "relation with OID nnnnn does not exist" errors. To
get this fix without using "initdb", use "CREATE OR REPLACE VIEW"
to install the corrected definition found in
"share/information_schema.sql". Note you will need to do this in
each database.
- Improve "VACUUM" performance for databases with many tables.
- Fix for rare Assert() crash triggered by UNION.
- Fix potentially incorrect results from index searches using ROW
inequality conditions.
- Tighten security of multi-byte character processing for UTF8
sequences over three bytes long.
- Fix possible crashes when an already-in-use PL/pgSQL function is
updated.
- Improve PL/pgSQL handling of domain types.
- Fix possible errors in processing PL/pgSQL exception blocks.
* debian/control: postgresql-client-8.2 provides postgresql-client. This
avoids breaking all the reverse dependencies to p-c when the transitional
package gets removed. Closes: #400648
.
postgresql-8.2 (8.2.1-2) experimental; urgency=low
.
* debian/libpq-dev.install: Install missing pg_trace.h.
* debian/control: Remove -contrib's libpg-perl recommendation, nothing in
-contrib uses it any more. Thanks to Peter Eisentraut for spotting this.
Closes: #408070
* debian/control: Update -contrib package description for 8.2.
Closes: #408072
.
postgresql-8.2 (8.2.1-1) experimental; urgency=low
.
* New upstream bugfix release:
- Fix crash with SELECT ... LIMIT ALL (also LIMIT NULL).
- "Several /contrib/tsearch2" fixes (Teodor)
- Fix planner mistakes for outer join queries.
- Fix several problems in queries involving sub-SELECTs.
- Fix potential crash in SPI during subtransaction abort.
This affects all PL functions since they all use SPI.
- Improve build speed of PDF documentation.
- Re-add JST (Japan) timezone abbreviation.
- Improve optimization decisions related to index scans.
- Have psql print multi-byte combining characters as before, rather
than output as \u.
- Improve index usage of regular expressions that use parentheses.
This improves psql \d performance also.
- Make pg_dumpall assume that databases have public CONNECT
privilege, when dumping from a pre-8.2 server.
This preserves the previous behavior that anyone can connect to a
database if allowed by "pg_hba.conf".
.
postgresql-8.2 (8.2-1) experimental; urgency=low
.
* 8.2 final release.
* debian/control: Fix spelling of 'Tcl'. (See #401191)
* Added a watch file.
.
postgresql-8.2 (8.2~rc1-1) experimental; urgency=low
.
* Release candidate 1.
.
postgresql-8.2 (8.2~beta3-1) experimental; urgency=low
.
* New upstream beta release.
.
postgresql-8.2 (8.2~beta2-1) experimental; urgency=low
.
* New upstream beta release.
- Documents ~/.pgpass file in psql(1). Closes: #308535
- Document long --format values in pg_dump(1). Closes: #308827
- Does not output ' any more in HTML mode. Closes: #353200
* debian/patches/{03-gettext-domains.patch,11-pg_regress-socketpath.patch}:
Adapted to new upstream version.
.
postgresql-8.2 (8.2~beta1-2) experimental; urgency=low
.
* Move vacuumlo from -client to -contrib, since it is a contributed script.
Add appropriate Replaces:.
* debian/control: Fix libpq-dev dependency of -server-dev-8.2.
Closes: #393148
.
postgresql-8.2 (8.2~beta1-1) experimental; urgency=low
.
* First public beta release of 8.2, packaging based on current 8.1 tree.
* Major improvements and changes (see HISTORY for details):
- Improved sort performance with lower memory usage.
- More efficient locking with better concurency.
- New FILLFACTOR support for tables and indexes.
- Many query optimization improvements.
- More efficient vacuuming.
- Warm standby server enhancements.
- Monitoring, logging, and performance tuning additions.
- Query enhancements including RETURNING values, multi-VALUES,
- support, and self-joins for DELETE.
- More control over creating/dropping objects and inheritance.
- Index creation without blocking INSERT/UPDATE/DELETE.
- COPY TO support for SELECT statements.
- Array and aggregate improvements, including SQL:2003 statistical
- functions.
- Many /contrib improvements.
Files:
e6634cc087bb90de092d5ee5acfff405 1104 misc optional postgresql-8.2_8.2.3-4.dsc
e78baf334121cb6577c6014c57e0690e 27568 misc optional
postgresql-8.2_8.2.3-4.diff.gz
acb9facb38cf4dde7f315f33730b74f1 1712956 doc optional
postgresql-doc-8.2_8.2.3-4_all.deb
4903328f93ca2080ed349bbd71d9ffcc 342930 libdevel optional
libpq-dev_8.2.3-4_i386.deb
383aca70aa5226170e4b2e360759045a 280970 libs optional libpq5_8.2.3-4_i386.deb
c2f4afc60db65387fd0ccf064450b63f 190532 libs optional libecpg5_8.2.3-4_i386.deb
3185ca4137de40f8d4adda044d832f8e 363200 libdevel optional
libecpg-dev_8.2.3-4_i386.deb
d74ee69a6f1f457e7e0a90ac2ba5bdc1 171590 libs optional
libecpg-compat2_8.2.3-4_i386.deb
de4850f499ab3d9d884f6cf909afe49f 194548 libs optional
libpgtypes2_8.2.3-4_i386.deb
9a7ea8c4135fe7150d77934de065ce3a 4802366 misc optional
postgresql-8.2_8.2.3-4_i386.deb
0a6b5e786f97b22b79667ed8bc1163a2 1468848 misc optional
postgresql-client-8.2_8.2.3-4_i386.deb
07c6b259f06c9699884dde8359d5f79d 661610 libdevel optional
postgresql-server-dev-8.2_8.2.3-4_i386.deb
283b8e5e3d946efb095d6abd34ac2dec 646122 misc optional
postgresql-contrib-8.2_8.2.3-4_i386.deb
05e59df963e1faa9cc9ac52f091e8479 192380 misc optional
postgresql-plperl-8.2_8.2.3-4_i386.deb
530e78dfa4b6044714024518718f8dc7 183042 misc optional
postgresql-plpython-8.2_8.2.3-4_i386.deb
546f0f83110bce93f3ab2489c44e6bab 182404 misc optional
postgresql-pltcl-8.2_8.2.3-4_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGIMcmDecnbV4Fd/IRAh12AJ9x27vWIRaJiJnAbc95cxj5gGkZNQCghNVD
ZnFAd8myFSwV4KxetTVma+g=
=+AmE
-----END PGP SIGNATURE-----
--- End Message ---