Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfCji-0007al-Ba for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 17:22:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfCjh-0001CX-5B for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2013 17:22:01 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfCjO-0000vi-U3 for pgsql-general@postgresql.org; Wed, 22 May 2013 17:21:43 +0000 Received: from tus1smtoutpex03.symantec.com ([216.10.195.243]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfCjM-0001A6-Da for pgsql-general@postgresql.org; Wed, 22 May 2013 17:21:42 +0000 X-AuditID: d80ac3f3-b7f9c6d0000033e4-bb-519cfea219f3 Received: from ecl1mtahubpin02.ges.symantec.com (ecl1mtahubpin02.ges.symantec.com [10.48.69.202]) by tus1smtoutpex03.symantec.com (Symantec Brightmail Gateway out) with SMTP id 96.ED.13284.2AEFC915; Wed, 22 May 2013 17:21:39 +0000 (GMT) Received: from [155.64.220.139] (helo=TUS1XCHHUBPIN03.SYMC.SYMANTEC.COM) by ecl1mtahubpin02.ges.symantec.com with esmtp (Exim 4.76) (envelope-from ) id 1UfCjK-0003cY-By; Wed, 22 May 2013 17:21:38 +0000 Received: from TUS1XCHEVSPIN34.SYMC.SYMANTEC.COM ([155.64.220.149]) by TUS1XCHHUBPIN03.SYMC.SYMANTEC.COM ([155.64.220.139]) with mapi; Wed, 22 May 2013 10:21:37 -0700 From: Sajeev Mayandi To: Pavel Stehule CC: "pgsql-general@postgresql.org" Date: Wed, 22 May 2013 10:21:37 -0700 Subject: Re: DECLARING THE CURSOR WITH HOLD Thread-Topic: [GENERAL] DECLARING THE CURSOR WITH HOLD Thread-Index: Ac5XENCeHTeg6NplQBiRIEl9xiY+GQ== Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.2.120421 acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFprDIsWRmVeSWpSXmKPExsXCZeB6SnfxvzmBBu+nClv8/tzGaDH97lY2 ByaPnbPusntc2DeNPYApissmJTUnsyy1SN8ugStjyxnxgkOsFY1N71kaGJeydDFyckgImEjc XN/LCmGLSVy4t56ti5GLQ0jgHaPEhzU7mSGcN4wS1w9PZIJwVjFKfPzdzwbSwiZgJPHkbhsz iC0ioC0x/ck3sFHMAo4Sa5Y2M4LYLAKqEu9mLQGrERYwlfgxZwobRL2ZxP5rt6FsPYkdL86y g9i8AhYSu1euB6vnFAiU2Dh7L9gcRqDzvp9awwQxX1zi1pP5TBBnC0gs2XOeGcIWlXj5+B/Y DaJAM3886GWH6BWVuNO+nhGiV0diwe5PbBC2tsSyha+ZIfYKSpyc+YRlAqP4LCQrZiFpmYWk ZRaSlgWMLKsYZUpKiw2Lc0vyS0sKUisMjPWKK3MTgTGWrJecn7uJERhnN7gOf97BuPCH/iFG AQ5GJR7eHz/nBAqxJpYBVR5ilOBgVhLhzfoLFOJNSaysSi3Kjy8qzUktPsQozcGiJM77tWt6 oJBAemJJanZqakFqEUyWiYNTChify339Lwvos/zdsEp+Y4jE5apj83Ytu2Ez/5TfK9miv4F6 0zbcCJtz/NRjs3Xin9a0PF3xIlomaaXKD8vDu54ckCw5d27fo7Dw52cfmOroW3zQqDay2R73 IiIha6p/vF9n+p3mojNK0psOyJ1e25UwZ1ub+vf1Limb1LtEdknbpX37VeH+fD+3EktxRqKh FnNRcSIACfg6LK8CAAA= X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org Is there a work around to declare the cursor with hold? Thanks, Sajeev On 5/22/13 10:19 AM, "Pavel Stehule" wrote: >Hello > >2013/5/22 Sajeev Mayandi : >> >> >> Hi, >> >> I am trying to declare a cursor with hold along with NO SCROLL option. >> I >> am getting syntax error. Just wondering if CURSOR WITH HOLD option >> supported. My code snip is. >> >> DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from >> phostmapping; >> >> NOTE: The code is in plpgsql and postgresql version is 9.2. >> > >holdable cursors are not supported in plpgsql > >Regards > >Pavel Stehule > >> Thanks, >> >> Sajeev --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general