Re: exceeded MAX_ALLOCATED_DESCS while trying to open file - Mailing list pgsql-admin

Steve.Toutant@inspq.qc.ca writes:
> 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"

FYI, I've committed some changes that will relax this limit in future
releases.

            regards, tom lane