BUG #3592: alter function rename to doesn't work
The following bug has been logged online:
Bug reference: 3592
Logged by: Ow
Email address: nikeow@yahoo.com
PostgreSQL version: 8.2.4
Operating system: Linux (gentoo)
Description: alter function rename to doesn't work
Details:
=> create or replace function dbo.test(AA text) returns varchar(4) as
-> $$
$> BEGIN
$> return AA;
$> END;
$> $$ language plpgsql;
CREATE FUNCTION
=> select dbo.test('text');
test
------
text
(1 row)
=> 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;
^
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/
"Ow" <nikeow@yahoo.com> writes:
=> 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;
^
This is not correct syntax --- leave off the second "dbo.".
regards, tom lane