diff options
| author | Karen Arutyunov <karen@codesynthesis.com> | 2018-10-12 14:31:10 +0300 |
|---|---|---|
| committer | Karen Arutyunov <karen@codesynthesis.com> | 2018-10-12 15:43:26 +0300 |
| commit | b9055ec9d4057822f2955066bdec59c71418feef (patch) | |
| tree | a696da9a3a4a198ec5d723537c98a416c9f43768 /libbrep/package-extra.sql | |
| parent | e97c6b9b9c90a6f97019021d6bfcc73ed92580cc (diff) | |
Recreate database schema extras on migration
Diffstat (limited to 'libbrep/package-extra.sql')
| -rw-r--r-- | libbrep/package-extra.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/libbrep/package-extra.sql b/libbrep/package-extra.sql index 93c61d8..86f055b 100644 --- a/libbrep/package-extra.sql +++ b/libbrep/package-extra.sql @@ -8,6 +8,13 @@ -- * strings other then function bodies must be quoted with ' or " -- * statements must end with ";\n" -- +-- Increment the database 'package' schema version when update this file. Note +-- that the brep-migrate utility executes the drop SQL statements prior to the +-- schema migration and the create statements afterwards. That, in particular, +-- means that the extras may depend on the tables but not the other way +-- around. Make sure that the drop statements properly handle entities created +-- for all schema versions starting from LIBBREP_PACKAGE_SCHEMA_VERSION_BASE. +-- -- There is no need to drop to_tsvector() explicitly, as we can rely on "DROP -- TYPE IF EXISTS weighted_text CASCADE" statement below, which will drop all |