Re: Trying to get rid of a type

On Thu, 2002-06-13 at 15:57, Tom Lane wrote:
> Tom Jenkins <tjenkins@devis.com> writes:
> > We misspelled the OPAQUE declaration in a function as opapue.
> > i've tried DROP TYPE opapue but got
> > ERROR:  RemoveType: type '_opapue' does not exist
> > when we dump the database we get a warning:
> > pg_dump: WARNING: owner of data type opapue appears to be invalid
>
> Sure, just delete the record from pg_type.  pg_dump should probably
> be ignoring the record altogether ...
>

Excellent, i'll delete it right now.  When it comes to touching the
system tables i've been described as well... hesitant (though in more
colorful language).
--

Tom Jenkins
Development InfoStructure
http://www.devis.com