On Tue, Feb 22, 2011 at 10:12, Andrew Dunstan <andrew@dunslane.net> wrote:
>>> The API for FDW validators doesn't appear to have any way that the
>>> validator function can check that the defined foreign table shape
>>> matches the FDW options sanely.
>>
>> Huh? The options ought to be orthogonal to the table column info.
>> If they're not, maybe you need to rethink your option definitions.
>
> Well, let's take a couple of cases.
>
> 1. My old favorite, file as a text array.
> 2. A hypothetical RSS feed, where the options specify which RSS fields we
> want.
I think we need to overhaul validators in 9.2 listening to FDW developers'
opinions anyway. The text array is an example, but there should be many
other requirements. Personally, I'd like to have a method to list available
options from SQL. We should also consider column-level options for foreign
tables then.
--
Itagaki Takahiro