(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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
