<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
Mike Mascari wrote:<br>
<blockquote type="cite" cite="mid:3C0598FB(dot)B8C86721(at)mascari(dot)com">
<pre wrap="">Dado Feigenblatt wrote:<br></pre>
<blockquote type="cite">
<pre wrap="">When passing a pg_dump'ed file to psql I was getting unexpected error<br>messages.<br>When I examined the file contents, I noticed it was trying to change<br>permissions for 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>for 7.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(at)mascari(dot)com">mascarm(at)mascari(dot)com</a></pre>
</blockquote>
I'm running 7.1.1<br>
I was hoping 7.2 would come 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(at)wildbrain(dot)com">dado(at)wildbrain(dot)com</a> San Francisco, CA.<br></pre>
<br>
</body>
</html>