Re: owner of type 'mmm' apperars to be invalid

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