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