Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread information schema is not updated when altering function
Mon, Aug 18 2008 2:18 AMPermanent Link

Heiko Knuettel
Don't know if this affects anything, but:
When I create an external function, and then alter it to a SQL/PSM function,
information.functions still says it's an external function.

Heiko
Tue, Aug 19 2008 11:26 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Heiko,

<< Don't know if this affects anything, but:
When I create an external function, and then alter it to a SQL/PSM function,
information.functions still says it's an external function. >>

Yep, it's a bug in the ALTER FUNCTION statement.  The workaround is to
drop/create the function.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image