Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: "cristi" <cristi@dmhi.ct.ro>, <pgsql-sql@postgresql.org>
Subject: Re: owner of type 'mmm' apperars to be invalid
Date: Tue, 5 Nov 2002 10:57:55 +0000
User-Agent: KMail/1.4.3
References: <003d01c28490$310d2fa0$7201a8c0@aaa>
In-Reply-To: <003d01c28490$310d2fa0$7201a8c0@aaa>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211051057.56017.dev@archonet.com>

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=3D> select oid,typname,typowner from pg_type where typname=3D'refc=
ursor';
 oid  |  typname  | typowner
------+-----------+----------
 1790 | refcursor |        1

richardh=3D> select * from pg_user where usesysid=3D1;
 usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |  pas=
swd=20=20
| valuntil
----------+----------+-------------+----------+----------+-----------+-----=
-----+----------
 postgres |        1 | t           | t        | t        | t         |=20

I'd recommend you add a user with the required id, then dump the database a=
nd=20
fix the dump as required. The owner of "refcursor" should be postgres (or=
=20
whatever the system user is called) - if that user has been deleted, I'd be=
=20
surprised that's the only errors you get.

--=20
  Richard Huxton