hstore_plluau

Lua 程序语言的Hstore适配扩展（不受信任的）
仓库
pllua/pllua
https://github.com/pllua/pllua

概览

扩展包名版本分类许可证语言
pllua2.0.12LANGMITC
ID扩展名BinLibLoadCreateTrustReloc模式
3020pllua否是否是否否pg_catalog
3021hstore_pllua否是否是否是-
3030plluau否是否是否否pg_catalog
3031hstore_plluau否是否是否是pg_catalog
相关扩展hstore plluau hstore hstore_plpython3u hstore_plperl hstore_plperlu

版本

类型仓库版本PG 大版本包名依赖
EXTMIXED2.0.121817161514plluahstore, plluau
RPMPIGSTY2.0.121817161514pllua_$v-
DEBPGDG2.0.121817161514postgresql-$v-pllua-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
el8.aarch64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
el9.x86_64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
el9.aarch64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
el10.x86_64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
el10.aarch64PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12PIGSTY 2.0.12
d12.x86_64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
d12.aarch64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
d13.x86_64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
d13.aarch64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u22.x86_64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u22.aarch64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u24.x86_64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u24.aarch64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u26.x86_64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12
u26.aarch64PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12PGDG 2.0.12

安装

您可以直接安装 pllua 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH 
pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装
BASH 
pig install pllua;          # 当前活跃 PG 版本安装
pig
BASH 
pig ext install -y pllua -v 18  # PG 18
pig ext install -y pllua -v 17  # PG 17
pig ext install -y pllua -v 16  # PG 16
pig ext install -y pllua -v 15  # PG 15
pig ext install -y pllua -v 14  # PG 14
dnf
BASH 
dnf install -y pllua_18       # PG 18
dnf install -y pllua_17       # PG 17
dnf install -y pllua_16       # PG 16
dnf install -y pllua_15       # PG 15
dnf install -y pllua_14       # PG 14
apt
BASH 
apt install -y postgresql-18-pllua   # PG 18
apt install -y postgresql-17-pllua   # PG 17
apt install -y postgresql-16-pllua   # PG 16
apt install -y postgresql-15-pllua   # PG 15
apt install -y postgresql-14-pllua   # PG 14

创建扩展：

SQL 
CREATE EXTENSION hstore_plluau CASCADE;  -- 依赖: hstore, plluau

用法

hstore_plluau: 不可信 PL/Lua 的 hstore 转换支持

hstore_plluau 扩展提供了一个转换器，允许 hstore 值在不可信 PL/Lua（plluau）函数中作为原生 Lua 表直接传递和返回。

SQL 
CREATE EXTENSION hstore;
CREATE EXTENSION plluau;
CREATE EXTENSION hstore_plluau;

在 plluau 中使用 hstore

安装转换器后，hstore 参数会自动转换为 Lua 表：

SQL 
CREATE FUNCTION process_hstore(h hstore) RETURNS hstore LANGUAGE plluau AS $$
  -- h 是一个具有字符串键和字符串值的 Lua 表
  h["processed"] = "true"
  -- 还可以执行不受限操作（文件 I/O 等）
  return h
$$;

SELECT process_hstore('key1 => "val1", key2 => "val2"'::hstore);

这是 hstore_pllua 的不可信对应版本。行为完全相同——hstore 值变为 Lua 表，反之亦然——但函数在不受限的 plluau 环境中运行。


最后修改 2026-08-12 · extension update 2026-08-12 (7a2fdbbd)