From 5a406a8b2fa88f2a5613ea270e361b477f6e658a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 6 Oct 2023 23:23:46 +0000 Subject: [PATCH] Add caution about installing db components in a piece-wise fashion --- make_files/make_db.mk | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/make_files/make_db.mk b/make_files/make_db.mk index ed88d47..6445bd0 100644 --- a/make_files/make_db.mk +++ b/make_files/make_db.mk @@ -539,6 +539,11 @@ db/schemas/gen_func_comment_tmpl.sql: $(DB_CACHE)/install_schemas ## from the database care must be taken to first drop the objects from the ## database(s) _before_ deleting the code which drops them. ## +## Caution: It is the user's responsibility to install components in +## the proper order when installing "piecemeal". I.e. tables must +## be installed before views and triggers, functions must be installed +## before comment SQL can be generated, etc. +## ## WARNING: Dropping or re-installing certain types of database objects ## can leave the database in an incomplete state. For example, ## dropping tables drops all the associated indexes, triggers, and views, -- 2.34.1