[Community] 存储过程创建报错

17 Feb 2025


      你好，我做postgresql迁移opengauss。
创建存储过程报错。能不能给指导一下问题？

CREATEORREPLACEPROCEDUREproc_create_table_partition(tablenamecharactervarying, starttimecharactervarying, endtimecharactervarying)

LANGUAGEplpgsql

AS$procedure$

DECLARE

createSqltext;

partitionNametext;

begin

-- 生成分区名 格式：p_tableName_yyyyMMdd

partitionName := 'p_' || lower(tableName) || '_' || to_char(to_timestamp(endtime, 'YYYY-MM-DD HH24:MI:SS'),'yyyyMMdd');

createSql := 'CREATE TABLE ' || partitionName || ' PARTITION OF ' || tableName || ' FOR VALUES FROM ('''||startTime||''') TO ('''||endTime||''');';

EXECUTEcreateSql;

end;

$procedure$

;


报错：org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [42601]: ERROR: syntax error at or near "LANGUAGE"
Position: 73

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130)

at

[Community] 存储过程创建报错

张驰