pg_dump and order of events
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?
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.
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
<!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.B8C86721@mascari.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@mascari.com">mascarm@mascari.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@wildbrain.com">dado@wildbrain.com</a> San Francisco, CA.<br></pre>
<br>
</body>
</html>
Dado Feigenblatt wrote:
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 for 7.1.3 reads:
..
pg_dump fixes for GRANT/REVOKE/comments on views, user-defined
typesI'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?
Yes, I believe so.
Mike Mascari
mascarm@mascari.com