Horton

Re: FDW table hints

Dave Page <dpage@pgadmin.org>

View thread
From: Dave Page <dpage@pgadmin.org>
To: Susanne Ebrecht <susanne@2ndquadrant.com>
Cc: Magnus Hagander <magnus@hagander.net>, David Fetter <david@fetter.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-05-03T09:42:30Z
Lists: pgsql-hackers 
On Tue, May 3, 2011 at 10:33 AM, Susanne Ebrecht
<susanne@2ndquadrant.com> 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.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company