Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog - Mailing list pgsql-hackers

From G. Anthony Reina
Subject Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Date
Msg-id 37CD5A9C.691458B5@nsi.edu
Whole thread Raw
In response to Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> Vacuum doesn't vacuum functions (AFAIK).  It does, however, use the type
> information about columns of tables that it's vacuuming --- at least it
> does in vacuum analyze mode, not sure about plain vacuum.  That's why
> I'm suspicious that you have somewhere a forgotten table that has a
> column of circle type...

Nope. I'm absolutely, positively, 100% sure that no table uses the type
'circle'. However, we're going to name the table 'circles' instead and
re-build the database by dumping, destroying, re-creating, and dumping back
in. IT just makes the most sense.

Thanks for the help.
-Tony





pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: [PATCHES] patch for 6.5.X tree (fwd)
Next
From: "Hub.Org News Admin"
Date:
Subject: ...