Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mx9dE-0006LR-2X for pgsql-sql@arkaria.postgresql.org; Tue, 14 Dec 2021 15:22:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mx9dB-0005h3-Jm for pgsql-sql@arkaria.postgresql.org; Tue, 14 Dec 2021 15:22:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mx9dA-0005gu-QC for pgsql-sql@lists.postgresql.org; Tue, 14 Dec 2021 15:22:17 +0000 Received: from sonic303-20.consmr.mail.ir2.yahoo.com ([77.238.178.201]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mx9d3-0003Ex-EH for pgsql-sql@postgresql.org; Tue, 14 Dec 2021 15:22:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1639495327; bh=UoUpkJLCCezAavjNI4DUHWM7WtmRf1cPmD6JbgSKE9M=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=QRzllWIVSb82mB7SY4DpOpuR+6Skka+bpjl6oXxFFcNUqYLjItV9Uxb2Jl8nbhEMXh3Z8e+RmMgFuvorzYRWZC13HWn8to9KVNBr6qrgIfKA68aBu4/kdbXwpQxoJgDYGPSngfXzlOGYdpGeY73lyfrQ6gOh5yCF5+OseSGJBt19ovNsUu2uEeGHYG5QnYVdVLkerBJErldIw60CKwvPBM3lCUAvtzGaMxPjAHaI8ui4s5uwRBajYnENiyZqBSENSHEwfPo3+HkVFHnTdyL8O7Qh8PaLwo9ekUflMGK/6MYv0bMcrSUQIFRwAvRiiVhJKM2kjzRfkX/jBQcMADkeqw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1639495327; bh=uLHFGNrfQ8+f2OnFhBjPjJxqvzAOmRVFmjyFNLhCDG5=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Y/u2NU1f2kuL2nUzNQ3rLO1fkAI0NSMtmR4pwMAFz30xS964CozPH8XFnlFndajitQjR4Qwm0BkSaM12v6fvOEwONYIn6zyG+fsw/67fmfzjRNESOG+E9ibpBckWf9J8k7iJTF5qYjwi79fYcD28VzWlYvi2yyIAHcP8F2Yhfjw/KItZUw8hvA/wg8RDvO8l2ZzIdwujCkPS9w3zpiyVTqlVM4Cz0II2jMrQsdoD+p84ibt3TQmH1m/1kV++oBTiFGbbp3U+kregLfh4guKStp3UbhZ32RMpQxqo7fvZjqR0RrxFvw/w1TcHP4uxT18RSxKxwA7zhE3SdxOu7xGANw== X-YMail-OSG: iNpv60kVM1mrLaZ.AGxdaNfp1JfjB05HF7len7EJYU4TpA8jIiPabzLLJeYVxLn h6igYC_sYEr.kSqPWtl_U29yjsRmwKblSI2KD7IiTie2tfY9izclZzfNzj1UJ2yT7k8BoYrVQckJ r.FH96YudhxSVHiwSIrU5yoE0OggEFtRh_Ph96wPw5qhfRrXI6UQ4RIesOx0S_wyqJ3prBP745Hw xbv5tJdBEOSj1.iylCuTD.yX7TrI4mwIe_nOKijOGp8lOCnRe9NQPmESF796zzwRtTHK6cUeyX62 9MdP.dBgpCMTEnsCupeBNxkl6XUYawPhB0Kf_mpBQesxf56DbT641E5CE1_IdXPkLaFfmAlMuk5N nceP2Y2VsVVdcgynJQazXgAUr8oSlYCrXdWW7MklprYgGiVDDSGxtu.nKz8B8Fv0lvdipR86dYOX _p.C.5QveMTpDfkztxSopKShj6kWwsxK4oUYzIMQDwK3G4_5DEJS1Ny.GErtbrp0J4krJOVS_Nxv IPTO_uVkH7A5lgfgGPKqtDdjM6m7ie.HD3bIC0ywEx_37kXYpK6NZqsr..a26ugbyakZRa9prLZg 2mXKxr5rxgwHwD8r2bJFEZJ1JBbRLZuihx61_HSd1dMGxvGmCv.Cqwots_43bDbZ46lALHbRTkMB xfM2u_XWbNZagz2MpJfDPwk_FKfAf7qBFzyVW8h8p28_8gt.6rslKI6fRoi_1.X8zAUrpv25Kcye FLsT_.E9V5kJSsZEVo2QEC3PCL.0iirmACFE7OtkkTE6lQsvzSZyymrYYVHClQmAG0KWS_abfI0_ ZxfuHxhlh6Tjq5Ii40gx8gb.hZJIKgW.QFQilMluquvoHSOsca5l_2O7ZPCVtIBGj5HbiF_v3v_8 39sssKUZcV4ha528Yk9jGr5HOAc4tXwnFYgvkg4nBP33Zp0aiYj.JZBc3cJ9WUEPisybE9xjB1k_ 27AxsbWQMaYxxPjYrapiQAXId8oxWf2kuA5RthtZ1xQeiHqIHFwbX5eM2_WrLZdNXcUwTdjeFCjD whdmmGcgGJUU1KPKV77MABHs.LDqX1t57Jcu5WwxbMO18S9d5cGnmlaOD9qUUPkdnMla..5U5f95 MiQATUTJEpFVMjRxSBgAKnSi0iCW9KLh__T_YbR.6UVID7A9SVyeOuJlQkrdotkBY2UlhyUFpoM2 iVcstsifJBSSNW7k1dOfOIXAXMaF4UaBQUMoZya5B5VaGuKx08eg2lGpfCggvoUK1HMPDoOy5EQd ZQF13q5NCgPmTdivJFWaFbwmNFegOPN7EDV2pHf8R3dswoFzwCeV56WPF9fPLSTSSoEZTVlIv1Iu EGoNnXfXBNjdrKAawsXFPyB8lL33o0MGenye7MpC3f08r2n3F2x4Gr2Zet.2Vu07QYtm1fOcCGYd hepjCQWdJZpRgqUJNpJ9IssukTs41l3i3ZpgylGKlSvKP2bHIZ0sRpe4y6PgD4i7kgQ.9BiBNR.5 gGft9BRqxddVe.YROQz5QNp0VRskgEJ1E2emB.wmfOL8x9ZhrKL5UfhtgVYjQdjgG6o2pmAVnB0W x9.gw6hgHSHxWBTYmCWGj7rnIY8RcfLtz4G.bg8ocLGHawObaLM07uKVNoMxbvqzBz57.QU3Q8mN ZkZsUv2z.h6Zbj_rc_Y.xq05L8XGPUkyRPakzTt3ywaqph7aOgx2rdkRtt0jSacHg3kmYjMAPBrc .ApXtRsDfSKTWwHnZmRlVE2hZTzJvOGSipJjsZfDFR44.s447VHTDV.xriUE_cu_qq4Fb4nMxRUr kS5_JEaM0NYcBUhRMgyW3ELuQDlxfBFLYLYHO1KCXmn7MW5wy7AjRk1_pzoIORnp6Y1EtbQQa0i3 09IgzwVgUU5E43GhBVH4UEFm2fSoc1PoD_24ixNnPY09OIdy7tdhcJX1okjelZd5kwYkCBjJkwWb fPr676cuo4ndU4GY4QAkTqRHVivRle5vBuOW5rfZpuVErLm0vW0BokGZS26b2.WR7mRbBGL8IQxw t8AVuGTW.cQe.eZTFFQoLwHfjs8x0KMrW0R178TwNBfSfnFC0GggABEAXCBOTBLc3GY0kb1Y2lid WK48yUwDpzLb2ybdtI04bXhuBeRQ5.x2OH4YzYhyCBHCHryGGWIZqLulDOfvoAEvGh0qjUMaNSxY fMk23A4zxtk7QzHgk7Dzz8cEUI_jnKDFa_bElav_IACKqPOIlp0J8xSO6y5GSruqBHo7MWw5cyxe ddJdw9T5VP78TwS50RlDCnNRObZje X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.ir2.yahoo.com with HTTP; Tue, 14 Dec 2021 15:22:07 +0000 Date: Tue, 14 Dec 2021 15:22:03 +0000 (UTC) From: James Kitambara To: Simon Riggs Cc: Sandeep Saxena , "pgsql-sql@postgresql.org" Message-ID: <1815841634.427016.1639495323025@mail.yahoo.com> In-Reply-To: References: <820139578.307641.1639046195013.ref@mail.yahoo.com> <820139578.307641.1639046195013@mail.yahoo.com> <615924257.1194226.1639150841188@mail.yahoo.com> Subject: Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_427015_39296703.1639495323023" X-Mailer: WebService/1.1.19415 YMailNorrin Content-Length: 5944 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_427015_39296703.1639495323023 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you Mr. Simon for your comment I will try that and see the results. Kindly Regards,James Kitambara=20 On Tuesday, 14 December 2021, 13:59:01 GMT+3, Simon Riggs wrote: =20 =20 On Fri, 10 Dec 2021 at 15:40, James Kitambara wrote: > > There is no COMMIT in the loop for processing cursor data. > > Sorry I forget to share the procedure on my first email: > > Here is a procedure: > ------------------------------------------------------- > > CREATE OR REPLACE PROCEDURE public.temp_insert_in_books2( > ) > LANGUAGE 'edbspl' >=C2=A0 =C2=A0 SECURITY DEFINER VOLATILE PARALLEL UNSAFE >=C2=A0 =C2=A0 COST 100 > AS $BODY$ >=C2=A0 =C2=A0 --v_id=C2=A0 =C2=A0 =C2=A0 =C2=A0 INTEGER; >=C2=A0 =C2=A0 v_title=C2=A0 =C2=A0 =C2=A0 CHAR(10); > v_amount NUMERIC; >=C2=A0 =C2=A0 CURSOR book_cur IS >=C2=A0 =C2=A0 =C2=A0 =C2=A0 SELECT title, amount FROM books2 WHERE id >=3D= 8; > BEGIN >=C2=A0 =C2=A0 OPEN book_cur; >=C2=A0 =C2=A0 LOOP >=C2=A0 =C2=A0 =C2=A0 =C2=A0 FETCH book_cur INTO v_title, v_amount; >=C2=A0 =C2=A0 =C2=A0 =C2=A0 EXIT WHEN book_cur%NOTFOUND; > INSERT INTO books2 (title, amount) VALUES (v_title, v_amount); >=C2=A0 =C2=A0 END LOOP; > COMMIT; >=C2=A0 =C2=A0 CLOSE book_cur; > END > $BODY$; "Normally, cursors are automatically closed at transaction commit." https://www.postgresql.org/docs/devel/plpgsql-transactions.html So the explicit CLOSE is not needed, if you have the COMMIT. But then why have the COMMIT? The transaction will commit by default, so I would remove that. --=20 Simon Riggs=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 http://w= ww.EnterpriseDB.com/ =20 ------=_Part_427015_39296703.1639495323023 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you Mr. Simon for your c= omment I will try that and see the results.

Kindly Regard= s,
James Kitambara


=20
------=_Part_427015_39296703.1639495323023--