Re: owner of type 'mmm' apperars to be invalid - Mailing list pgsql-novice

From cristi
Subject Re: owner of type 'mmm' apperars to be invalid
Date
Msg-id 038d01c28414$7fe631c0$7201a8c0@aaa
Whole thread Raw
In response to owner of type 'mmm' apperars to be invalid  ("cristi" <cristi@dmhi.ct.ro>)
List pgsql-novice

> > When I'm trying to make vaccum 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
> > VACUUM
>
> You sure that's not coming from pg_dump?  I don't believe VACUUM cares.

Yes. You right!

>
> Anyway, the problem is you dropped a user who still owns some objects.
> You need to recreate that user, or another user with the same SYSID.
>
> Or just drop the objects the user owned, if you don't need 'em anymore.

Which are these objects and how can I drop its?


pgsql-novice by date:

Previous
From: papapep
Date:
Subject: Re: Populating a database
Next
From: Bruno Wolff III
Date:
Subject: Re: Populating a database