- Community - mailweb.opengauss.org

[Update] openGauss社区TC & RM SIG联合例会
by openGauss conference 21 Mar '25

21 Mar '25

您好！ TC 邀请您参加 2025-03-21 16:00 召开的Zoom会议会议主题：[Update] openGauss社区TC & RM SIG联合例会会议内容：已申报议题： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！会议链接：https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 会议纪要：https://etherpad.opengauss.org/p/TC 更多资讯尽在：https://opengauss.org/zh/ Hello! TC invites you to attend the Zoom conference will be held at 2025-03-21 16:00 The subject of the conference is [Update] openGauss社区TC & RM SIG联合例会 Summary: 已申报议题： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！ You can join the meeting at https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 Add topics at https://etherpad.opengauss.org/p/TC More information: https://opengauss.org/en/

1 0

[Update] openGauss社区TC例会
by openGauss conference 19 Mar '25

19 Mar '25

您好！ TC 邀请您参加 2025-03-21 16:00 召开的Zoom会议会议主题：[Update] openGauss社区TC例会会议内容：已申报议题： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！会议链接：https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 会议纪要：https://etherpad.opengauss.org/p/TC 更多资讯尽在：https://opengauss.org/zh/ Hello! TC invites you to attend the Zoom conference will be held at 2025-03-21 16:00 The subject of the conference is [Update] openGauss社区TC例会 Summary: 已申报议题： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！ You can join the meeting at https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 Add topics at https://etherpad.opengauss.org/p/TC More information: https://opengauss.org/en/

1 0

openGauss社区TC例会
by openGauss conference 19 Mar '25

19 Mar '25

您好！ TC 邀请您参加 2025-03-21 15:30 召开的Zoom会议会议主题：openGauss社区TC例会会议内容：议题申报： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！会议链接：https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 会议纪要：https://etherpad.opengauss.org/p/TC 更多资讯尽在：https://opengauss.org/zh/ Hello! TC invites you to attend the Zoom conference will be held at 2025-03-21 15:30 The subject of the conference is openGauss社区TC例会 Summary: 议题申报： 1、openGauss 7.0.0-RC1发布评审——汇报人：陈栋欢迎大家积极申报议题！ You can join the meeting at https://us06web.zoom.us/j/86558783568?pwd=NroKF3DhU72sn2R1YrFGleJQLlursf.1 Add topics at https://etherpad.opengauss.org/p/TC More information: https://opengauss.org/en/

1 0

SQL SIG
by openGauss conference 14 Mar '25

14 Mar '25

您好！ SQLEngine 邀请您参加 2025-03-18 10:00 召开的WeLink会议会议主题：SQL SIG 会议内容： 1.INSERT&REPLACE性能优化优化设计方案评审——赖盛好会议链接：https://meeting.huaweicloud.com:36443/#/j/988151607 会议纪要：https://etherpad.opengauss.org/p/SQLEngine 更多资讯尽在：https://opengauss.org/zh/ Hello! SQLEngine invites you to attend the WeLink conference will be held at 2025-03-18 10:00, The subject of the conference is SQL SIG, Summary: 1.INSERT&REPLACE性能优化优化设计方案评审——赖盛好 You can join the meeting at https://meeting.huaweicloud.com:36443/#/j/988151607. Add topics at https://etherpad.opengauss.org/p/SQLEngine. More information: https://opengauss.org/en/

1 0

openGauss RISC-V sig 常规例会
by openGauss conference 10 Mar '25

10 Mar '25

您好！ RISC-V 邀请您参加 2025-03-12 14:30 召开的Zoom会议会议主题：openGauss RISC-V sig 常规例会会议内容：同步sig组在移植、开发、测试和功能规划等方面的最新进展会议链接：https://us06web.zoom.us/j/86539649981?pwd=8XiZAhp108pkXvXAjCQgVoxs9SKmzr.1 会议纪要：https://etherpad.opengauss.org/p/RISC-V 更多资讯尽在：https://opengauss.org/zh/ Hello! RISC-V invites you to attend the Zoom conference will be held at 2025-03-12 14:30, The subject of the conference is openGauss RISC-V sig 常规例会, Summary: 同步sig组在移植、开发、测试和功能规划等方面的最新进展 You can join the meeting at https://us06web.zoom.us/j/86539649981?pwd=8XiZAhp108pkXvXAjCQgVoxs9SKmzr.1. Add topics at https://etherpad.opengauss.org/p/RISC-V. More information: https://opengauss.org/en/

1 0

[Update] QA SIG 03/13
by openGauss conference 10 Mar '25

10 Mar '25

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

1 0

QA SIG 03/13
by openGauss conference 10 Mar '25

10 Mar '25

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

1 0

openGauss Docs SIG双周例会
by openGauss conference 07 Mar '25

07 Mar '25

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

1 0

[SQLEngine][QA]社区非问题issue公示
by 梅程 05 Mar '25

05 Mar '25

Hi all，以下issue由于在issue下评论后无人回复，现根据社区issue处理规范（https://gitee.com/opengauss/QA/blob/… https://gitee.com/opengauss/openGauss-server/issues/IBHNCW   2.0.0-5.0.0升级后部分数据库对象被删除原因：正常升级流程，属于非问题。2.0.0升级至5.0.0过程中，系统视图pg_stat_activity会被级联删除后重建，会导致关联的数据丢失；如… Best regards, 梅程

1 0

sig storageengine例会
by openGauss conference 05 Mar '25

05 Mar '25

您好！ StorageEngine 邀请您参加 2025-03-10 14:30 召开的WeLink会议会议主题：sig storageengine例会会议内容： sig storageengine例会会议链接：https://meeting.huaweicloud.com:36443/#/j/984491788 会议纪要：https://etherpad.opengauss.org/p/StorageEngine 更多资讯尽在：https://opengauss.org/zh/ Hello! StorageEngine invites you to attend the WeLink conference will be held at 2025-03-10 14:30, The subject of the conference is sig storageengine例会, Summary: sig storageengine例会 You can join the meeting at https://meeting.huaweicloud.com:36443/#/j/984491788. Add topics at https://etherpad.opengauss.org/p/StorageEngine. More information: https://opengauss.org/en/

1 0

[Cancel] sig storageengine 例会
by openGauss conference 05 Mar '25

05 Mar '25

Sorry! The WeLink meeting will be held at 2025-03-07 14:30 scheduled by StorageEngine SIG has been cancelled.

1 0

QA SIG 03/06
by openGauss conference 03 Mar '25

03 Mar '25

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

1 0

sig storageengine 例会
by openGauss conference 27 Feb '25

27 Feb '25

您好！ StorageEngine 邀请您参加 2025-03-07 14:30 召开的WeLink会议会议主题：sig storageengine 例会会议内容： sig storageengine 例会会议链接：https://meeting.huaweicloud.com:36443/#/j/985634439 会议纪要：https://etherpad.opengauss.org/p/StorageEngine 更多资讯尽在：https://opengauss.org/zh/ Hello! StorageEngine invites you to attend the WeLink conference will be held at 2025-03-07 14:30, The subject of the conference is sig storageengine 例会, Summary: sig storageengine 例会 You can join the meeting at https://meeting.huaweicloud.com:36443/#/j/985634439. Add topics at https://etherpad.opengauss.org/p/StorageEngine. More information: https://opengauss.org/en/

1 0

openGauss RISC-V sig 常规例会
by openGauss conference 24 Feb '25

24 Feb '25

您好！ RISC-V 邀请您参加 2025-02-26 14:30 召开的Zoom会议会议主题：openGauss RISC-V sig 常规例会会议内容：同步sig组在移植、开发、测试和功能规划等方面的最新进展会议链接：https://us06web.zoom.us/j/89657366057?pwd=LXvJYaKji9ZCcoP8GRcMvUPaEGDM7u.1 会议纪要：https://etherpad.opengauss.org/p/RISC-V 更多资讯尽在：https://opengauss.org/zh/ Hello! RISC-V invites you to attend the Zoom conference will be held at 2025-02-26 14:30, The subject of the conference is openGauss RISC-V sig 常规例会, Summary: 同步sig组在移植、开发、测试和功能规划等方面的最新进展 You can join the meeting at https://us06web.zoom.us/j/89657366057?pwd=LXvJYaKji9ZCcoP8GRcMvUPaEGDM7u.1. Add topics at https://etherpad.opengauss.org/p/RISC-V. More information: https://opengauss.org/en/

1 0

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

创建MOT表失败：ERROR:permission denied for foreign server mot_server
by 18970812136＠189.cn 13 Feb '25

13 Feb '25

CREATE FOREIGN TABLE mot_test(id int,name varchar(20)); ERROR：permission denied for foreign server mot_server DETAIL：N/A 测试结果： user database schema 测试结果 omm test_db public 正常 test postgres public 正常 test test_db public 不正常创建MOT表还跟哪些因素有关系？刘司会 18970812136(a)189.cn

2 1