Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 65BCA6321C0 for ; Thu, 2 Sep 2010 12:05:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 14265-04 for ; Thu, 2 Sep 2010 15:05:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by mail.postgresql.org (Postfix) with ESMTP id 07AEB6310AC for ; Thu, 2 Sep 2010 12:05:26 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id BF6B08109; Thu, 2 Sep 2010 17:05:24 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id BABF580E5; Thu, 2 Sep 2010 17:05:24 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id D322B3808C7; Thu, 2 Sep 2010 17:05:13 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id A477458ABC; Thu, 2 Sep 2010 17:05:24 +0200 (CEST) Message-ID: <4C7FBD34.2030607@tech.sdb.it> Date: Thu, 02 Sep 2010 17:05:24 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Tom Lane , pgsql-admin@postgresql.org Subject: Re: out of memory error References: <288793.40690.qm@web39707.mail.mud.yahoo.com> <4C5BC43B.7050503@tech.sdb.it> <4C5BF885.9060105@tech.sdb.it> <4C7F9DA6.6080606@tech.sdb.it> <4C7FA8B7.4000702@tech.sdb.it> <22549.1283437674@sss.pgh.pa.us> In-Reply-To: <22549.1283437674@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/13 X-Sequence-Number: 35557 Tom Lane ha scritto: > Silvio Brandani writes: > >>> Still problems of Out of Memory: >>> the query is the following and if I run it from psql is working fine, >>> but from application I get error : >>> > > Is it really the *exact* same query both ways, or are you doing > something like parameterizing the query in the application? > > regards, tom lane > > Is it exactly the same, the query text is from the postgres log. I just try it in test environment and we have same situazione : psql it works, from application (odbc) do not. thanks -- Silvio Brandani Infrastructure Administrator SDB Information Technology Phone: +39.055.3811222 Fax: +39.055.5201119 --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --