(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