399 Star 1.3K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

希望原生支持视图的更新,删除,插入操作,不是通过rule或者trigger实现

已完成
需求 成员
创建于  
2021-02-23 09:52

Is this a BUG REPORT or FEATURE REQUEST?:

Uncomment only one, leave it on its own line:

  • bug

  • feature

What happened:SQL 错误 [55000]: ERROR: cannot update view "testobj"
Hint: You need an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.
ERROR: cannot update view "testobj"
Hint: You need an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.
ERROR: cannot update view "testobj"
Hint: You need an unconditional ON UPDATE DO INSTEAD rule or an INSTEAD OF UPDATE trigger.

What you expected to happen:输入图片说明

How to reproduce it (as minimally and precisely as possible):

Anything else we need to know?:

Environment:

  • Version:
  • OS (e.g. from /etc/os-release):
  • Kernel (e.g. uname -a):
  • Install tools:
  • Others:

评论 (2)

lihongda 创建了任务
lihongda 关联仓库设置为openGauss/openGauss-server
展开全部操作日志

Hey @lihongda, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss-bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at https://gitee.com/opengauss/community/blob/master/contributors/command.en.md to find the details.

zhangxubo 修改了描述
zhangxubo 任务类型任务 修改为缺陷
zhangxubo 添加了
 
kind/feature
标签
zhangxubo 添加了
 
sig/sqlengine
标签
yansong_lee 移除了
 
kind/feature
标签
yansong_lee 添加了
 
kind/feature
标签
yansong_lee 移除了
 
sig/sqlengine
标签
yansong_lee 优先级设置为次要
yansong_lee 任务类型缺陷 修改为需求
yansong_lee 负责人设置为宋清怡
zhangxubo 添加了
 
sig/sqlengine
标签
赵文浩 优先级次要 修改为不指定

openGauss 5.0.0版本已支持。

熊小军 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(3)
5622128 opengauss bot 1581905080 7758905 wx a946a2d3d9 1593531765
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助