Feature request #21196
better message when trying to do not permitted operations on virtual layers
| Status: | Open | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Virtual Layers | ||
| Pull Request or Patch supplied: | No | Resolution: | |
| Easy fix?: | No | Copied to github as #: | 29014 |
Description
It seems that a simple request like
update mytable set myfield='toto' where id='1''.
does not work with virtual layers
message :
Query execution error on CREATE TEMP VIEW _tview AS update mytable set myfield = "toto" WHERE id='1' - near "update": syntax error
while the query works correctly under PostgreSQL
History
#1
Updated by Giovanni Manghi almost 6 years ago
- Status changed from Open to Feedback
to me this is no bug: virtual layers are like standard database views, are read only.
#2
Updated by Alain FERRATON almost 6 years ago
Indeed. update on views in a database requires triggers or rules.
A more explicit message for users would be appreciated.
#3
Updated by Giovanni Manghi almost 6 years ago
Alain FERRATON wrote:
Indeed. update on views in a database requires triggers or rules.
A more explicit message for users would be appreciated.
so better change the title and make this a a feature request, ok?
#4
Updated by Alain FERRATON almost 6 years ago
OK
Thanks
#5
Updated by Giovanni Manghi almost 6 years ago
- Status changed from Feedback to Open
- Tracker changed from Bug report to Feature request
- Subject changed from update does not work with virtual layers to better message when trying to do not permitted operations on virtual layers