Hello all.
I have come across an interesting problem with sqlalchemy.
I am using 0.6.8 and plan to shift obviously to the .7 series.
But what ever the version is, I find this is really very interesting.
I have to execute stored procedures written in plpgsql (for postgresql
9.0).
The problem is very streight and precise.
I have a table called account. in this table there are 2 columns
groupcode and subgroupcode.
groupcode comes as a foreign key from the table group that contains
groupname and groupcode.
However subgroupcode is optional as some accounts seldum get added to a
group directly without a subgroup.
So in that condition I need to insert null for subgroupcode.
following is my query
engine.execute("select * from setAccount('grp001','account_name',None")
Ofcourse I have set the auto commit flag on but i did not include that
here just to make things precise.
I get an error that says column None does not exist.
I wish to know if None in Python really gets converted to null in
postgresql?
or is it my misinterpretation
that this can happen?
happy hacking.
Krishnakant.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
