X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7EDA19DC811 for ; Mon, 9 Jan 2006 19:03:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05552-06 for ; Mon, 9 Jan 2006 19:03:23 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by postgresql.org (Postfix) with ESMTP id F3A079DC9C9 for ; Mon, 9 Jan 2006 19:03:17 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i21so3449928wra for ; Mon, 09 Jan 2006 15:03:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=c5NFYucpcYRnm1OBHr6qzH7vXsVJC/nEUpRwKxoWxTjRRscT70OY7w1qVEIpft3wW2tkpVys/Hhz0hqCRw/Dc7ZN/kDQK92Rpw2dk22oQQ9BZc6DHlJr1P8f5vMn2PZEMUWf90uQ+4eX9zDTkaey9rv1zCsrAZHcmsFPmEz2kMw= Received: by 10.65.52.3 with SMTP id e3mr2841426qbk; Mon, 09 Jan 2006 15:03:19 -0800 (PST) Received: by 10.65.249.18 with HTTP; Mon, 9 Jan 2006 15:03:19 -0800 (PST) Message-ID: <523e55a00601091503meae2ee2q8377ea70e0dda4d5@mail.gmail.com> Date: Mon, 9 Jan 2006 18:03:19 -0500 From: David Ford To: pgsql-sql@postgresql.org Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. In-Reply-To: <8475.1136842678@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_21042_20922770.1136847799684" References: <523e55a00601091133u5769dedcy73a77a04ee85f917@mail.gmail.com> <7646.1136838180@sss.pgh.pa.us> <523e55a00601091301i61384c75n91124ab7437f3dd3@mail.gmail.com> <8475.1136842678@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.297 required=5 tests=[AWL=0.296, HTML_MESSAGE=0.001] X-Spam-Score: 0.297 X-Spam-Level: X-Archive-Number: 200601/39 X-Sequence-Number: 23828 ------=_Part_21042_20922770.1136847799684 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline that's ok, i found a working solution with 8.0.5 +pg-hier (8.0.1 wouldn't work + or -pg-hier), so i got things dumped, upgraded, and running. thank you to you and the guys on #postgresql very much for your assistance :) david On 1/9/06, Tom Lane wrote: > > David Ford writes: > > i've tried with and without the hier patch and neither seems to work. > > I was afraid of that: you've got some views created with the patch > installed and some with it not installed. > > > i have a few options left to try but i might be reduced to stitching > together > > COPYs and system tables from an older backup. > > It should be possible to manually correct the bogus entries. Basically > what the patch does is add a field to the QUERY structure, whose name I > forget but comparing working and non-working ev_action strings should > expose it. (It's probably near the end of the string.) If you delete > the field (text ":fieldname <> ") from the non-working ev_action strings > you should be able to get to a state where all the views will dump in a > non-hier build. > > regards, tom lane > -- Gay/Firefighter/EMT/Geek in 06451, USA It's the ideals of Linux and Open Source that are amazing, it embodies what WE want, not what is marketed Once you lose the greatest of all things, it's the memories you cherish for all time. He was the best, I could have been better. ------=_Part_21042_20922770.1136847799684 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline that's ok, i found a working solution with 8.0.5 +pg-hier (8.0.1 wouldn't w= ork + or -pg-hier), so i got things dumped, upgraded, and running.  th= ank you to you and the guys on #postgresql very much for your assistance :)=

david

On 1/9/06, Tom Lane <tgl@s= ss.pgh.pa.us> wrote:
David Ford <firefighterblu3= @gmail.com> writes:
> i've tried with and without the hier pat= ch and neither seems to work.

I was afraid of that: you've got some = views created with the patch
installed and some with it not installed.

> i have a few opti= ons left to try but i might be reduced to stitching together
> COPYs = and system tables from an older backup.

It should be possible to man= ually correct the bogus entries.  Basically
what the patch does is add a field to the QUERY structure, whose name I=
forget but comparing working and non-working ev_action strings shouldexpose it.  (It's probably near the end of the string.) &n= bsp;If you delete
the field (text ":fieldname <> ") from the non-working = ev_action strings
you should be able to get to a state where all the vie= ws will dump in a
non-hier build.

     &= nbsp;           &nbs= p;      regards, tom lane



--
Gay/Firefighter/EMT= /Geek in 06451, USA
It's the ideals of Linux and Open Source that are am= azing, it embodies what WE want, not what is marketed

Once you lose = the greatest of all things, it's the memories you cherish for all time.&nbs= p; He was the best, I could have been better. ------=_Part_21042_20922770.1136847799684--