Arrrrgggghhhh!!
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.
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.
How do I remove this type?
TIA
Patrick Hatcher