tables/LEVEL.pg_sql

Tables

Source

001: \echo Start tables/LEVEL.pg_sql
002: 
003: drop table if exists LEVEL;
004: 
005: /** Contains the log levels for various scopes.
006:  *
007:  *  @table LEVEL
008:  *  @col uuid ID
009:  *  @col text SCOPE
010:  *  @col text LEVEL
011:  *  @version $Id: LEVEL.pg_sql 20 2018-06-15 20:24:56Z thiemo $
012:  *  @todo Once HyperSQL supports a license tag, convert the corresponding
013:  *        info tag into one.
014:  *  @copyright Thiemo Kellner, 2018 -
015:  *  @info License LGPLv3
016:  *  @webpage https://www.sourceforge.net/projects/pglogger
017:  */
018: create table LEVEL(
019:     ID uuid not null default uuid_generate_v1(),
020:     SCOPE text not null,
021:     LEVEL text not null
022: );
023: 
024: 
025: alter table LEVEL add primary key (ID);
026: 
027: alter table LEVEL add unique (SCOPE);
028: 
029: alter table LEVEL
030:   add constraint LEVEL_CK check (
031:       LEVEL in (
032:           'DEBUG',
033:           'LOG',
034:           'INFO',
035:           'NOTICE',
036:           'WARNING',
037:           'EXCEPTION'
038:       )
039:   );
040: 
041: 
042: comment on column LEVEL.ID is
043:   'Primary key';
044: comment on column LEVEL.LEVEL is
045:   'Logging granularity with values as defined in check constraint LEVEL_CK. These are meant to correspond to the level the PL/pgSQL raise statement defines.';
046: comment on column LEVEL.SCOPE is
047:   'Funtion name for which this level is active. If the log level of anonymous/inline code blocks shall be overridden, use scope "inline_code_block".';
048: 
049: comment on table LEVEL is 'Contains the log levels for various scopes.
050: $Header: svn+ssh://thiemo@svn.code.sf.net/p/pglogger/code/tables/LEVEL.pg_sql 20 2018-06-15 20:24:56Z thiemo $';
051: 
052: 
053: commit; -- unlike Oracle not all ddl commit implicitly
054: 
055: \echo End tables/LEVEL.pg_sql