   END T_REF_ID_ZERO @
 
 /**
+ * Removes the spaces around a pattern.
+ */
+CREATE OR REPLACE TRIGGER CONF_APPENDER_PATTERN
+  BEFORE INSERT OR UPDATE ON LOGDATA.CONF_APPENDERS
+  REFERENCING NEW AS N
+  FOR EACH ROW
+ T_CONF_APPENDER_PATTERN: BEGIN
+  SET N.PATTERN = TRIM(N.PATTERN);
+ END T_CONF_APPENDER_PATTERN @
+
+/**
  * Checks that the appender_id for an appender is greater or equal to zero.
  */
 CREATE OR REPLACE TRIGGER APPENDER_GREATER_EQUAL_ZERO

--#SET TERMINATOR @
SET CURRENT SCHEMA LOGGER_1 @

/**
 * This trigger checks the insertion in the conf_logger table to see

  END T_APPENDER_ID_ZERO @

/**
 * Generates a unique date for the logs.
 */
CREATE OR REPLACE TRIGGER UNIQUE_DATE
  BEFORE INSERT ON LOGDATA.LOGS
  REFERENCING NEW AS N
  FOR EACH ROW
  SET N.DATE = GENERATE_UNIQUE()@