# HG changeset patch
# User jbe
# Date 1607190513 -3600
# Node ID e0b8175fda29cdd5683eef31fc507679888782d3
# Parent  63092784fe9d0bc21ffb44abfbf2da611aba96a6
Added TODO notice regarding indices on "posting"

diff -r 63092784fe9d -r e0b8175fda29 core.sql
--- a/core.sql	Sat Dec 05 04:04:52 2020 +0100
+++ b/core.sql	Sat Dec 05 18:48:33 2020 +0100
@@ -1402,6 +1402,10 @@
         CONSTRAINT "suggestion_requires_initiative" CHECK (
           "suggestion_id" ISNULL OR "initiative_id" NOTNULL ) );
 
+-- TODO: Table "posting" and associated objects still require proper indexing
+-- support. Preliminary indexing support was provided by Core version 4.2.0
+-- (using pgConflux up to version 0.5) but has been removed in version 4.2.1.
+
 COMMENT ON TABLE "posting" IS 'Text postings of members; a text posting may optionally be associated to a unit, area, policy, issue, initiative, or suggestion';