psycopg2.Error.diag properties are None

From: Martin Fischer <larivact(at)chello(dot)at>
To: psycopg(at)postgresql(dot)org
Subject: psycopg2.Error.diag properties are None
Date: 2016-01-12 20:13:19
Message-ID: 56955E5F.9000404@chello.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello folks,

I tried to use psycopg2.Error.diag.column_name to get the column that
caused an integrity error. I have got a NOT NULL column and if I insert
NULL I of course get an error. But the diag.column_name of the error is
None.
Code I used: http://pastebin.com/raw/cQd670NK (users.prenames is NOT
NULL in this case)
Output I get:
|ERROR
None
null value in column "prenames" violates not-null constraint

I am using PostgreSQL 9.1.19 and psycopg2 2.6.1 (dt dec pq3 ext).
Corresponding documentation:
http://initd.org/psycopg/docs/module.html#psycopg2.Error.diag

I would appreciate some help.

Thanks,
Martin
|

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2016-01-12 20:21:04 Re: psycopg2.Error.diag properties are None
Previous Message Dan Sawyer 2015-10-28 18:48:46 Re: psycopg2 open file for reading