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

Поиск
Список
Период
Сортировка
От nednieuws | charles
Тема Error with pg_restore (parse error at or near "BY" at character 144
Дата
Msg-id 004301c3e941$dd9ee530$9900000a@ash
обсуждение исходный текст
Ответы Re: Error with pg_restore (parse error at or near "BY" at character 144
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: partial indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error with pg_restore (parse error at or near "BY" at character 144