unknown function name: set_config(STRING,STRING,BOOLEAN) when using parameters in `CONCAT` function

• asyncpg version: 0.30.0
• PostgreSQL version: QuestDB 8.1.4
• Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
  the issue with a local PostgreSQL install?: -
• Python version: 3.12.7
• Platform: Linux 6.11.5-arch1-1
• Do you use pgbouncer?: no
• Did you install asyncpg with pip?: yes
• If you built asyncpg locally, which version of Cython did you use?: -
• Can the issue be reproduced under both asyncio and
  uvloop?: yes

Hello,

I am using asyncpg with QuestDB and I am getting an error with this query:

SELECT FIRST("value")
FROM "values"
WHERE "type" = CONCAT('X', $1, '-', $2)

The error:

asyncpg.exceptions._base.UnknownPostgresError: unknown function name: set_config(STRING,STRING,BOOLEAN)

It works when sending the same query using libpqxx in C++, so I think this is not a problem with QuestDB.

首先，在 asyncio 和 uvloop 下使用 asyncpg 0.30.0 针对 QuestDB 8.1.4 重现参数化的 CONCAT 查询，然后将其与已报告的 libpqxx 行为进行比较。完成的标准是确定 set_config 错误源于 asyncpg 的查询处理还是 QuestDB 兼容性问题，并记录已确认的修复方案或限制。