An off the wall request...... updateable view

[Biggs, Allan]

I have spent the day wishing that I could update a view.

Just in case - there is a way of achieving something similar - is there a construct out there which behaves like a view which can be updated like a table ??? 

A quick google showed that MYSQL , postgres ,sql server allow this with restrictions ....I couldn't find specifically that Ingres allows them . I have a 3 or 4 table join I saw references to views being updateable in MYSQL if there was only one table in the view.

Anyone know if I can update a multi join view in 11.1 ? And any issues if I can ? 

Thanks Allan

This communication is for use by the intended recipient and contains information that may be Privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail,in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as "E-Contract Intended", this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties.


Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean

https://www.dupont.com/email-disclaimer.html

[Bodo Bergmann]

A view is updateable in Ingres if it only uses one table.
Otherwise you’ll get an according error like this:
E_US0D02 UPDATE on view viewname: update of a multi-variable view not allowed.

 

Bodo.

 

Bodo Bergmann
Engineering Architect
Actian | OpenROAD Engineering
www.actian.com
GESELLSCHAFTSANGABEN: Actian Germany GmbH | Sitz der Gesellschaft: Halenreie 42, 22359 Hamburg | Geschäftsführung: Stephen Padgett, Marc Monahan | Handelsregister: Amtsgericht Hamburg | HRB 135991 | USt-IdNr: DE252449897

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/BY5PR11MB39750FCA5610F4E887A871C899989%40BY5PR11MB3975.namprd11.prod.outlook.com.