> --- 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 -- GMX DSL = Maximale Leistung zum minimalen Preis! 2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
