Re: somehow created type in4 now can't delete - Mailing list pgsql-novice

From Tom Lane
Subject Re: somehow created type in4 now can't delete
Date
Msg-id 2110.1047066803@sss.pgh.pa.us
Whole thread Raw
In response to somehow created type in4 now can't delete  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: somehow created type in4 now can't delete  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-novice
"Patrick Hatcher" <PHatcher@macys.com> writes:
> While creating a function, I incorrectly entered int4 as in4 as the return
> TYPE somehow created a TYPE in4.   I subsequently deleted the function and
> recreated it with the correct int4 type.
> The problem is that I cannot delete the TYPE in4 that was created.  I tried
> Drop type in4, but I get a message RemoveType:  type '_in4' does not exist.

You should be able to just remove the type's row from pg_type:

    delete from pg_type where typname = 'in4';

> I can see in4  if I do a \dT from psql.  Furthermore, when I start
> pgAdminII, and go to the database, I can no longer see my list of views
> created because I get an error message: cache look up for proc 847021310
> failed.

You'll need to drop and recreate whichever view(s) refer to the old
version of that function.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: somehow created type in4 now can't delete
Next
From: "Patrick Hatcher"
Date:
Subject: Re: somehow created type in4 now can't delete