Mike Mascari wrote:
Dado Feigenblatt wrote:
When passing a pg_dump'ed file to psql I was getting unexpected error
messages.
When I examined the file contents, I noticed it was trying to change
permissions for two views that would only be created later on.
Shouldn't pg_dump sort the order of these types of events?

The changelog
(http://developer.postgresql.org/docs/postgres/release-7-1-3.html)
for 7.1.3 reads:

..
pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types
(Tom)
..

So if you get a 7.1.3 version of pg_dump your problems may be
solved.

Hope that helps,

Mike Mascari
mascarm@mascari.com
I'm running 7.1.1
I was hoping 7.2 would come out before I needed to upgrade.
However, I might be able to run the new pg_dump with my 7.1.1 server, right?

Thanks.
-- 
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.