Re: wrong hint message for ALTER FOREIGN TABLE

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