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(at)mascari(dot)com