Re: wrong hint message for ALTER FOREIGN TABLE

花田 茂 <hanada@metrosystems.co.jp>

From: Shigeru Hanada <hanada@metrosystems.co.jp>
To: Thom Brown <thom@linux.com>
Cc: "pgsql-hackers >> PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2011-04-25T11:32:18Z
Lists: pgsql-hackers
(2011/04/25 19:34), Thom Brown wrote:
> 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.

Oops, you are right.
Right procedure to reproduce is:

postgres=# CREATE TABLE foo(c1 int);
CREATE TABLE
postgres=# ALTER FOREIGN TABLE foo RENAME TO bar;
ERROR:  "foo" is not a foreign table
HINT:  Use ALTER FOREIGN TABLE instead.

Regards,
-- 
Shigeru Hanada