471,354 Members | 2,121 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Lost views in a PostgreSQL 7.1. dump file ?

Hello,

A friend told me that the views are not in the dump file produced by
PostgreSQL 7.1.

After looking in the archives, it seems that PostgreSQL 7.1 pg_dumpall
had a bug that lost the views. Is there a corrected pg_dumpall file for
PostgreSQL 7.1 ?

Thanks in advance :-)

---------------------------------------
Bruno BAGUETTE - pg******@baguette.net
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #1
1 1380
"Bruno BAGUETTE" <pg******@baguette.net> writes:
A friend told me that the views are not in the dump file produced by
PostgreSQL 7.1.


I see no such problem in the CVS patch history for 7.1. There are
various other pg_dump bugs fixed in the dot-releases, so an update to
7.1.3 might be advisable ... but complete failure to report a view,
no. We'll need more details.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by lnd | last post: by
1 post views Thread by Richard Huxton | last post: by
2 posts views Thread by Jerry LeVan | last post: by
11 posts views Thread by Olivier Guilyardi | last post: by
7 posts views Thread by Jimmie H. Apsey | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.