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