On Mon, May 2, 2011 at 23:56, David Fetter <da...@fetter.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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
