Re: Trying to get rid of a type

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 ...

            regards, tom lane