3 ms·
It’s added complexity, it means changing the foreign data’s shape could break the wrapper, performance won’t be as good. There is probably more, but those come
by steve_adams_86 6y ago
It’s added complexity, it means changing the foreign data’s shape could break the wrapper, performance won’t be as good. There is probably more, but those come to mind.
For a lot of people that’s probably not a net negative.
- rattray 6y agoHow does the wrapper break when the foreign data's shape changes? What is the nature of the errors surfaced?
- steve-chavez 6y agoCould be a type error for example. You specify an `int` column(say you expect "20") in the fdw but one row has it as `text`(you get "twenty"). Something like this has happened to me when reading from a csv file. In this case pg will show an error and not read any rows from the fdw.