postgresql 创建索引:ERROR: operator class "gin_trgm_ops" does not exist for access method "gin"
2024-08-27 11:56:06
g_trgm
is an extension, so:
CREATE EXTENSION pg_trgm;
If you get the following error
ERROR: could not open extension control file ".../extension/pg_trgm.control":
No such file or directory"
then you need to install the module for your operating system
Ubuntu/Debian:
sudo apt install postgresql-contrib
Redhat/Centos
sudo yum install postgresql10-contrib
Fedora
sudo dnf install postgresql-contrib
最新文章
- 火车采集器 帝国CMS7.2免登录发布模块
- Urban Planning and Public Health - Reflection on Professor Webster's article in Urban Planning Forum
- Thinkphp 不显示生成的验证码 【转载】
- link them together by means of pointers
- Java基本开发环境搭建(适合第一次使用)
- HDU4758 Walk Through Squares AC自动机&;&;dp
- PHP 冒泡排序法
- 初次运行 Git 前的配置
- 关于Console的Main(String[] args)参数输入
- 解决无法打开myeclipse-->;“The default workspace'D: /myeclipse spaceis in use or cannot be created. Please choose a different one”
- linux命令(36):vimdiff文件对比
- Python+SparkStreaming+kafka+写入本地文件案例(可执行)
- P3216 [HNOI2011]数学作业 (矩阵快速幂)
- 一、WPF 2个datagrid之间同步进度条
- initerrlog: 无法打开错误日志文件 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log 解决办法
- JavaScript学习日志(2)
- DNSPod--国内最早提供免费智能DNS产品的网站,致力于为各类网站提供高质量的多线智能DNS免费解析
- javascript Date对象 之 时间转字符串
- 帮助小伙伴写的组装xml字符串类
- 谁说selenium打开firefox不用驱动的???!!!!