Thread: pg_dump bug

pg_dump bug

From
Martín Marqués
Date:
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
 
-----------------------------------------------------------------


Re: pg_dump bug

From
Tom Lane
Date:
Martín Marqués <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