Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Import Foreign Schema for ogr_fdw for PostgreSQL 9.5

PostgreSQL 9.5RC1 got released recently, and as with Postgresql 9.5beta2, the FDW API changed just enough so that the ogr_fdw I compiled for PostgreSQL 9.5beta2 no longer worked for PostgreSQL 9.5RC1. While patching up ogr_fdw to make it work with PostgreSQL 9.5RC1, I took a study of postgres_fdw to see how much effort it would be to implement this new PostgreSQL 9.5 Import Schema functionality for my favorite fdw ogr_fdw. Took me about a day's work, and if I was more experienced, it would have been probably only an hour to graft the logic from postgres_fdw and the ogr_fdw_info that Paul Ramsey had already done, to achieve Import Foreign Schema nirvana. Here's hoping my ogr_fdw patch gets accepted in some shape or form in time for PostgreSQL 9.5 release and in time to package for Windows PostGIS 2.2 Bundle for PostgreSQL 9.5.

UPDATE - ogr_fdw 1.0.1+ now includes the Import Foreign SCHEMA functionality discussed here.

Continue reading "Import Foreign Schema for ogr_fdw for PostgreSQL 9.5"


This post first appeared on Postgres OnLine Journal, please read the originial post: here

Share the post

Import Foreign Schema for ogr_fdw for PostgreSQL 9.5

×

Subscribe to Postgres Online Journal

Get updates delivered right to your inbox!

Thank you for your subscription

×