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

From nednieuws | charles
Subject Error with pg_restore (parse error at or near "BY" at character 144
Date
Msg-id 004301c3e941$dd9ee530$9900000a@ash
Whole thread Raw
Responses Re: Error with pg_restore (parse error at or near "BY" at character 144  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: partial indexes
Next
From: Tom Lane
Date:
Subject: Re: Error with pg_restore (parse error at or near "BY" at character 144