Why a non-read-omly connection tables can't be edited?

Answered

Sometimes they can, sometimes they can't 

Same table but when data is shows not in Services but in the Console tab

0
9 comments

Have you noticed any patterns to reproduce that problem?

Action will not be available if there is an introspection or indexing process running (you can check the right-bottom bar for these actions).

0

How can I stop the introspection? Sometimes it takes dozens of minutes but I think that could be the reason actually. But if the introspection is in a different portion of the database, why would it still lock this one table?

Also the difference in my screenshots is in matter of seconds and the one in services tab actually didn't get enabled even after a while

0

Please share the information about your connection by clicking on Test Connection button in the data source properties.

I cannot reproduce the problem with a disabled button for adding a new row in Services tab.

Feel free to follow DBE-6687 to support introspection for specified/selected objects. I believe it will speed up the process in your case.

0

@Dawid, is that tables (result sets) produced by a query?

0

Yes the result is always produced by the query

0

Could you provide sample query? Since we've numerous issues similar to yours and I hope we can find root cause together.

0

The query was just a simple SELECT * FROM table, no JOINs (as I know sometimes joins render the result read-only)

0

@Dawid,

Strange, could you add any rows to that table if you open it from Database Navigator via F4?

0

Please sign in to leave a comment.