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