Feedback:

← General

Editing a view requires exclusive access

You can't edit a view while tables are in use, you get an invalid open mode error. If possible, please remove this requirement so views can be edited on a live system. Thanks.

1 vote
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    ahinsonahinson shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  jeremym1234jeremym1234 responded  · 

    The only way I was able to re-create this was by opening a table in exclusive mode, which would then cause view modification to return a 7008 error. The view dialog verifies the correctness of the sql by running a semantic check, which can’t complete if a table the view uses is opened exclusive.

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • synacksynack commented  ·   ·  Flag as inappropriate

        I've seen this happen when exclusive access wasn't in use. I can't give you an example at the moment but it does happen.

      • jeremym1234jeremym1234 commented  ·   ·  Flag as inappropriate

        I could not re-create this. If tables the view references are opened shared, this works. If any of the tables are opened exclusive, it fails, which is expected.

      General

      Knowledge Base and Helpdesk

      (thinking…)
      Reset