Re: Bug #778: pg_dump crashes when dumping a view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mbravo(at)tag-ltd(dot)spb(dot)ru, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #778: pg_dump crashes when dumping a view
Date: 2002-09-20 21:55:28
Message-ID: 3863.1032558928@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> pg_dump crashes when trying to dump a certain database structure.

Looks like this was broken by a late change in the 7.2 querytree
structure. There is no comparable bug in 7.3devel (because that whole
piece of code got rewritten), but if you need a patch here it is.

> PostgreSQL version: 7.2.1-3 (Debian package version, that is, 3rd build)

I'd recommend updating to 7.2.2 while you're at it; this patch is
against the 7.2.2 version of ruleutils.c.

regards, tom lane

*** 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;
}

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Deron Brookins 2002-09-20 22:09:28 Re: Fix for PSQL 7.2.2 doesn't compile on OS X 10.2
Previous Message pgsql-bugs 2002-09-20 19:33:52 Bug #778: pg_dump crashes when dumping a view