Re: exceeded MAX_ALLOCATED_DESCS while trying to open file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: exceeded MAX_ALLOCATED_DESCS while trying to open file
Date: 2013-06-09 17:49:43
Message-ID: 25115.1370800183@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steve(dot)Toutant(at)inspq(dot)qc(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Viru Kanjilal 2013-06-10 17:30:05 How do you use PostgreSQL ?
Previous Message l duynslager 2013-06-09 03:35:04 Re: DBD::Pg requires at least protocol version 3.0