Re: [BUGS] BUG #3592: alter function rename to doesn't work

Hi,

On Sun, 2007-09-02 at 03:45 +0000, Ow wrote:
>
> => alter function dbo.test(text) rename to dbo.test_rename;
> ERROR: syntax error at or near "."
> LINE 1: alter function dbo.test(text) rename to dbo.test_rename;

AFAIK, the correct syntax is:

ALTER FUNCTION dbo.test(text) RENAME TO test_rename;

You should not specify schema name in the function. The new function will be created in the same schema that the original function is created.

Regards,

-- 
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - 
http://www.commandprompt.com/


application/pgp-signature attachment: This is a digitally signed message part