From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | "Tom Lane <tgl" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: somehow created type in4 now can't delete |
Date: | 2003-03-07 19:58:26 |
Message-ID: | OF112E6D57.4BA9351D-ON88256CE2.006DA747-88256CE2.006E1CE3@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thank you! That did it.
Patrick Hatcher
Macys.Com
Tom Lane
<tgl(at)sss(dot)pgh(dot)p To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
a.us> cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] somehow created type in4 now can't delete
03/07/2003
11:53 AM
"Patrick Hatcher" <PHatcher(at)macys(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Aspire Something | 2003-03-07 20:33:34 | Using Python in PostgreSQL |
Previous Message | Tom Lane | 2003-03-07 19:53:23 | Re: somehow created type in4 now can't delete |