[Pypgsql-devel] [ pypgsql-Bugs-611483 ] NULL not represented by Python None

[<no...@so...>]

Bugs item #611483, was opened at 2002-09-19 02:09
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=611483&group_id=16528

Category: PgSQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: NULL not represented by Python None

Initial Comment:
According to the Database API 2.0,  "SQL NULL values
are represented by the Python None singleton on input
and output." This doesn't seem to be the case:

INSERT INTO "XXX" ("foo", "bar",
        "baz", "bop") VALUES ('boo', None, None, None)
Traceback (most recent call last):
  File "XXX.py", line 90, in ?
    print XYZ_add()
  File "XXX.py", line 33, in ZZZ
    self.add_XYZ()
  File "XXX.py", line 25, in YYY
    self.cursor.execute(SQL)
  File
"/usr/lib/python2.1/site-packages/pyPgSQL/PgSQL.py",
line 2135, in execute
    raise OperationalError, msg
libpq.OperationalError: ERROR:  Attribute 'none' not found



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=611483&group_id=16528