Skip to content

postgresql+asyncpg 组合改数据有问题 #12

Description

@dongfengweixiao

使用 postgresql+asyncpg 的组合,在更改数据时界面提示内部错误,终端提示:

sqlalchemy.exc.ProgrammingError: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.UndefinedFunctionError'>: operator does not exist: integer = character varying        
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
[SQL: UPDATE "user" SET username=%s WHERE "user".id IN (%s)]
[parameters: ('zhangsan6', '1')]
(Background on this error at: https://sqlalche.me/e/14/f405)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions