Andreas Goldstein wrote : >> --- Ursprüngliche Nachricht --- >> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]> >> An: "Andreas Goldstein" <[EMAIL PROTECTED]>, >> <maxdb@lists.mysql.com> >> Betreff: AW: [FSID] How to drop a public function? >> Datum: Tue, 20 Sep 2005 10:50:16 +0200 >> >> Andreas Goldstein wrote : >> >> > >> >Hi Listmembers, >> > >> >I defined a public function on my 7.6.00.12-Windows MaxDB. Now >> >I would lik >> >to change the function, but I can not drop the old version :( >> > >> > >> > >> >Here is what I did in more detail: >> > >> >Logged into the DB-instance as DBAdmin >> >CREATE PUBLIC FUNCTION KDSUMME ... >> >Worked well >> > >> >Now I would like to change that function: >> >Logged into the DB-instance as DBAdmin >> >DROP PUBLIC FUNCTION KDSUMME >> > -> Unknown function >> >CREATE PUBLIC FUNCTION KDSUMME ... >> > -> Duplicate function name >> >SELECT * FROM FUNCTIONS >> > -> There is a record with FUNCTIONNAME = KDSUMME >> > >> >The user DBAdmin ist the first and only DBA-User defined for >> >that instance. >> > >> > >> > >> >What is my mistake? >> >How can I drop the public DB-function KDSUMME I defined before? >> > >> > >> > >> >Thanks for help and comments! >> > >> >Kind regards >> >> This is a bug. Unfortunately I have no workaround for you, i.e. >> you have to think out another name for your function. >> You will be able to drop the function when the bug is fixed. >> >> Best Regards, >> Thomas > > >Hi Thomas, > >thanks for the information. What types of DB-functions are >affected by this >bug? Only those who are PUBLIC or DB-Functions in general? > > >Thanks & Regards > >
This is a problem of PUBLIC functions only. Non public functions are not affected. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
