dbeaver / dbeaver/cloudbeaver

Cannot update PostgreSQL updatable view

Open
#383 4 comments 0 reactions 0 assignees View on GitHub
xf:data editor
Dominant language
TypeScript
Stars
5.1k
Forks
563
Avg merge
3d 9h
Merged PRs (30d)
59

Description

**Describe the bug**
A PostgreSQL updatable view cannot be updated. Error message:
`Can't detect row identifier for data container 'v_test'. It must have at least one unique key.`

**To Reproduce**
Steps to reproduce the behavior:
1.
```
CREATE SCHEMA test;
CREATE TABLE test.test (
id integer PRIMARY KEY,
value integer NULL
);
CREATE VIEW test.v_test
AS SELECT test.id, test.value
FROM test.test;
INSERT INTO test.v_test (id, value) VALUES(1, NULL);

```
2. Try to change value

**Desktop:**
- OS: macOS 11.4
- Browser Chrome
- Version 91

**Additional context**
Database: PostgreSQL 13.3

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.