Re: copy a database

El mié, 25-08-2004 a las 20:54, Tom Lane escribió:
> David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela@xsto.info> writes:
> > The problem is that pg_dump always give me the next error:
>
> > pg_dump: SQL command failed
> > pg_dump: Error message from server: ERROR:  relation "pg_user" does not exist
>
> Have you tried re-creating that view?
>
> CREATE VIEW pg_catalog.pg_user AS
>     SELECT
>         usename,
>         usesysid,
>         usecreatedb,
>         usesuper,
>         usecatupd,
>         '********'::text as passwd,
>         valuntil,
>         useconfig
>     FROM pg_shadow;
>
>             regards, tom lane

It return:
ERROR:  permission denied to create "pg_catalog.pg_user"
DETAIL:  System catalog modifications are currently disallowed.

How can i change this permissions?

--
David Suela Fernández <dsuela@xsto.info>
xsto.info <el acceso a la información>