Skip to content
Snippets Groups Projects

[WIP] storage: drop obsolete occurrences-related stuff

Goal is to remove obsolete occurrence-related tables and dependent objects (indexes, functions, storage endpoints, etc.).

While at it, I'm also taking the chance of uniforming style and messages in the SQL definitions, but those changes will be committed separately.


Migrated from D446 (view on Phabricator)

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Sounds right.

    You might already be working on that, but that's worth mentioning, there remains to:

    • check the indexes file (sql/swh-indexes.sql) to drop the related indexes
    • add the migration script sql/upgrades/121.sql which adds the equivalent drop instructions.

    Cheers,

  • Author Maintainer
    • SQL: drop obsolete indexes and functions related to occurrence tables
  • Author Maintainer

    ! In !89 (closed), @ardumont wrote: You might already be working on that, but that's worth mentioning, there remains to:

    • check the indexes file (sql/swh-indexes.sql) to drop the releated indexes

    Nice catch. I didn't look outside swh-schema.sql, but there was indeed dangling stuff elsewhere: indexes, but also functions… Diff updated

    • add the migration script sql/upgrades/121.sql which adds the equivalent drop instructions.

    bin/db-upgrade now fails with a Java traceback :-(

  • Author Maintainer

    Merge request was merged

Please register or sign in to reply
Loading