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

From Tom Jenkins
Subject Re: Trying to get rid of a type
Date
Msg-id 1023998905.15160.33.camel@asimov
Whole thread Raw
In response to Re: Trying to get rid of a type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: extending Now() information
Next
From: Tom Lane
Date:
Subject: Re: extending Now() information