尝试运行create table查询时出现UndefinedObjectError
尝试运行create table查询时出现UndefinedObjectError
提问于 2021-04-01 20:40:53
我正在尝试创建一个表，使用这个模式：
CREATE TABLE IF NOT EXISTS tags (id SERIAL, name TEXT, content TEXT, owner_id BIGINT, uses INTEGER DEFAULT (0), location_id BIGINT, created_at TIMESTAMP DEFAULT (now() at time zone 'utc'), PRIMARY KEY (id));但我在尝试创建它时遇到以下错误：
Could not create tags.
Traceback (most recent call last):
File "/root/AzuriteBot/launcher.py", line 119, in init
created = run(table.create(verbose=not quiet, run_migrations=False))
File "uvloop/loop.pyx", line 1494, in uvloop.loop.Loop.run_until_complete
File "/root/AzuriteBot/cogs/utils/db.py", line 662, in create
await con.execute(sql)
File "/usr/local/lib/python3.9/dist-packages/asyncpg/connection.py", line 297, in execute
return await self._protocol.query(query, timeout)
File "asyncpg/protocol/protocol.pyx", line 336, in query
asyncpg.exceptions.UndefinedObjectError: operator class "gin_trgm_ops" does not exist for access method "gin"这会不会是权限的问题？问题出在哪里？
回答 1
Stack Overflow用户
发布于 2021-04-01 21:03:44
好吧，我只是通过运行sql本身来修复这个问题，而不是尝试通过python脚本来完成这项工作。在我的例子中，使用db作为数据库池对象：
await db.fetch("CREATE TABLE IF NOT EXISTS tags (id SERIAL, name TEXT, content TEXT, owner_id BIGINT, uses INTEGER DEFAULT (0), location_id BIGINT, created_at TIMESTAMP DEFAULT (now() at time zone 'utc'), PRIMARY KEY (id));")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/66904714
复制相关文章
相似问题
腾讯云开发者
