pg_dump bug

Started by Martín Marquésover 24 years ago2 messages
#1Martín Marqués
martin@bugs.unl.edu.ar

Short! :-)

PostgreSQL version: 7.1.3

I do I dump of a database which has some views, rules, and different
permissions on each view.

The dump puts first the permissions and after that the view creation, so when
I import the dump back to the server (or another server) I get lts of errors,
and have to change the permission by hand.

Has this already been reported?

saludos... :-)

--
Porqu� usar una base de datos relacional cualquiera,
si pod�s usar PostgreSQL?
-----------------------------------------------------------------
Mart�n Marqu�s | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Martín Marqués (#1)
Re: pg_dump bug

=?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin@bugs.unl.edu.ar> writes:

PostgreSQL version: 7.1.3

The dump puts first the permissions and after that the view creation,

Are you certain you are using the 7.1.3 version of pg_dump, and not
something older? This was fixed in 7.1.3 according to the CVS logs...

regards, tom lane