Re: BUG #3592: alter function rename to doesn't work - Mailing list pgsql-bugs

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/