ODBC上的参数化upsert命令不起作用。

在ODBC连接字符串中使用“SQL_ATTR_PARAMSET_SIZE”选项，以指定参数集大小，以便正确处理upsert命令。

以下是示例代码：

import pyodbc

# Connect to database
conn_string = "Driver={PostgreSQL Unicode};Server=localhost;Database=mydb;Uid=myuser;Pwd=mypwd;SQL_ATTR_PARAMSET_SIZE=1"
conn = pyodbc.connect(conn_string)

# Define upsert command
upsert_sql = """INSERT INTO mytable (id, value)
                VALUES (?, ?)
                ON CONFLICT (id)
                DO UPDATE SET value = EXCLUDED.value"""

# Create data to upsert
data = [(1, "Value1"), (2, "Value2"), (3, "Value3")]

# Execute upsert command
cursor = conn.cursor()
cursor.executemany(upsert_sql, data)
conn.commit()