Re: FDW table hints

On Mon, May 2, 2011 at 23:56, David Fetter <david(at)fetter(dot)org> wrote:
> On Mon, May 02, 2011 at 09:27:08PM +0200, Magnus Hagander wrote:
>> postgres=# DROP TABLE FOO;
>> ERROR:  "foo" is not a table
>> HINT:  Use DROP FOREIGN TABLE to remove a foreign table.
>> postgres=# CREATE INDEX baz ON foo(bar);
>> ERROR:  "foo" is not a table
>>
>> To some, that would be confusing - foo kind of is a table, just a
>> different kind. Should we have some HINT on that one as well?
>
> Until we can actually create indexes on foreign tables, yes ;)

Well, yeah, but I don't think we can squeeze that into 9.1 without
Robert noticing :P

Any suggestions on *what* the hint should be? Just something along the
line "indexes cannot be created on foreign tables"?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/