Thread: pg_dump and order of events

pg_dump and order of events

From
Dado Feigenblatt
Date:
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.




Re: pg_dump and order of events

From
Mike Mascari
Date:
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

Re: pg_dump and order of events

From
Dado Feigenblatt
Date:
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 /> 

Re: pg_dump and order of events

From
Mike Mascari
Date:
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
> > types
> >
> 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?

Yes, I believe so.

Mike Mascari
mascarm@mascari.com