PgNumeric and NULL values

Ivar Zarans <[email protected]> Mon, 15 Dec 2003 01:02:59 +0200
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
Hello!

I am playing around with PyPgSQL and found interesting behaviour:
Updating numeric field with values of '0.00' generates query, trying
update with 'NULL'. Since column is defined as 'NOT NULL', update fails
with exception:
"OperationalError: ERROR:  ExecUpdate: Fail to add null value in not
null attribute... "

Is this normal?

-- 
Best regards,
Ivar Zarans



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/