Re: PgNumeric and NULL values

"Billy G. Allie" <[email protected]> Sun, 14 Dec 2003 20:53:33 -0500

Newsgroups	gmane.comp.python.db.pypgsql.user
Message-ID	<[email protected]>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ivar Zarans wrote:
| 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?
|

Can you post sample code that exhibits this behavior please.

Thanks.

- --
____       | Billy G. Allie    | Domain....: [email protected]
|  /|      | 7436 Hartwell     | MSN.......: [email protected]
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/3RQcnmIkMXoVVdURAtxtAKCKW2GNrimqYmNDbqShJHrHVnLI4ACeOrdf
SpyoSH5VpPYED/P12NW+vJ8=
=jpdR
-----END PGP SIGNATURE-----



-------------------------------------------------------
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/