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

2007-09-02 Thread Tom Lane
"Ow" <[EMAIL PROTECTED]> 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 th

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

2007-09-02 Thread Devrim GÜNDÜZ
Hi, On Sun, 2007-09-02 at 03:45 +, 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_re

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

2007-09-02 Thread Ow
The following bug has been logged online: Bug reference: 3592 Logged by: Ow Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux (gentoo) Description:alter function rename to doesn't work Details: => create or replace function dbo.test(