full_install.pg_sql

Source

001: \echo Start full_install.pg_sql
002: 
003: \set ON_ERROR_STOP true
004: \set AUTOCOMMIT false
005: \set TESTING true
006: \echo Testing :TESTING
007: 
008: \if :TESTING
009:     \ir schemata/logger_schema.pg_sql
010: \endif
011: \ir tables/LEVEL.pg_sql
012: \ir tables/LOG.pg_sql
013: \ir tables/PROPERTY.pg_sql
014: \ir views/LOG_SORTED.pg_sql
015: \ir functions/SET_GENERAL_LOGGING_LEVEL.pg_sql
016: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_DEBUG.pg_sql
017: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_LOG.pg_sql
018: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql
019: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_NOTICE.pg_sql
020: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_WARNING.pg_sql
021: \ir functions/SET_GENERAL_LOGGING_LEVEL_2_EXCEPTION.pg_sql
022: \ir functions/GET_PROPERTY_VALUE_BOOLEAN.pg_sql
023: \ir functions/GET_PROPERTY_VALUE_STRING.pg_sql
024: \ir functions/GET_PROPERTY_VALUE_NUMBER.pg_sql
025: \ir functions/GET_PROPERTY_VALUE_INTEGER.pg_sql
026: \ir functions/GET_PROPERTY_VALUE_DATE.pg_sql
027: \ir functions/GET_PROPERTY_VALUE_TIME.pg_sql
028: \ir functions/GET_PROPERTY_VALUE_TIMESTAMP.pg_sql
029: \ir functions/GET_PROPERTY_VALUE_INTERVAL.pg_sql
030: \ir functions/GET_CALLER_FUNCTION.pg_sql
031: \ir functions/GET_LOGGING_LEVEL.pg_sql
032: \ir functions/IS_LOGGING_TO_TABLE.pg_sql
033: \ir functions/IS_LOGGING_TO_STANDARD.pg_sql
034: \ir functions/IS_ASYNCH_TAB_LOGGING.pg_sql
035: \ir functions/WRITE_MESSAGE_TO_TABLE.pg_sql
036: \ir functions/WRITE_MESSAGE.pg_sql
037: \ir functions/DEBUG.pg_sql
038: \ir functions/LOG.pg_sql
039: \ir functions/INFO.pg_sql
040: \ir functions/NOTICE.pg_sql
041: \ir functions/WARNING.pg_sql
042: \ir functions/EXCEPTION.pg_sql
043: \ir grants/grants.pg_sql
044: 
045: \if :TESTING
046:    \ir testing/test.pg_sql
047: \endif
048: 
049: \echo TODO: document that the extension "dblink" has to be installed: "create extension dblink;"
050: \echo TODO: Document that a user owning an equally named schema has to be set up and that the PostgreSQL objects have to be installed therein.
051: \echo TODO: Beautify code and commit
052: \echo TODO: Generate documentation and commit
053: 
054: \echo End full_install.pg_sql
055: 
056: /*
057: 1 update child to new parent version
058: ? Surrogate business key
059: Propagate parent version to children obviating 1
060: Propagate child version to parents
061: */