Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UljkT-0002ke-11 for pgsql-admin@arkaria.postgresql.org; Sun, 09 Jun 2013 17:49:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UljkS-0002jf-CL for pgsql-admin@arkaria.postgresql.org; Sun, 09 Jun 2013 17:49:48 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UljkR-0002ii-JT for pgsql-admin@postgresql.org; Sun, 09 Jun 2013 17:49:47 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UljkP-0007zy-0a for pgsql-admin@postgresql.org; Sun, 09 Jun 2013 17:49:47 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r59Hnhme025116; Sun, 9 Jun 2013 13:49:43 -0400 (EDT) From: Tom Lane To: Steve.Toutant@inspq.qc.ca cc: pgsql-admin@postgresql.org Subject: Re: exceeded MAX_ALLOCATED_DESCS while trying to open file In-reply-to: References: Comments: In-reply-to Steve.Toutant@inspq.qc.ca message dated "Tue, 28 May 2013 11:28:02 -0400" Date: Sun, 09 Jun 2013 13:49:43 -0400 Message-ID: <25115.1370800183@sss.pgh.pa.us> X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin