grant on sequence and pg_restore/pg_dump problem

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: grant on sequence and pg_restore/pg_dump problem
Date: 2007-02-26 22:12:55
Message-ID: 45E35B67.3030007@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2007-02-26 22:20:07 Most efficient report of number of records in all tables?
Previous Message David Fetter 2007-02-26 22:02:55 Re: Writing oracle/postgress generic SQL