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/
signature.asc
Description: This is a digitally signed message part
