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

From: "nednieuws | charles" <charles(at)nednieuws(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Error with pg_restore (parse error at or near "BY" at character 144
Date: 2004-02-02 04:05:52
Message-ID: 004301c3e941$dd9ee530$9900000a@ash
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-02 05:15:14 Re: Error with pg_restore (parse error at or near "BY" at character 144
Previous Message Tom Lane 2004-02-02 03:53:22 Re: partial indexes