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 <psycopg-owner+archive@lists.postgresql.org>)
	id 1nIbNk-0001pJ-4t
	for psycopg@arkaria.postgresql.org; Fri, 11 Feb 2022 19:15:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1nIbNj-0003Cf-2K
	for psycopg@arkaria.postgresql.org; Fri, 11 Feb 2022 19:14:59 +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 <daniele.varrazzo@gmail.com>)
	id 1nIbNi-0003CQ-Q9
	for psycopg@lists.postgresql.org; Fri, 11 Feb 2022 19:14:58 +0000
Received: from mail-vs1-xe29.google.com ([2607:f8b0:4864:20::e29])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1nIbNg-0008Mb-HI
	for psycopg@postgresql.org; Fri, 11 Feb 2022 19:14:57 +0000
Received: by mail-vs1-xe29.google.com with SMTP id t22so11407181vsa.4
        for <psycopg@postgresql.org>; Fri, 11 Feb 2022 11:14:56 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=6a4tT+R2+/lcZwi+Q/AzfmlaAR1GSRKIYeOwdZLIau0=;
        b=JnsAuZdg8r/6tQPpgT8MHiplYvP2PaeEGBQuYEfIz3QHsq1ArjDFrA0P6wCU6Oc7CD
         DwkDrxLCYLJ5m5qASOHJCRyWW9U7nG20sfCwfxjguEbAP4M2IydzbSCHwsYiJUS5X0dP
         ehkysBGJw6eOCsU41RWTnxvfAbMu2yNw8oINY+iIeOZOvnjF82iOBteaYd652In27TOc
         8m8uf73ALeV2XWYsNun25W1vfix/xQTHzmrBM1efV17ssAvu07pzpPk8cuZ6ihPYxdAl
         FlEmCtCZopldhGxad9DJT2swu1UXT0uiynsv2+E4xdeEA697fEw8RJE1YLCiO7jO8SQ2
         jJdA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=6a4tT+R2+/lcZwi+Q/AzfmlaAR1GSRKIYeOwdZLIau0=;
        b=pIGXkgYUFpwvsu7KqpTXVgNLhperEbn/GEqF7oIfvZsqsFZPso6qr+ud9NNzrTooDx
         Lyo8G3h3Ac7sK0df6yd+LlhNl020t+FTW/8k47IH7KbYb/3+2F2A/uMAL1VX/wNLTMfo
         7w1SIBtJmwlDXHdgBv88bcPx6bruUOMrESCY8EoPsxSfNd3S0ZKHat9bSpD9xoAgkAiC
         D+JD6IQnIAMptG7ZmGee+w3U5vkUsvJZgHqCULqOVpXQIklfX3m3s1p+xUJxfLArk+e0
         puK7oo+NiBeKhJzR2+y6FcGygvCToc1Vc43IKDpWtIjP5UeE2c9ZPT7w4AXVlSlfPqBS
         qngw==
X-Gm-Message-State: AOAM532fAyc+En3Mi+hMsyVpRw1c9xL5WLQHOZvvcH0FQB+dKbkTA/mM
	YaAXS5yoSHAtMdCO8Zh4Mt36VbUQ4w7PNo1N1c0=
X-Google-Smtp-Source: 
 ABdhPJyH79YEGk88TQoM/ihZBNsnbFMIqBSQ0ZAAG8eTmQvvbr9qm6of7lXqkhtc1WlrLVBdMATxgH1vgo2gBesu8us=
X-Received: by 2002:a05:6102:a4c:: with SMTP id
 i12mr993290vss.11.1644606895041;
 Fri, 11 Feb 2022 11:14:55 -0800 (PST)
MIME-Version: 1.0
References: <11dedb1fce0dbbd6f125736347685fd5@paolodestefani.it>
 <CA+mi_8bTw162gch-C4CmO98P6RNviF7DeH-cAJ6QRq+D48dF6g@mail.gmail.com>
In-Reply-To: 
 <CA+mi_8bTw162gch-C4CmO98P6RNviF7DeH-cAJ6QRq+D48dF6g@mail.gmail.com>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Fri, 11 Feb 2022 20:14:43 +0100
Message-ID: 
 <CA+mi_8YXeFp3jr3cCyxQzPUJ5HvQiUQAE-tQ_aADXyXAx=kOTQ@mail.gmail.com>
Subject: Re: exception psycopg.Error from psycopg2 to psycopg 3
To: Paolo De Stefani <paolo@paolodestefani.it>
Cc: Psycopg <psycopg@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bmi_8YXeFp3jr3cCyxQzPUJ5HvQiUQAE-tQ_aADXyXAx%3DkOTQ%40mail.gmail.com>
Precedence: bulk

On Fri, 11 Feb 2022 at 19:47, Daniele Varrazzo
<daniele.varrazzo@gmail.com> wrote:

> ISTM that setting e.sqlstate = e.diag.sqlstate would be an
> improvement.

https://github.com/psycopg/psycopg/issues/225

-- Daniele