Am 03.02.2016 um 11:45 schrieb clingareddy@xxxxxxxxxxxxx: > Hi Team, Hi, > > While running a Query in PostgreSQL i am getting below error. > > Query: > > 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 ) > I'm pretty sure that it's not about the query (see below). > Error: > > invalid memory alloc request size 18446744073709551614 > Severity: ERROR > Code: XX000 As googling the error quickly reveals http://www.postgresql.org/message-id/5863.1138032323@xxxxxxxxxxxxx and Tom Lane usually knows what he's talking about, I'd check for data corruption. Good luck! -- Gunnar "Nick" Bluth DBA ELSTER Tel: +49 911/991-4665 Mobil: +49 172/8853339 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin