On Tue, May 03, 2011 at 10:42:30AM +0100, Dave Page wrote: > On Tue, May 3, 2011 at 10:33 AM, Susanne Ebrecht > <[email protected]> wrote: > > On 03.05.2011 09:30, Magnus Hagander wrote: > >> > >> 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, > > > > I am not really sure if this is clever. > > > > When we make such a hint for foreign tables then we should make a > > similar hint for views. > > A view really isn't a table, unlike a foreign table, so I don't > think that argument holds.
There are other systems where it's possible to constrain VIEWs, something we might approach with an index. One of those systems comes from some outfit in Redwood Shores, California with cylindrical buildings, so it's not as wild as it first appears. Anyhow: +1 for mentioning that at the moment, it's not possible to create an index on a foreign table. +1 also for doing this with VIEWs, but as a separate patch. Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
