Re: vacuum analyze fails: ERROR: Unable to locate type oid 2230924 in catalog

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: vacuum analyze fails: ERROR: Unable to locate type oid 2230924 in catalog
Date: 2001-02-27 07:10:16
Message-ID: 20010227161016A.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have comitted the fix to parser/parse_coarse.c. My previous patches
was not correct and I changed the checking right after
typeInheritsFrom.
--
Tatsuo Ishii

> vacuum analyze on pg_type fails if bogus entries remain in pg_operator.
> Here is a sample script to reproduce the problem.
>
> drop table t1;
> create table t1(i int);
> drop function foo(t1,t1);
> create function foo(t1,t1) returns bool as 'select true' language 'sql';
> create operator = (
> leftarg = t1,
> rightarg = t1,
> commutator = =,
> procedure = foo
> );
> drop table t1;
> vacuum analyze;

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2001-02-27 08:45:29 Re: SunOS4
Previous Message Xu Yifeng 2001-02-27 05:45:44 Re[4]: Re: [PATCHES] A patch for xlog.c