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