Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 801599FB55A for ; Thu, 5 Jul 2007 11:49:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 31734-06 for ; Thu, 5 Jul 2007 11:48:42 -0300 (ADT) X-Greylist: delayed 05:13:01.057648 by SQLgrey-1.7.5 Received: from BRUBLUmx12.mactelecom.net (BRUBLUmx12.mactelecom.net [217.64.240.4]) by postgresql.org (Postfix) with ESMTP id D8F7C9FA4E5 for ; Thu, 5 Jul 2007 11:48:59 -0300 (ADT) Received: from smtp.eurofer.be (217.64.254.218.mactelecom.net [217.64.254.218]) by BRUBLUmx12.mactelecom.net (Postfix) with ESMTP id 6A0B5838014 for ; Thu, 5 Jul 2007 16:48:55 +0200 (CEST) Received: from ip-80-236-204-167.dsl.scarlet.be ([80.236.204.167] helo=[192.168.1.100]) by smtp.eurofer.be with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1I6SdG-0006XR-05 for pgsql-admin@postgresql.org; Thu, 05 Jul 2007 16:48:55 +0200 Message-ID: <468D04BF.4060008@eurofer.be> Date: Thu, 05 Jul 2007 16:48:31 +0200 From: De Leeuw Guy User-Agent: IceDove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 CC: pgsql-admin@postgresql.org References: <468CBB68.6050808@eurofer.be> In-Reply-To: <468CBB68.6050808@eurofer.be> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Spam_score: -4.3 X-SA-Exim-Connect-IP: 80.236.204.167 X-SA-Exim-Mail-From: G.De_Leeuw@eurofer.be Subject: Re: strange error X-SA-Exim-Scanned: Yes (on smtp.eurofer.be) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/42 X-Sequence-Number: 26023 Hello I match the problem : a trigger writed in PL::Ruby If I remove the trigger ok. but I don't know how fix it. De Leeuw Guy a écrit : > Hello, > > I try to copy a file into a database : > On our main server (postgresql 8.1 debian etch ia64) no problem. > On a test laptop (postgresql 8.2 debian testing lenny ia32) I > receive the error : > the size of the array exceed the maximum allowed (268435455) > > db_stats=# COPY table_cat FROM '/var/lib/postgresql/scripts/cat_sql.out' > WITH DELIMITER ';'; > ERREUR: la taille du tableau dépasse le maximum permis (268435455) > db_stats=# > > Could you help me ? > > Thanks in advance > > Guy > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >