I'm probably not the only Foreign Data Wrapper author who has been a bit annoyed by the churn in the Foreign Data Wrapper API. I caught one lot of changes back in March, but it looks like I should have waited a bit longer. A couple of days ago I got a message alerting me to the fact that the File Text Array FDW would not build for PostgreSQL 9.2. Making the changes required wasn't too hard, although it was rather tiresome. But then I found that what I had wouldn't compile on git master, because there have been further changes. At this point I stopped and switched to using multiple git branches instead of a single branch with a bunch of #if directives. The branch names mirror the names of the PostgreSQL branch they are meant to be built against. Then I added some sanity checking code to make sure that it is being built for the right branch. So we now have REL9_1_STABLE and REL9_2_STABLE as well as the master branch (master doesn't build yet - but it will shortly). If you're building this package from git you'll need to checkout the right branch now.
When I have tidied all this up I will go and work the same stuff for the File Fixed Length FDW.
Yah sadly it seems the same issue with other FDWs I've tried to compile that worked fine in 9.1, but had no attempt like yours at making work with 9.2. I've been copying your changes to see if I can get them to work for other FDWs. Think I'm close and then hope to release back if the authors didn't beat me to it. <br />
Is there a list somewhere that details the changes that need to be made. I was going to try to write one up as I go along if there isn't one already since it seems to have changed quite a bit.<br />
Right now it's mostly just an exercise for me in understanding FDW architecture since I really want to tackle a spatial one that leverages GDAL/OGR (http://www.gdal.org/) ro some other spatial http://trac.osgeo.org/postgis/ticket/974 which is a library PostGIS already builds on.<br />
Thanks for the fix <img src="/andrew/templates/default/img/emoticons/smile.png" alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" />. Working great so far.