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 1lYU1F-0000FM-Kk for pgsql-sql@arkaria.postgresql.org; Mon, 19 Apr 2021 13:32:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lYU1D-0001Hi-Ua for pgsql-sql@arkaria.postgresql.org; Mon, 19 Apr 2021 13:32:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lYU1D-0001Hb-Mo for pgsql-sql@lists.postgresql.org; Mon, 19 Apr 2021 13:32:51 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lYU18-0003Uq-H8 for pgsql-sql@lists.postgresql.org; Mon, 19 Apr 2021 13:32:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1618839163; bh=TuWbKwABcUyvFXbdLUItPyKIfA+ef6u8IjOSyo4G7gA=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=D8yxr60QWE0Uy65ytLdBFhDmcfy4soPUzebtJqsEpKNoDzZ71mrhYz6Xla6lzkMti ffw2Sr14j/rchfDlia+x7SfTnoBKfE/DG/YUlRv9MicFoUFABDowH4N1txMz/6+KCT c9KzK1Ghu6RackepUmid4Ptd85RDsNlUaGwzphDM= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [10.1.35.107] ([185.40.248.10]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M6llE-1lRLwD0tPq-008KnR for ; Mon, 19 Apr 2021 15:32:43 +0200 Subject: Re: Substitute of TRY and CATCH in postgres To: pgsql-sql@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <0fde17f1-3d4c-451a-6746-52ec16d16155@gmx.net> Date: Mon, 19 Apr 2021 15:32:41 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:L16QDb6qY2yrAugrSLTT89RDw226ryHHE2vZJEi2lXa5ov94OfI JFq/rYnxxe2uHQY3nxC2MnqY3NPWoCcJZCHkGm/hzqu+RXr9nENukNDcRCs9qpGht5X54lu 9SZBG1deqkKJzy7TMwb3OhZ7TQ81qehucZFzX17G3YkIXrGdOMpgV85dGdKz7D41TTUG4YC WbXDID35M2Mc1R89qvxrA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:BLNnyTpKfO4=:UCD59MQkEBDFsu9qB4gpbO ciV8teXl2We1kbRtdSndmH4MP9ffOqWFM04ueEmFT2iBkn+xJsJwN9lIVuI32ac5rRX5yc0A7 JYaomW91PQKrmpPtDUps7VPNaR/u81NSRbOphvbT4iW2/bwQhSuxMxjiAOZX4KErnEGkr/CMc vbGsCj5ZxWUrDor3RyRKeH48E6XGX94jK6K93krp7NcgPncoDxKlWLl2PWCE9Q1VMSf8u2fNa FsbQBnMCQ6tQvfUM4DFMdHjxYLc1cZRleK8pzRDnaV9YLX4/Q1yIyQbkFiJ93jkUAfSUy5DJz nNgMbNfa9zc7N5zKeubpWSOyJlFe/gq1rHtH1O5YTh5C9MKgbOMziZvMefJoHLdxGAKHV4pne TR/+/JbV8eey8UgGldfT3dE6ThYDKG7XEQ4tT4MMHBVqKrj1ukay3JvDxzcpB4x3l0aUO/Bjc eZceqmbklgdWnib3FeL1Rzx3zI1NT9s8+DHiezXhJU7gv7QFBDkNRamYpm/+HLbMYDAOkjppj DX9PVz14PSlQxgYM7LcQ3cDPexcg3qPKmbi0M/6zhX13dVMWOR2GgLjFbe0bLZcJ6Cj/r1qly H2RbtFutvIPGrz1SXWzKYHUNrUqmDwekQvSbeejoiWxIa46huzkCVodONryBHr+bFT4Zyi89t LAmGBwshnz4Yi6DgvZ/z+PyAQREqyCJsqFQ3ugMEGj5D2Zp+C+PejYC0cpEaug16tuI10raTa yINBOYoU9SmJJyyT/idFC4Rn0ROLQxF2yMS7iW35B2zYHb2z0cw5+la5wRgkkjMz0DthhQLdn CFibGtNaq7kiB370rGWlLtIhW0HhXQFKH1eqxsoWLlNOZZ7XUHKqKAOS0N7raiYuw8pYH16/F CFdEPATk0iYoEFCJ+TJC0xpYSgLSr/kSiJ/T0CkOwii/dudTWyrIdKjuB8Kenf4jcdQxlz/Qh ouoO3iPBKo51MmLmgnC+oKe5Qym6Fj7uIONzM8MoEOUrLvKXVrAwCXzOAX8eE5mCQqdMwkVfj NTXlKGS3SRM07FUx3aIDL1CtQwrzDf86aN2HFDLlt4L9d3GYcswy54XiBMXUQxdL3Ldz0AnxE fpwnPRqLv+15Bl0u+/TxgKe6xvkd2/+fqPxQqbWk6X2pzw9hu1nyW0BClyPEBEdPDxTDBNIV3 r2JRl38kWZvvQ2XoRVyaejfcR4buVdbP5YAhgw5C1GuINuIJTRLn1JB0T8vlCEu+waY9A= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk aditya desai schrieb am 19.04.2021 um 15:21: > We have a MSSQL proc which reads as below. We have to convert it to > Postgres using TRY CATCH. I googled about it and could not find > significant information. Can someone help? You need an exception block: https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING