From: David Ford <firefighterblu3@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.
Date: Mon, 9 Jan 2006 18:03:19 -0500
Message-ID: <523e55a00601091503meae2ee2q8377ea70e0dda4d5@mail.gmail.com> (raw)
In-Reply-To: <8475.1136842678@sss.pgh.pa.us>
References: <523e55a00601091133u5769dedcy73a77a04ee85f917@mail.gmail.com>
<7646.1136838180@sss.pgh.pa.us>
<523e55a00601091301i61384c75n91124ab7437f3dd3@mail.gmail.com>
<8475.1136842678@sss.pgh.pa.us>
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 <tgl@sss.pgh.pa.us> wrote:
>
> David Ford <firefighterblu3@gmail.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: firefighterblu3@gmail.com
Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.
In-Reply-To: <523e55a00601091503meae2ee2q8377ea70e0dda4d5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox