Menu

#2 Some views raises erros when opened

open
nobody
table panel (2)
5
2005-11-28
2005-11-28
No

Some type of views does not have rowids. In these
cases, TableDataPanel must not include rowid in select
clause. The real problem is how to detect the updatable
views.

Examples of view that reproduce the problem are the
system views.

One possible solution is using metadata. "sys.view$"
has "property" and "flags" columns, but no
documentation. Searching in Google, a value of 16384
seems to be a "read-only" flag.

Discussion


Log in to post a comment.

MongoDB Logo MongoDB