functions/SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql

Functions

Source

001: \echo Start functions/SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql
002: 
003: /** Set logging level to INFO.
004:  *
005:  *  @function SET_GENERAL_LOGGING_LEVEL_2_INFO
006:  *  @return void
007:  *  @version $Id: SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql 7 2018-06-12 04:15:42Z thiemo $
008:  *  @todo Once PostgreSQL supports packages, integrate this function into one.
009:  *        For the time being, it should get installed within a schema on its
010:  *        own and no execution grants should be given on it.
011:  *  @todo Once HyperSQL supports a license tag, convert the corresponding
012:  *        info tag into one.
013:  *  @copyright Thiemo Kellner, 2018 -
014:  *  @info License LGPLv3
015:  *  @webpage https://www.sourceforge.net/projects/pglogger
016:  */
017: create or replace function SET_GENERAL_LOGGING_LEVEL_2_INFO()
018:   returns void
019:   language plpgsql
020:   security definer
021:   stable
022:   -- Include the hosting schema into search_path so that dblink
023:   -- can find the pglogger objects. There is no need to access
024:   -- objects in other schematas not covered with public.
025:   set search_path = :SCHEMA_NAME, public
026:   as
027: $body$
028:     begin
029:         perform SET_GENERAL_LOGGING_LEVEL(I_LEVEL => 'INFO');
030:     end;
031: $body$;
032: 
033: comment on function SET_GENERAL_LOGGING_LEVEL_2_INFO() is 'Set logging level to INFO.
034: $Header: svn+ssh://thiemo@svn.code.sf.net/p/pglogger/code/functions/SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql 7 2018-06-12 04:15:42Z thiemo $';
035: 
036: commit; -- unlike Oracle not all ddl commit implicitly
037: 
038: \echo End functions/SET_GENERAL_LOGGING_LEVEL_2_INFO.pg_sql