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