From: Richard Huxton <dev@archonet.com>
To: cristi <cristi@dmhi.ct.ro>
To: pgsql-sql@postgresql.org
Subject: Re: owner of type 'mmm' apperars to be invalid
Date: Tue, 5 Nov 2002 10:57:55 +0000
Message-ID: <200211051057.56017.dev@archonet.com> (raw)
In-Reply-To: <003d01c28490$310d2fa0$7201a8c0@aaa>
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
On Tuesday 05 Nov 2002 5:57 am, cristi wrote:
> When I'm trying to make pg_dump on a data base I have this message:
>
> WARNING: owner of type 'mmm' apperars to be invalid
> WARNING: owner of type 'eee' apperars to be invalid
> WARNING: owner of type 'refcursor' apperars to be invalid
>
> Where are these object and how can I destroy its?
richardh=> select oid,typname,typowner from pg_type where typname='refcursor';
oid | typname | typowner
------+-----------+----------
1790 | refcursor | 1
richardh=> select * from pg_user where usesysid=1;
usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd
| valuntil
----------+----------+-------------+----------+----------+-----------+----------+----------
postgres | 1 | t | t | t | t |
I'd recommend you add a user with the required id, then dump the database and
fix the dump as required. The owner of "refcursor" should be postgres (or
whatever the system user is called) - if that user has been deleted, I'd be
surprised that's the only errors you get.
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, cristi@dmhi.ct.ro
Subject: Re: owner of type 'mmm' apperars to be invalid
In-Reply-To: <200211051057.56017.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox