| From: | Tom Jenkins <tjenkins(at)devis(dot)com> |
|---|---|
| To: | PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Trying to get rid of a type |
| Date: | 2002-06-13 20:08:25 |
| Message-ID: | 1023998905.15160.33.camel@asimov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2002-06-13 at 15:57, Tom Lane wrote:
> Tom Jenkins <tjenkins(at)devis(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-13 20:33:30 | Re: extending Now() information |
| Previous Message | Larry Rosenman | 2002-06-13 20:01:10 | Re: extending Now() information |