On 02/21/2011 06:56 PM, Tom Lane wrote:
Andrew Dunstan<and...@dunslane.net> writes:
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.
Of course, we could just let these break or give odd results when we run
a SELECT if the foreign table doesn't match what's expected. file_fdw
will presumably break if the input file has rows with the wrong number
of columns, just as COPY does. But there will be cases, like the two
above, where a sanity check on the table shape could usefully be done at
validation time as opposed to run time, and it would be nice to be able
to do such a check.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers