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 1mZGzT-0002G9-QZ for pgsql-sql@arkaria.postgresql.org; Sat, 09 Oct 2021 18:22:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mZGzS-0003HR-PB for pgsql-sql@arkaria.postgresql.org; Sat, 09 Oct 2021 18:22:34 +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 1mZGzS-0003HJ-Gh for pgsql-sql@lists.postgresql.org; Sat, 09 Oct 2021 18:22:34 +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 1mZGzN-0008Fd-Ks for pgsql-sql@lists.postgresql.org; Sat, 09 Oct 2021 18:22:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1633803747; bh=mGMxHr+3jKtqtUIhHnk/5ZBDQs1ioEyq1ExyzOFixJA=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=X0XX//Opyt7xxBhsOBs5zcwjr35W+yRnHHpwVSuQsRzpOOAvv2yASqgyiqWMS8aSZ HeXJWZfTN5rpLy+M5eA3oFgTkvuedLhfQnCdogD24x1l+837OdyF2ULbxHTwRAFCxl UCjAO1oTGiK1h1SKlFryYiNpM6E4gnxfNuXMd0Zo= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([77.191.237.241]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MAfYw-1mShPG3w9g-00B858 for ; Sat, 09 Oct 2021 20:22:26 +0200 Received: from ncq by hermes with local (Exim 4.94.2) (envelope-from ) id 1mZGzK-0007H3-6L for pgsql-sql@lists.postgresql.org; Sat, 09 Oct 2021 20:22:26 +0200 Date: Sat, 9 Oct 2021 20:22:26 +0200 From: Karsten Hilbert To: pgsql-sql@lists.postgresql.org Subject: Re: How to capture error message and save to a table in PostgreSQL? Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:PUb35IPJmiJPF+CZWzUNLXoLn9a+AnMW8favfSWwcUsMEooA5KH g38FSYQcjYFPRbxETP96N4RKLcVpHOknLwKdeaUtVt4SbuWiPR7IAZO5zBufSvvcaEFV+fL GjDI+gmpk9ToX6Bz4HiN7ISY5whed7UPOhQrdmBUTGADFLw52WeED++vYklR0rYC/dEoBqy uVM5tx9LqHKLRygSp0QlQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:yGktjQPY1dQ=:KhfcjjxdH/14bzV31u3Fkm zQv1XToDhfyf7yJXTaREICdxq8A4efy/5ZY+4J/X1EbylJ1lGSebSCEGXmcpvZSvcw5EewZQ0 OWEsWqfv4FSLGgOkVIW1CoxhiV5IcYsDpi34a2yLp7mdHzEqtQurj5P9ggO/xM/KFawDBj6ou KZJYDG4XNqNLW7mSCctkGs1zplZ970Koh6uQT2BVjZq1WKPcFcTVh0g4pBqkMPcpntF2GBSwi UsNVLA+ZOFRTH1RmUkQjSLtMSdIes9QCB1RF5ydc7c1lU0gHDyyVIHRkKu1rpf2LPd7xwyue7 4oZFaf4DSj0SLd33ic1zmKwO6QdWiAvryibJV3VrEYkA4A8qoVm/qQh7jKIgDJbKpzAnDlN5O WAtVbK8VYQFAnE3QKgZfyWBmQYzbbfUnifxr9crTmmza27uYG4KspU05u5LixWI3DlBCDHv9g Ka9YtJsb77M+E5yzdSEjrwP+2FMFE8N2Y4QupBtCF2RjA6f9VXjCvBgthAXWLR1EoQIgn9u44 5gMR3rGC6Kqe7ARSVAnGd+NaR700Ym1r52NzVBqthINt89sFM7fJe8Ec6Ks9lisrn5gLbuo1n VkqOEfeZpjtdkxSxxVAek9TrfNSTIBrdXNBulRW+HEhx+tnMEnT6zfBZ1f7ZPynh5FzyH0XWc qyG3oDPuRjAHqpmVMHHTBb8qjI0JStFrJoYVarazTpD4hiw9FuhnzymfdKJlnn7C1CjRVT23N RX99T4Aq+46dgWU2mRfp+UahlxF0/QfLVtTRSgVNUltR5C5stTS0AA/ZnttoDmhvEh5Jbikci lFTJAk4y36bmYyoWNI0ZEl8CPCMDd+ZCmcy4oLhasP6S1StqDgU6a3RBDBeRkkzPHPWAVnMVi 38+hNOJ01NN/6fVEar6U8KOPCWqthA3WNQQwICR4kt9jIYK2on6w07oXRWyUhhySpILNCQSdp Yn9ALuyop2nvNVL2IuEys/LQL8FkaAtfdXlVHMzVpOv7E/hiNRnjy/QTZ4XlQoDA6QUB5uMF1 iXn4iYR33b64pStEwBQXQFOwWTVxVk+bl90m4UFcKl71MnNGK+1MBorJAw45pJGoSKvgUU41I JoBtUEKCtpIO+4= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Fri, Oct 08, 2021 at 10:45:45AM +0100 schrieb Shaozhong SHI: > I wish to test out to produce a table when data violates constraints whe= n > insert into a new table with constraint set. How to capture and save er= ror > message to a new table? That depends on how you access the table and at which level you wish the above to happen. You need to be less generic to get better help. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B