diff options
| author | Razvan Becheriu <razvan@isc.org> | 2022-02-28 15:28:56 +0200 |
|---|---|---|
| committer | Razvan Becheriu <razvan@isc.org> | 2022-02-28 18:01:56 +0200 |
| commit | ee964de4c2b3c39f073b15ca6ad1a25a32d170a3 (patch) | |
| tree | 2b5365abbec786148161c808bb546517bee689a3 /src/share/database/scripts/pgsql/dhcpdb_create.pgsql | |
| parent | 48d6cd5a1f616d672cb72cb417170cbd93c6cf9d (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.pgsql | 9 |
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 |
