On 25 April 2011 10:06, Shigeru Hanada <hanada@metrosystems.co.jp> wrote:
> I noticed that ALTER FOREIGN TABLE RENAME TO emits a wrong hint message if
> the object was not a foreign table. ISTM that the hint message is not
> necessary there. Attached patch removes the hint message.
>
> Steps to reproduce the situation:
>
> postgres=# CREATE FOREIGN TABLE foo () SERVER file_server;
> postgres=# ALTER FOREIGN TABLE foo RENAME TO bar;
> ERROR: "foo" is not a foreign table
> HINT: Use ALTER FOREIGN TABLE instead.
Don't you mean that you created a regular table first, then tried to
rename it as a foreign table? Your example here will be successful
without the error.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company