Hi,
Using postgres 9.2, I created a FOREIGN TABLE on a csv file. It works.
But I need to change the structure of the data and I created several sql select using union, like
select .... from .foreign table... where...
union
select .... from .foreign table... where...
union
...
It works for the first 10 select but then I get
ERROR: exceeded MAX_ALLOCATED_DESCS while trying to open file "/srv/www/data/antidote/registre.csv"
What is it MAX_ALLOCATED_DESCS? and how can I modify it without changing the code and re-compile? I tried using postgref.conf but this parameters is not recognize.
thanks
steve