Adjusted line numbers of database creation script

diff --git a/test/t0001.errors b/test/t0001.errors
index 89867e7..8648c01 100644 (file)
--- a/test/t0001.errors
+++ b/test/t0001.errors
@@ -1,11 +1,11 @@
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist

diff --git a/test/t0002a.errors b/test/t0002a.errors
index 89867e7..8648c01 100644 (file)
--- a/test/t0002a.errors
+++ b/test/t0002a.errors
@@ -1,11 +1,11 @@
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist

diff --git a/test/t0003.errors b/test/t0003.errors
index a52c6a4..b435ab4 100644 (file)
--- a/test/t0003.errors
+++ b/test/t0003.errors
@@ -1,14 +1,13 @@
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 gcm_input WARNING: Not a valid line: nearly empty line
 gcm_input WARNING: Not a valid line: Jun  5 04:02:16 vd 
-gcm_input WARNING: Not a valid line: 
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist

diff --git a/test/t0004.errors b/test/t0004.errors
index 9511562..2e62390 100644 (file)
--- a/test/t0004.errors
+++ b/test/t0004.errors
@@ -1,11 +1,11 @@
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 Can not determine the hostname where the message came from.
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist

diff --git a/test/t0005.errors b/test/t0005.errors
index 89867e7..8648c01 100644 (file)
--- a/test/t0005.errors
+++ b/test/t0005.errors
@@ -1,11 +1,11 @@
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist

diff --git a/test/t0008.errors b/test/t0008.errors
index 3d1b7c5..654f55d 100644 (file)
--- a/test/t0008.errors
+++ b/test/t0008.errors
@@ -10,14 +10,14 @@ psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not ex
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist
 psql:src/database/destroy.sql:96: ERROR:  table "user_gnucomo" does not exist
-psql:src/database/create.sql:555: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
-psql:src/database/create.sql:591: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
-psql:src/database/create.sql:611: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
-psql:src/database/create.sql:625: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
-psql:src/database/create.sql:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
-psql:src/database/create.sql:794: ERROR:  CREATE GROUP: group name "view" already exists
-psql:src/database/create.sql:795: ERROR:  CREATE GROUP: group name "ops" already exists
-psql:src/database/create.sql:796: ERROR:  CREATE GROUP: group name "admin" already exists
+psql:src/database/create.sql:559: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'object_statistics_pkey' for table 'object_statistics'
+psql:src/database/create.sql:595: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_pkey' for table 'parameter'
+psql:src/database/create.sql:615: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_class_pkey' for table 'parameter_class'
+psql:src/database/create.sql:629: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'parameter_notification_pkey' for table 'parameter_notification'
+psql:src/database/create.sql:660: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'property_pkey' for table 'property'
+psql:src/database/create.sql:798: ERROR:  CREATE GROUP: group name "view" already exists
+psql:src/database/create.sql:799: ERROR:  CREATE GROUP: group name "ops" already exists
+psql:src/database/create.sql:800: ERROR:  CREATE GROUP: group name "admin" already exists
 psql:src/database/destroy.sql:67: ERROR:  table "object_system_user" does not exist
 psql:src/database/destroy.sql:92: ERROR:  sequence "unprocessed_l_unprocessedid_seq" does not exist
 psql:src/database/destroy.sql:94: ERROR:  table "unprocessed_log" does not exist