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; 21 Sep 2002 19:36:01 +0000
>From [EMAIL PROTECTED] Sat Sep 21 14:36:01 2002
Return-path: <[EMAIL PROTECTED]>
Received: from (office.tag-ltd.spb.ru) [195.133.234.254]
by master.debian.org with esmtp (Exim 3.12 1 (Debian))
id 17sq2q-0000ep-00; Sat, 21 Sep 2002 14:36:00 -0500
Received: from mbravo by office.tag-ltd.spb.ru with local (Exim 3.35 #1
(Debian))
id 17sq2p-0008K1-00; Sat, 21 Sep 2002 23:35:59 +0400
Content-Type: text/plain; charset="KOI8-R"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: "Michael Bravo" <[EMAIL PROTECTED]>
To: "Debian Bug Tracking System" <[EMAIL PROTECTED]>
Subject: postgresql: pg_dump crashes while dumping a view
X-Mailer: reportbug 1.99.60
Date: Sat, 21 Sep 2002 23:35:59 +0400
Message-Id: <[EMAIL PROTECTED]>
Sender: Michael Bravo <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
Package: postgresql
Version: 7.2.1-3
Severity: important
Tags: upstream patch
In current version of 7.2.x PostgreSQL, there is a bug. If you create a
database, populate it with an attached test structure and then try to
pg_dump it, pg_dump will crash with an error. This bug is registered
under the number 778 in PostgreSQL bug database, and has been
acknowledged by Tom Lane, who also provided a patch for 7.2.2. He also
mentioned, that this behaviour is apparently not present in 7.3-dev
version, as this part of the code was rewritten there. I attach the
patch below, in hopes that it will be applied to 7.2.2 package and
postgresql in stable will have this bug fixed in this way.
*** src/backend/utils/adt/ruleutils.c.orig Sat Jun 15 14:38:10 2002
--- src/backend/utils/adt/ruleutils.c Fri Sep 20 17:37:07 2002
***************
*** 1608,1613 ****
--- 1608,1624 ----
if (!phony_equal(a->expr, b->expr, levelsup))
return false;
if (!phony_equal(a->result, b->result, levelsup))
+ return false;
+ return true;
+ }
+ if (IsA(expr1, NullTest))
+ {
+ NullTest *a = (NullTest *) expr1;
+ NullTest *b = (NullTest *) expr2;
+
+ if (!phony_equal(a->arg, b->arg, levelsup))
+ return false;
+ if (a->nulltesttype != b->nulltesttype)
return false;
return true;
}
Test database structure (can't attach properly due to a bug in
reportbug)
--
-- DB structure for project pg_crash - check of PostgreSQL error
-- when it works with some kind of structures.
--
-- $Id: db_schema.pgsql,v 1.1.1.1 2002/09/20 17:56:54 dars Exp $
--
--
-- Some elements
--
CREATE TABLE element (
id SERIAL, -- unique ID
name text NOT NULL UNIQUE, -- Name of Element
deleted bool NOT NULL DEFAULT FALSE, -- Deleted flag
PRIMARY KEY ( id )
);
--
-- Some variants of Elements
--
CREATE TABLE variant (
id SERIAL, -- unique ID
name text NOT NULL UNIQUE, -- Name of Variant
deleted bool NOT NULL DEFAULT FALSE, -- Deleted flag
PRIMARY KEY ( id )
);
--
-- Some measure units
--
CREATE TABLE unit (
id SERIAL, -- unique ID
name text NOT NULL UNIQUE, -- Name of Unit
deleted bool NOT NULL DEFAULT FALSE, -- Deleted flag
PRIMARY KEY ( id )
);
--
-- Cost sheet \ price list
--
CREATE TABLE cost_sheet (
id SERIAL, -- unique ID
element_id int4 NOT NULL, -- Element ref.
variant_id int4 NOT NULL, -- Variant ref.
unit_id int4 NOT NULL, -- Unit ref.
cost numeric(15,2) NOT NULL DEFAULT '0', -- Cost of 1 Unit of Element in
Variant
deleted bool NOT NULL DEFAULT FALSE, -- Deleted flag
UNIQUE ( element_id, unit_id, variant_id ),
PRIMARY KEY ( id ),
FOREIGN KEY ( element_id ) REFERENCES element ( id ),
FOREIGN KEY ( variant_id ) REFERENCES variant ( id ),
FOREIGN KEY ( unit_id ) REFERENCES unit ( id )
);
--
-- Assembly of Elements ( header )
--
CREATE TABLE assembly (
id SERIAL,
name text NOT NULL UNIQUE,
deleted bool NOT NULL DEFAULT FALSE,
PRIMARY KEY ( id )
);
--
-- Body of assembly
--
CREATE TABLE assembly_body (
id SERIAL,
assembly_id int4 NOT NULL,
cs_element_id int4 NOT NULL,
amount numeric(15,4) NOT NULL,
PRIMARY KEY ( id ),
FOREIGN KEY ( assembly_id ) REFERENCES assembly ( id ),
FOREIGN KEY ( cs_element_id ) REFERENCES cost_sheet ( id )
);
--
-- Main relation - Parent (header)
--
CREATE TABLE parent (
id SERIAL, -- unique ID
name text NOT NULL UNIQUE, -- Name of Parent
deleted bool NOT NULL DEFAULT FALSE, -- Deleted flag
PRIMARY KEY ( id )
);
--
-- Sequence - generate ID for body of Parent.
-- Its body contents assemblies and elements.
--
CREATE SEQUENCE position_id_seq;
--
-- Assemblies - part of parent body with names of Assembly
--
CREATE TABLE parent_assembly (
pos_id int4 NOT NULL DEFAULT nextval('position_id_seq'), -- unique ID
parent_id int4 NOT NULL, -- Parent ref.
name text NOT NULL, -- Name of
Assembly (just copied here)
amount numeric(15,4) NOT NULL DEFAULT '1', -- Amount
PRIMARY KEY ( pos_id ),
FOREIGN KEY ( parent_id ) REFERENCES parent ( id ) ON DELETE CASCADE
);
--
-- Elements - Part of parent body only with elements. Some of them maybe
attached to header's assembly
--
CREATE TABLE parent_element (
pos_id int4 NOT NULL DEFAULT nextval('position_id_seq'), -- unique ID
parent_id int4 NOT NULL, -- Parent ref.
cs_element_id int4 NOT NULL, -- Cost sheet
ref.
parent_assembly_id int4, -- Parent
Assembly ref.
amount numeric(15,4) NOT NULL DEFAULT '0', -- Amount
extra_charge_percent numeric(4,2) NOT NULL DEFAULT '0', -- Extra charge
in %
PRIMARY KEY ( pos_id ),
FOREIGN KEY ( parent_id ) REFERENCES parent ( id ) ON DELETE CASCADE,
FOREIGN KEY ( cs_element_id ) REFERENCES cost_sheet ( id )
);
CREATE VIEW parent_body_view AS
SELECT
j.pos_id,
j.parent_id,
j.name as assembly_name,
(SELECT element_id FROM cost_sheet WHERE id = j.cs_element_id) as
element_id,
(SELECT name FROM element WHERE id =
(SELECT element_id FROM cost_sheet WHERE id = j.cs_element_id)) as
element_name,
(SELECT name FROM unit WHERE id =
(SELECT unit_id FROM cost_sheet WHERE id = j.cs_element_id)) as
element_unit,
j.cs_element_id,
j.amount,
(SELECT variant_id FROM cost_sheet WHERE id = j.cs_element_id) as
variant_id,
j.extra_charge_percent,
(SELECT cost FROM cost_sheet WHERE id = j.cs_element_id) as cost,
CASE
WHEN j.parent_assembly_id IS NULL
THEN j.pos_id
ELSE j.parent_assembly_id
END AS p_id,
CASE
WHEN j.parent_assembly_id IS NULL
THEN 'assembly'
ELSE 'element'
END AS type
FROM
(parent_assembly NATURAL FULL JOIN parent_element) j
;
-- System Information:
Debian Release: 3.0
Architecture: i386
Kernel: Linux office.tag-ltd.spb.ru 2.2.17 #2 Wed Oct 18 18:22:14 MSD 2000 i686
Locale: LANG=ru_RU.KOI8-R, LC_CTYPE=ru_RU.KOI8-R
Versions of packages postgresql depends on:
ii adduser 3.47 Add and remove users and groups
ii debianutils 1.16.3 Miscellaneous utilities specific t
ii libc6 2.2.5-14 GNU C Library: Shared libraries an
ii libpam0g 0.72-35 Pluggable Authentication Modules l
ii libpgsql2 7.2.1-3 Shared library libpq.so.2 for Post
ii libreadline4 4.3-4 GNU readline and history libraries
ii libssl0.9.6 0.9.6g-2 SSL shared libraries
ii postgresql-client 7.2.1-3 Front-end programs for PostgreSQL
ii procps 1:2.0.7-10 The /proc file system utilities.
ii python2.1 2.1.3-3 An interactive object-oriented scr
ii zlib1g 1:1.1.4-1 compression library - runtime
-- no debconf information
---------------------------------------
Received: (at 161815-done) by bugs.debian.org; 7 Jun 2005 07:49:38 +0000
>From [EMAIL PROTECTED] Tue Jun 07 00:49:37 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: 6
--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]
