[SQL] system view corrupted, i get "unexpected right parenthesis" for many system tables.

i encountered this when trying to do a pg_dumpall in preparation for moving from 8.0 to 8.1.Jaymale ~ # pg_dump -U postgres -d administration > psql-dbs.jan2006.dumppg_dump: SQL command failedpg_dump: Error message from server: ERROR:  unexpected right parenthesis pg_dump: The command was: SELECT t

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

options left to try but i might be reduced to stitching together COPYs and system tables from an older backup. On 1/9/06, Tom Lane <[EMAIL PROTECTED]> wrote: David Ford <[EMAIL PROTECTED]> writes:> i encountered this when trying to do a pg_dumpall in preparation for moving> from 8.0

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

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 :) davidOn 1/9/06, Tom Lane <[EMAIL PROTECTED]> wrote: Da