From: Tom Lane <tgl@sss.pgh.pa.us>
To: clingareddy@vsoftcorp.com
cc: pgsql-admin@postgresql.org
Subject: Re:
 =?utf-8?Q?invalid_memory_alloc_request_size_18446744073709551614=0A?=
In-reply-to: <1454496310.031717503@apps.rackspace.com>
References: <1454496310.031717503@apps.rackspace.com>
Comments: In-reply-to clingareddy@vsoftcorp.com
 message dated "Wed, 03 Feb 2016 16:15:10 +0530"
Date: Wed, 03 Feb 2016 10:47:40 -0500
Message-ID: <30967.1454514460@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

clingareddy@vsoftcorp.com writes:
> While running a Query in PostgreSQL i am getting below error.

> SELECT count(1)  ,SUM (DECODE(cr_ind, 'Y', NVL(numeric_amt, 0), 0)) cr_amt, SUM (DECODE(cr_ind, 'Y', 0, NVL(numeric_amt, 0))) db_amt , sum(decode(cr_ind, 'Y', 1, 0)) cr_cnt, sum(decode(cr_ind, 'Y', 0, 1)) db_cnt  FROM ITEM_2015_1 a  WHERE a.NUMERIC_AMT = 13066.00 and NVL(a.FLD_6_NUM,0) = 000014 and  a.BUS_DATE  =  to_date('11212015','mmddyyyy')  AND EXISTS (SELECT 1 FROM batch_master b WHERE a.BUS_DATE = b..BUS_DATE AND a.JOB_ID = b.JOB_ID AND a.BLK_NUM = b.BLK_NUM AND a.BCH_NUM = b.BCH_NUM )

> invalid memory alloc request size 18446744073709551614

Standard Postgres contains neither any nvl() function nor a four-argument
version of decode().  A theory worth considering therefore is that this
is a bug in whatever extension is providing those functions.  If, as I
suspect, you're running EDB's version of Postgres, you would be well
advised to turn to them for support.

			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