Feature request #21196

better message when trying to do not permitted operations on virtual layers

Added by Alain FERRATON about 1 year ago. Updated about 1 year ago.

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 about 1 year 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 about 1 year 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 about 1 year 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 about 1 year ago

OK
Thanks

#5 Updated by Giovanni Manghi about 1 year 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

Also available in: Atom PDF