From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Ford <firefighterblu3@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.
Date: Mon, 09 Jan 2006 16:37:58 -0500
Message-ID: <8475.1136842678@sss.pgh.pa.us> (raw)
In-Reply-To: <523e55a00601091301i61384c75n91124ab7437f3dd3@mail.gmail.com>
References: <523e55a00601091133u5769dedcy73a77a04ee85f917@mail.gmail.com>
<7646.1136838180@sss.pgh.pa.us>
<523e55a00601091301i61384c75n91124ab7437f3dd3@mail.gmail.com>
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
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: tgl@sss.pgh.pa.us, firefighterblu3@gmail.com
Subject: Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.
In-Reply-To: <8475.1136842678@sss.pgh.pa.us>
* 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