Re: system view corrupted, i get "unexpected right parenthesis" for many system tables.

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