grant on sequence and pg_restore/pg_dump problem

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема grant on sequence and pg_restore/pg_dump problem
Дата
Msg-id 45E35B67.3030007@amsoftwaredesign.com
обсуждение исходный текст
Ответы Re: grant on sequence and pg_restore/pg_dump problem  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
Hi,
I did a quick search and didn't see anything on this, if I missed it
sorry in advance.
Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using
the 8.2 pg_restore and it was throwing errors when it was trying to
restore the permissions on the sequences.
basically the pg_restore was using the grant on sequence against the 8.1
database which of course 8.1 knows nothing about.

Is there a switch or something I missed that would allow this to work
properly on a 8.1 or lower database?
Or do I have to now have 2 versions of dump/restore in order to do this?

Thanks,

--
Tony


В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Writing oracle/postgress generic SQL
Следующее
От: "D. Dante Lorenso"
Дата:
Сообщение: Most efficient report of number of records in all tables?