Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to get rid of a type - Mailing list pgsql-general

From Tom Lane
Subject Re: Trying to get rid of a type
Date
Msg-id 28821.1023998236@sss.pgh.pa.us
Whole thread Raw
In response to Trying to get rid of a type  (Tom Jenkins <tjenkins@devis.com>)
Responses Re: Trying to get rid of a type
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Contrib reindex script:
Next
From: Justin Clift
Date:
Subject: jobs.postgresql.org - Who's interested?