aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJacob Bachmeyer <jcb62281+dev@gmail.com>2020-06-09 21:34:59 -0500
committerJacob Bachmeyer <jcb62281+dev@gmail.com>2020-06-09 21:34:59 -0500
commit648796241f9041c49c8965d562f3129c0bc880d2 (patch)
treeb5fe73745a0ddb1dace75ac464b6d1030d58b98e
parent8c73aab67504afb81c84d68e2bde77ce692c20d3 (diff)
downloaddejagnu-648796241f9041c49c8965d562f3129c0bc880d2.zip
dejagnu-648796241f9041c49c8965d562f3129c0bc880d2.tar.gz
dejagnu-648796241f9041c49c8965d562f3129c0bc880d2.tar.bz2
Explain oddity in DB schema
-rw-r--r--contrib/database/psql.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/contrib/database/psql.sql b/contrib/database/psql.sql
index 1849b82..8429b51 100644
--- a/contrib/database/psql.sql
+++ b/contrib/database/psql.sql
@@ -69,6 +69,8 @@ CREATE TABLE dejagnu.manifest_runs (
PRIMARY KEY (manifest, run)
);
+-- The database refers to test groups as "sets" because "group" is a
+-- reserved word in SQL and creates quoting problems if used.
CREATE TABLE dejagnu.sets (
set serial PRIMARY KEY,
name text NOT NULL UNIQUE,