| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
| Cc: | "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog |
| Date: | 1999-09-01 13:23:32 |
| Message-ID: | 17513.936192212@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"G. Anthony Reina" <reina(at)nsi(dot)edu> writes:
> So I think you are saying that although none of my tables have the
> circle type, there are inherent Postgres functions and operators which
> use circle. By running the regression test, I could find out which
> functions and operators these are and just drop them.
Right.
> Is the vacuum
> crapping out then because it is trying to vacuum one of these
> functions and finding that OID 718 doesn't exist?
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...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-09-01 13:26:28 | Re: [HACKERS] OID 718 and Circle |
| Previous Message | Peter Blazso | 1999-09-01 11:48:53 | need help for array appending & deleting |