Postgres Pro
Downloads
Home   >   mailing lists

Re: Error with pg_restore (parse error at or near "BY" at character 144 - Mailing list pgsql-general

From Tom Lane
Subject Re: Error with pg_restore (parse error at or near "BY" at character 144
Date
Msg-id 28489.1075698914@sss.pgh.pa.us
Whole thread Raw
In response to Error with pg_restore (parse error at or near "BY" at character 144  ("nednieuws | charles" <charles@nednieuws.com>)
List pgsql-general
Tree view 
"nednieuws | charles" <charles@nednieuws.com> writes:
> The source db is PostgreSQL 7.4 and the target db is 7.3.3

pg_dump is not designed to handle downgrades --- its output is intended
to be loaded into pg_dump's own version or later.  You should expect to
have to hand-edit the output to load it into an older version.

            regards, tom lane

pgsql-general by date:

Previous
From: "nednieuws | charles"
Date:
Subject: Error with pg_restore (parse error at or near "BY" at character 144
Next
From: Stephen Robert Norris
Date:
Subject: Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0