Hi,
I want to insert a compound to table Substance. The table has id,
smiles(varchar) and structure(Mol). I used Mol class from
https://github.com/rvianello/razi repository.

When I try to execute SQL query using asyncpg:

  insert into substance
    (smiles, structure)
    (select  r.smiles, r.structure from unnest($1::substance[]) as r)

I have an error:

asyncpg.exceptions._base.UnsupportedClientFeatureError: cannot decode
type "public"."substance": text encoding of composite types is not
supported

Do you have any suggestions on how to fix it? I have to use asyncpg
Thank you,
Kate
_______________________________________________
Rdkit-discuss mailing list
Rdkit-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss

Reply via email to