I'm writing my first user defined function with mysql, and
after adding a new feature that didn't work, I'm at the point where
I can't drop the old function and redeclare it. It seems the
function both exists and doesn't exist.

mysql> drop functino vec2pix;
ERROR 1305 (42000): FUNTION ucac3.vex2pix does not exist
mysql> create function vec2pix returns int soname 'udf_vec2pix.so'
ERROR 1125 (HY00): Function 'vec2pix' already exists

Sugguestions?

Hi Greg,

> I'm writing my first user defined function with mysql, and
> after adding a new feature that didn't work, I'm at the point where
> I can't drop the old function and redeclare it. It seems the
> function both exists and doesn't exist.
>
> mysql> drop functino vec2pix;
> ERROR 1305 (42000): FUNTION ucac3.vex2pix does not exist
> mysql> create function vec2pix returns int soname 'udf_vec2pix.so'
> ERROR 1125 (HY00): Function 'vec2pix' already exists
>
> Sugguestions?

What version of MySQL? 5 and up?

The error message sounds like it's trying to delete a Stored Function
instead of an External Function.

Can you try:

drop function mysql.vec2pix

?

--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com