Your message dated Tue, 7 Jun 2005 09:48:54 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Closing bugs that only affect woody
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)
--------------------------------------
Received: (at submit) by bugs.debian.org; 11 Sep 2002 06:27:46 +0000
>From [EMAIL PROTECTED] Wed Sep 11 01:27:46 2002
Return-path: <[EMAIL PROTECTED]>
Received: from p5082048e.dip0.t-ipconnect.de (finlandia.infodrom.north.de)
[80.130.4.142]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 17p0yX-0002od-00; Wed, 11 Sep 2002 01:27:46 -0500
Received: by finlandia.infodrom.north.de (Postfix, from userid 501)
id 519DC10DCF; Wed, 11 Sep 2002 08:27:15 +0200 (CEST)
Received: by finlandia.infodrom.north.de (Postfix, from userid 10)
id 6E5B010DE1; Wed, 11 Sep 2002 03:07:35 +0200 (CEST)
Received: from luonnotar (localhost [127.0.0.1])
by finlandia.infodrom.north.de (Postfix) with SMTP id 57C0EDDD0B
for <[EMAIL PROTECTED]>; Wed, 11 Sep 2002 03:07:35 +0200 (CEST)
Mailbox-Line: From [EMAIL PROTECTED] Wed Sep 11 03:05:26 2002
Received: by luonnotar.infodrom.org (Postfix, from userid 1001)
id 3E520366AD6; Wed, 11 Sep 2002 03:05:26 +0200 (CEST)
Received: from master.debian.org (master.debian.org [65.125.64.135])
by luonnotar.infodrom.org (Postfix) with ESMTP id 2C543366AD6
for <[EMAIL PROTECTED]>; Wed, 11 Sep 2002 03:05:25 +0200 (CEST)
Received: from joey by master.debian.org with local (Exim 3.12 1 (Debian))
id 17ovwa-00083R-00; Tue, 10 Sep 2002 20:05:24 -0500
Received: from nautilus.3node.com [62.245.184.18]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 17ovwZ-00083L-00; Tue, 10 Sep 2002 20:05:23 -0500
Received: from marvin.palfrader.org (marvin.oeknet.mhn.de [10.151.2.20])
(using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits))
(Client CN "marvin.palfrader.org", Issuer "Peter Palfrader" (verified
OK))
by nautilus.3node.com (Postfix) with ESMTP id 00648123001
for <[EMAIL PROTECTED]>; Wed, 11 Sep 2002 03:05:13 +0200 (CEST)
Received: from valiant.palfrader.org (valiant.oeknet.mhn.de [10.151.2.120])
(using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits))
(Client CN "valiant.palfrader.org", Issuer "Peter Palfrader" (verified
OK))
by marvin.palfrader.org (Postfix) with ESMTP id 61BFF13946
for <[EMAIL PROTECTED]>; Wed, 11 Sep 2002 03:05:12 +0200 (CEST)
Received: by valiant.palfrader.org (Postfix, from userid 1000)
id 642231FA0F9; Wed, 11 Sep 2002 03:05:11 +0200 (CEST)
Date: Wed, 11 Sep 2002 03:05:11 +0200
From: Peter Palfrader <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: postgres upgrade report
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="82I3+IH0IqGh5yIs"
Content-Disposition: inline
User-Agent: Mutt/1.4i
X-PGP: 1024R/D1A3A329 BB A2 DC FE D7 D2 09 BF 93 46 36 6F C1 A4 41 1A
X-GPG: 1024D/94C09C7F 5B00 C96D 5D54 AEE1 206B AF84 DE7A AF6E 94C0 9C7F
X-Accept-Language: de, en
Sender: Martin Schulze <[EMAIL PROTECTED]>
Resent-From: [EMAIL PROTECTED]
Resent-Date: Wed, 11 Sep 2002 08:27:15 +0200
Resent-To: [EMAIL PROTECTED]
Resent-Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
--82I3+IH0IqGh5yIs
Content-Type: text/plain; charset=iso-8859-15
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Package: postgresl
Version: 7.2.1-2
Severity: grave
Moin Joey,
as I told you on IRC already I had some issues upgrading my databases
from potato's postgres to woody's. I thought it was some user error
on my side and given the time constraints I never investigated further.
Now that I investigate this issue in more detail I regret that I didn't.
There are two problems, one of them is a BUG.
- old SQL statements possibly no longer work with the new postgres. This
only happened if the statement was wrong in the first place like
=BB[..] WHERE foo =3D NULL=AB instead of the correct =BBWHERE foo IS NULL=
=AB.
- the other one is more serious.
I installed a plain potato with postgres (UNICODE as default charset)
and created this database:
CREATE TABLE country ( name VARCHAR(50) );
INSERT INTO country (name) VALUES ('Deutschland');
INSERT INTO country (name) VALUES ('=D6sterreich');
INSERT INTO country (name) VALUES ('Schweiz');
After upgrading my database is empty.
/usr/lib/postgresql/dumpall/
=3D=3D=3D <<< db.out >>> =3D=3D=3D
-- postgresql-dump on Wed Sep 11 00:25:14 UTC 2002 from version 6.5
\connect template1
select datdba into table tmp_pg_shadow from pg_database where datname=
=3D 'template1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
weasel 1000 f f f f \N \N
\.
\connect template1 postgres
create database weasel;
\connect weasel postgres
\connect - weasel
CREATE TABLE "country" (
"name" character varying(50));
COPY "country" FROM stdin;
Deutschland
=D6sterreich
Schweiz
\.
-- postgresql-dump completed on Wed Sep 11 00:25:15 UTC 2002
=3D=3D=3D <<< db.out >>> =3D=3D=3D
This dump can not be used to restore the database:
=3D=3D=3D <<< =3D=3D=3D >>> =3D=3D=3D
You are now connected to database template1 as user postgres.
create database weasel;
CREATE DATABASE
You are now connected to database weasel as user postgres.
You are now connected as new user weasel.
CREATE TABLE "country" (
"name" character varying(50));
CREATE
COPY "country" FROM stdin;
ERROR: copy: line 2, Invalid UNICODE character sequence found (0xd673)
lost synchronization with server, resetting connection
=3D=3D=3D <<< =3D=3D=3D >>> =3D=3D=3D
=09
I don't know of a workaround.
Please bounce this to the postgres maintainer (via [EMAIL PROTECTED])
unless you have a reason to not do this.
yours,
peter
--=20
PGP signed and encrypted | .''`. ** Debian GNU/Linux **
messages preferred. | : :' : The universal
| `. `' Operating System
http://www.palfrader.org/ | `- http://www.debian.org/
--82I3+IH0IqGh5yIs
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9fpbG3nqvbpTAnH8RAubHAJwLRbXaRFXFJCcozTdCDglq3reFKACcCIwj
j5PtiC5UGT1d80KQiMVP4G8=
=s2C7
-----END PGP SIGNATURE-----
--82I3+IH0IqGh5yIs--
---------------------------------------
Received: (at 160470-done) by bugs.debian.org; 7 Jun 2005 07:49:38 +0000
>From [EMAIL PROTECTED] Tue Jun 07 00:49:38 2005
Return-path: <[EMAIL PROTECTED]>
Received: from mail01.pironet-ndh.com [194.64.31.10]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DfYq8-0000wr-00; Tue, 07 Jun 2005 00:49:36 -0700
Received: from mail.fbn-dd.de (mail.fbn-dd.de [195.227.105.178])
by mail01.pironet-ndh.com (Postfix) with ESMTP id 6F3F637876;
Tue, 7 Jun 2005 09:48:55 +0200 (CEST)
Received: from sonne.intranet.fbn-dd.de
(192-168-0-1.transfer-000.intranet.fbn-dd.de [192.168.0.1])
by mail.fbn-dd.de (Postfix) with ESMTP
id 562BB1F96F; Tue, 7 Jun 2005 09:48:55 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
by sonne.intranet.fbn-dd.de (Postfix) with ESMTP
id 201391FA89; Tue, 7 Jun 2005 09:48:55 +0200 (CEST)
Received: from sonne.intranet.fbn-dd.de (localhost [127.0.0.1])
by localhost (AvMailGate-2.0.1.16) id 21109-56297235;
Tue, 07 Jun 2005 09:48:54 +0200
Received: from localhost.localdomain (10-28-130-200.intranet-28-130.fbn-dd.de
[10.28.130.200])
by sonne.intranet.fbn-dd.de (Postfix) with ESMTP
id 8BDF81F9F5; Tue, 7 Jun 2005 09:48:54 +0200 (CEST)
Received: by localhost.localdomain (Postfix, from userid 1000)
id B7B00300B; Tue, 7 Jun 2005 09:48:54 +0200 (CEST)
Date: Tue, 7 Jun 2005 09:48:54 +0200
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Closing bugs that only affect woody
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="L2Brqb15TUChFOBK"
Content-Disposition: inline
User-Agent: Mutt/1.5.9i
X-AntiVirus: checked by AntiVir MailGate (version: 2.0.1.16; AVE: 6.30.0.15;
VDF: 6.30.0.235; host: sonne)
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
X-CrossAssassin-Score: 4
--L2Brqb15TUChFOBK
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi!
This bug only affects the Debian Woody version of PostgreSQL. Now the
next stable Debian version "Sarge" is released, thus it does not make
any sense any more to keep them open.
Thanks and have a nice day,
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
--L2Brqb15TUChFOBK
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
iD8DBQFCpVFmDecnbV4Fd/IRArbTAJ9oiazDVlKpIZK9ZRi9RoZ2WR3ILwCdGZLX
4ORfiONUOAUih/3LKuYeEwE=
=BYdb
-----END PGP SIGNATURE-----
--L2Brqb15TUChFOBK--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
