summaryrefslogtreecommitdiff
path: root/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
diff options
context:
space:
mode:
authorRazvan Becheriu <razvan@isc.org>2022-02-28 15:28:56 +0200
committerRazvan Becheriu <razvan@isc.org>2022-02-28 18:01:56 +0200
commitee964de4c2b3c39f073b15ca6ad1a25a32d170a3 (patch)
tree2b5365abbec786148161c808bb546517bee689a3 /src/share/database/scripts/pgsql/dhcpdb_create.pgsql
parent48d6cd5a1f616d672cb72cb417170cbd93c6cf9d (diff)
[#2322] addressed review comments
Diffstat (limited to 'src/share/database/scripts/pgsql/dhcpdb_create.pgsql')
-rw-r--r--src/share/database/scripts/pgsql/dhcpdb_create.pgsql9
1 files changed, 5 insertions, 4 deletions
diff --git a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
index 4ee81e6ddd..6cb33ff1a7 100644
--- a/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
+++ b/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
@@ -4522,11 +4522,11 @@ LANGUAGE plpgsql;
-- -----------------------------------------------------------------------
-- Stored procedure positioning an inserted or updated client class
-- within the class hierarchy, depending on the value of the
--- follow_class_name parameter.
+-- new_follow_class_name parameter.
--
-- Parameters:
-- - id id of the positioned class,
--- - follow_class_name name of the class after which this class should be
+-- - new_follow_class_name name of the class after which this class should be
-- positioned within the class hierarchy.
-- - old_follow_class_name previous name of the class after which this
-- class was positioned within the class hierarchy.
@@ -4624,7 +4624,7 @@ BEGIN
-- whenever the dhcp4_client_class record is updated. Such update may include
-- test expression changes impacting the dependency on KNOWN/UNKNOWN classes.
-- This value will be later adjusted when dependencies are inserted.
- -- ON CONFLICT required 9.5 or later
+ -- TKM - note that ON CONFLICT requires PostgreSQL 9.5 or later.
UPDATE dhcp4_client_class_order
SET order_index = follow_class_index + 1,
depend_on_known_indirectly = l_depend_on_known_indirectly
@@ -4638,8 +4638,9 @@ BEGIN
RETURN;
END;$$;
--- Replace setClientClass4Order():
+-- Replace setClientClass6Order():
-- 1. l_depend_on_known_indirectly needs to be BOOL
+-- 2. follow_class_index needs to be BIGINT
-- -----------------------------------------------------------------------
-- Stored procedure positioning an inserted or updated client class