Mike Mascari wrote:<br /><blockquote cite="mid:3C0598FB.B8C86721@mascari.com" type="cite"><pre wrap="">Dado
Feigenblattwrote:<br /></pre><blockquote type="cite"><pre wrap="">When passing a pg_dump'ed file to psql I was getting
unexpectederror<br />messages.<br />When I examined the file contents, I noticed it was trying to change<br
/>permissionsfor two views that would only be created later on.<br />Shouldn't pg_dump sort the order of these types of
events?<br/></pre></blockquote><pre wrap=""><br />The changelog<br />(<a class="moz-txt-link-freetext"
href="http://developer.postgresql.org/docs/postgres/release-7-1-3.html">http://developer.postgresql.org/docs/postgres/release-7-1-3.html</a>)<br
/>for7.1.3 reads:<br /><br />..<br />pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types<br />(Tom)<br
/>..<br/><br />So if you get a 7.1.3 version of pg_dump your problems may be<br />solved.<br /><br />Hope that
helps,<br/><br />Mike Mascari<br /><a class="moz-txt-link-abbreviated"
href="mailto:mascarm@mascari.com">mascarm@mascari.com</a></pre></blockquote>I'm running 7.1.1<br /> I was hoping 7.2
wouldcome out before I needed to upgrade.<br /> However, I might be able to run the new pg_dump with my 7.1.1 server,
right?<br/><br /> Thanks.<br /><pre class="moz-signature" cols="$mailwrapcol">-- <br />Dado Feigenblatt
Wild Brain, Inc. <br />Technical Director (415) 216-2053<br /><a
class="moz-txt-link-abbreviated"href="mailto:dado@wildbrain.com">dado@wildbrain.com</a>
SanFrancisco, CA.<br /></pre><br />