| From: | David Suela Fernández <dsuela(at)xsto(dot)info> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copy a database |
| Date: | 2004-08-26 08:19:45 |
| Message-ID: | 1093508385.22524.7.camel@yen-lo-wang |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El mié, 25-08-2004 a las 20:54, Tom Lane escribió:
> David Suela =?ISO-8859-1?Q?Fern=E1ndez?= <dsuela(at)xsto(dot)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(at)xsto(dot)info>
xsto.info <el acceso a la información>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gnari | 2004-08-26 08:27:59 | Re: Possible to insert quoted null value into integer field? |
| Previous Message | Janning Vygen | 2004-08-26 08:15:15 | Re: Constraints to Guarantee unique across tables with foreign key? |