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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ow" <nikeow(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3592: alter function rename to doesn't work
Date: 2007-09-02 14:19:21
Message-ID: 6366.1188742761@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ow" <nikeow(at)yahoo(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Travers 2007-09-02 21:52:24 Re: BUG #3593: Postgres Installer does not work
Previous Message Omkar Patkar 2007-09-02 11:38:38 BUG #3593: Postgres Installer does not work