470,836 Members | 1,897 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,836 developers. It's quick & easy.

Error with pg_restore (parse error at or near "BY" at character 144

What does this error mean:

pg_restore: creating TABLE author
pg_restore: creating SEQUENCE author_id
pg_restore: [archiver (db)] could not execute query: ERROR: parser: parse error at or near "BY" at character 144
pg_restore: *** aborted because of error

The line in question is:

GRANT ALL ON TABLE author TO GROUP dvnl;
[...]
);

^A^A
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;

^A^A

The command used to restore the db:

pg_restore --dbname=dvnl --format=t --verbose --username=dvnl --no-privileges --no-owner dvnldump.tar

The source db is PostgreSQL 7.4 and the target db is 7.3.3
--
Regards, Charels.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #1
1 2086
"nednieuws | charles" <ch*****@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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by ian justice | last post: by
6 posts views Thread by vigi98 | last post: by
5 posts views Thread by Denis Petronenko | last post: by
reply views Thread by Tyler | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.