Cannot update PostgreSQL updatable view
Open
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.