Re: wrong hint message for ALTER FOREIGN TABLE
| От | Thom Brown |
|---|---|
| Тема | Re: wrong hint message for ALTER FOREIGN TABLE |
| Дата | |
| Msg-id | BANLkTik0bmS45NLXy9A8RKaO0E4smsCBPQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | wrong hint message for ALTER FOREIGN TABLE (Shigeru Hanada <hanada@metrosystems.co.jp>) |
| Ответы |
Re: wrong hint message for ALTER FOREIGN TABLE
|
| Список | pgsql-hackers |
On 25 April 2011 10:06, Shigeru Hanada <hanada@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
В списке pgsql-hackers по дате отправления: