[sqlalchemy] Passing a dict as JSON argument to a custom Postgres function

[Stefan Urbanek]

Hi,

I have a custom PostgreSQL function that takes two JSON-type arguments:

CREATE OR REPLACE FUNCTION "update_json"(original json, update_obj json)


When I try to use the function in sqlalchemy:

a_dictionary = dict(...)

value = sqlalchemy.sql.func.update_json(a_json_column, a_dictionary) 

table.update().values(a_json_column=value)


It fails with:

sqlalchemy.exc.ProgrammingError: (ProgrammingError) can't adapt type 'dict' 


What am I missing?

Thanks,

Stefan 

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.