- Community - mailweb.opengauss.org

QA SIG 02/27
by openGauss conference 24 Feb '25

24 Feb '25

您好！ QA 邀请您参加 2025-02-27 15:30 召开的WeLink会议会议主题：QA SIG 02/27 会议内容： 1、例行进展 2、议题评审会议链接：https://meeting.huaweicloud.com:36443/#/j/982708462 会议纪要：https://etherpad.opengauss.org/p/QA 更多资讯尽在：https://opengauss.org/zh/ Hello! QA invites you to attend the WeLink conference will be held at 2025-02-27 15:30, The subject of the conference is QA SIG 02/27, Summary: 1、例行进展 2、议题评审 You can join the meeting at https://meeting.huaweicloud.com:36443/#/j/982708462. Add topics at https://etherpad.opengauss.org/p/QA. More information: https://opengauss.org/en/

1 0

[Cancel] 双周例会
by openGauss conference 22 Feb '25

22 Feb '25

Sorry! The Zoom meeting will be held at 2025-03-05 20:30 scheduled by Infra SIG has been cancelled.

1 0

[Cancel] 双周例会
by openGauss conference 22 Feb '25

22 Feb '25

Sorry! The Zoom meeting will be held at 2025-03-05 14:00 scheduled by Infra SIG has been cancelled.

1 0

[Cancel] infra双周例会
by openGauss conference 22 Feb '25

22 Feb '25

Sorry! The WeLink meeting will be held at 2025-03-05 11:00 scheduled by Infra SIG has been cancelled.

1 0

[Cancel] 双周例会
by openGauss conference 22 Feb '25

22 Feb '25

Sorry! The Zoom meeting will be held at 2025-03-05 10:00 scheduled by Infra SIG has been cancelled.

1 0

双周例会
by openGauss conference 22 Feb '25

22 Feb '25

您好！ Infra 邀请您参加 2025-03-05 20:30 召开的Zoom会议会议主题：双周例会会议内容：双周例会会议链接：https://us06web.zoom.us/j/86062045663?pwd=00Kya9hqYSWKYujdIxZemj4on97Obv.1 会议纪要：https://etherpad.opengauss.org/p/Infra 更多资讯尽在：https://opengauss.org/zh/ Hello! Infra invites you to attend the Zoom conference will be held at 2025-03-05 20:30, The subject of the conference is 双周例会, Summary: 双周例会 You can join the meeting at https://us06web.zoom.us/j/86062045663?pwd=00Kya9hqYSWKYujdIxZemj4on97Obv.1. Add topics at https://etherpad.opengauss.org/p/Infra. More information: https://opengauss.org/en/

1 0

双周例会
by openGauss conference 22 Feb '25

22 Feb '25

您好！ Infra 邀请您参加 2025-03-05 14:00 召开的Zoom会议会议主题：双周例会会议内容：双周例会会议链接：https://us06web.zoom.us/j/88532027260?pwd=JT4jYGTuzx1CFrrKaiFTPJ66K7AZZp.1 会议纪要：https://etherpad.opengauss.org/p/Infra 更多资讯尽在：https://opengauss.org/zh/ Hello! Infra invites you to attend the Zoom conference will be held at 2025-03-05 14:00, The subject of the conference is 双周例会, Summary: 双周例会 You can join the meeting at https://us06web.zoom.us/j/88532027260?pwd=JT4jYGTuzx1CFrrKaiFTPJ66K7AZZp.1. Add topics at https://etherpad.opengauss.org/p/Infra. More information: https://opengauss.org/en/

1 0

[QA] 社区非问题issue公示
by 王平云 19 Feb '25

19 Feb '25

以下issue由于在issue下评论后无人回复，现根据社区issue处理规范（https://gitee.com/opengauss/QA/blob/… 对issue问题进行公示，7天后若无反馈，将按照处理规范对issue进行关闭。 https://e.gitee.com/opengaussorg/issues/table?issue=IBLSA9 gs_dump -n 失效; 原因：非问题。使用gs_dump时如果已经使用-t指定表，那么-n会失去效应，具体的解释已在issue评论中说明。

1 0

openGauss 6.0.0环境，三权分立打开的环境下，安全管理员不能正常赋权限给角色
by 18970812136＠189.cn 18 Feb '25

18 Feb '25

相关执行如下： [omm@master2 dn]$ gsql -d postgres -p 15400 gsql ((openGauss 6.0.0 build aee4abd5) compiled at 2024-09-29 18:38:08 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. openGauss=# show enableSeparationOfDuty; enableSeparationOfDuty ------------------------ on (1 row) 1、创建安全管理员 openGauss=# CRAETE USER createrole WITH CREATEROLE password 'xxxxxxxxxxx'; CREATE ROLE openGauss=# \q 2、使用安全管理员登录数据库 [omm@master2 dn]$ gsql -d postgres -p 15400 -U createrole -W '*******'; 3、创建一个用户 openGauss=> CREATE user test password 'xxxxxxxxxxx'; CREATE ROLE 4、修改一个用户提示Permission denied openGauss=> ALTER user test CREATEROLE; ERROR: Permission denied. 5、创建一个角色yf openGauss=> CREATE role yf password 'xxxxxxxxxxx'; CREATE ROLE 6、赋予yf这个角色连接数据库testdb的权限，报错no privileges were granted for "testdb" openGauss=> GRANT CONNECT ON DATABASE testdb to yf; ERROR：no privileges were granted for "testdb". 以上执行有问题的命令，使用初始化用户可以正常执行。刘司会 18970812136(a)189.cn

1 0

存储过程创建报错
by 张驰 17 Feb '25

17 Feb '25

你好，我做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

1 0