On 25 April 2011 10:06, Shigeru Hanada <han...@metrosystems.co.jp> wrote: > I noticed that ALTER FOREIGN TABLE RENAME TO emits a wrong hint message if > the object was not a foreign table. ISTM that the hint message is not > necessary there. Attached patch removes the hint message. > > Steps to reproduce the situation: > > postgres=# CREATE FOREIGN TABLE foo () SERVER file_server; > postgres=# ALTER FOREIGN TABLE foo RENAME TO bar; > ERROR: "foo" is not a foreign table > HINT: Use ALTER FOREIGN TABLE instead.
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. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
