Re: wrong hint message for ALTER FOREIGN TABLE - Mailing list 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