MIME-Version: 1.0
From: Patrick Starrenburg <patrick.starrenburg@gmail.com>
Date: Thu, 19 Nov 2020 16:41:48 +0100
Message-ID: 
 <CA+6L-Z9b1p5Xu5P_24GjGv-X1yRdR-ufqehSLGYu2QUMJmXp8Q@mail.gmail.com>
Subject: 'Psycopg2.errors' not referenced in packaged
To: psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000089281a05b4779142"
Precedence: bulk

--00000000000089281a05b4779142
Content-Type: text/plain; charset="UTF-8"

Hi

I am using psycopg2 in a Django app. In my code I am checking for various
exceptions, one of which is foreign key violations.

I see in the psycopg2 docs https://www.psycopg.org/docs/errors.html that
ForeignKeyViolation
is under the base IntegrityError exception. I would like to be able to
specifically catch, and respond to the ForeignKeyViolation error. I am
coding using the recommendation in the docs (below).

It is working (a forced FK violation is specifically caught) my question is
though that in my IDE (PyCharm) it reports that it cannot find the
reference 'errors' and I cannot use dotted links to drill down to the
errors.ForeignKeyViolation function.

I can type psycopg2.IntegrityError and reference to it is found (and I see
that it is listed in the __init.py__ file).

When I Google this some say it is a PyCharm bug, some say that PyCharm is
following the Python package convention.

Can anyone advise.

Thanks in advance.

Patrick

try:
    cursor_wsr.close()
    conn.commit()
    conn.close()
except psycopg2.errors.ForeignKeyViolation as err:

Cannot find reference 'errors' in '__init__.py | __init__.py'
Inspection info: This inspection detects names that should resolve but
don't. Due to dynamic dispatch and duck typing, this is possible in a
limited but useful number of cases. Top-level and class-level items
are supported better than instance items.

--00000000000089281a05b4779142
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><div><br></div><div>I am using psycopg2 in a =
Django app. In my code I am checking for various exceptions, one of which i=
s foreign key violations.</div><div><br></div><div>I see in the psycopg2 do=
cs <a href=3D"https://www.psycopg.org/docs/errors.html">https://www.psycopg=
.org/docs/errors.html</a> that <span style=3D"color:rgb(0,0,0);font-family:=
monospace;font-size:13px;font-style:normal;font-variant-caps:normal;font-we=
ight:bold;letter-spacing:normal;text-align:left;text-indent:0px;text-transf=
orm:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,2=
55);text-decoration:none;display:inline;float:none">ForeignKeyViolation<br>=
</span></div><div></div><div>is under the base IntegrityError exception. I =
would like to be able to specifically catch, and respond to the ForeignKeyV=
iolation error. I am coding using the recommendation in the docs (below).</=
div><div><br></div><div>It is working (a forced FK violation is specificall=
y caught) my question is though that in my IDE (PyCharm) it reports that it=
 cannot find the reference &#39;errors&#39; and I cannot use dotted links t=
o drill down to the errors.ForeignKeyViolation function.</div><div><br></di=
v><div>I can type psycopg2.IntegrityError and reference to it is found (and=
 I see that it is listed in the __init.py__ file).</div><div><br></div><div=
>When I Google this some say it is a PyCharm bug, some say that PyCharm is =
following the Python package convention.<br></div><div><br></div><div>Can a=
nyone advise.</div><div><br></div><div>Thanks in advance.<br></div><div><br=
></div><div>Patrick<br></div><div><br></div><div><pre style=3D"background-c=
olor:rgb(255,255,255);color:rgb(0,0,0);font-family:&quot;Menlo&quot;,monosp=
ace;font-size:10.5pt"><span style=3D"color:rgb(0,0,128);font-weight:bold">t=
ry</span>:<br>    cursor_wsr.close()<br>    conn.commit()<br>    conn.close=
()<br><span style=3D"color:rgb(0,0,128);font-weight:bold">except </span>psy=
copg2.<span style=3D"background-color:rgb(241,194,50)">errors</span>.Foreig=
nKeyViolation <span style=3D"color:rgb(0,0,128);font-weight:bold">as </span=
>err:<br><br>Cannot find reference &#39;errors&#39; in &#39;__init__.py | _=
_init__.py&#39; <br>Inspection info: This inspection detects names that sho=
uld resolve but don&#39;t. Due to dynamic dispatch and duck typing, this is=
 possible in a limited but useful number of cases. Top-level and class-leve=
l items are supported better than instance items.</pre></div></div>

--00000000000089281a05b4779142--