Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-459

postgres might not drop all views, we should check the order here or something... (cascade will drop dependent views)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 1.6.1
    • 1.6.1
    • API
    • None

    Description

      >
      > So this is the grouper_memberships_all_v, you should see a column:
      > owner_id
      >

      For some reason I already had a view 'grouper_memberships_lw_v' in my database. When I ran the ddl script to upgrade to 1.6.0 the drop view of grouper_memberships_all_v failed because of the reference to it in grouper_memberships_lw_v. So I guess the create didn't work either.

      I saw the error from the run, and thought I had rerun the necessary commands that failed. Guess I missed something.

      I recreated all the affected views and everything is fine now.

      Jim

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: