functions/IS_ASYNCH_TAB_LOGGING.pg_sql

Functions

Source

001: \echo Start functions/IS_ASYNCH_TAB_LOGGING.pg_sql
002: 
003: /** Returns whether logging to table is to be done asynchronously or not.
004:  *
005:  *  @function IS_ASYNCH_TAB_LOGGING
006:  *  @return boolean Value of the property TO_TABLE.
007:  *  @version $Id: IS_ASYNCH_TAB_LOGGING.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 IS_ASYNCH_TAB_LOGGING()
018:   returns boolean
019:   language plpgsql
020:   stable
021:   -- Include the hosting schema into search_path so that dblink
022:   -- can find the pglogger objects. There is no need to access
023:   -- objects in other schematas not covered with public.
024:   set search_path = :SCHEMA_NAME, public
025:   as
026: $body$
027:     begin
028:         return GET_PROPERTY_VALUE_BOOLEAN('ASYNCH_TABLE_LOG');
029:     end;
030: $body$;
031: 
032: comment on function IS_ASYNCH_TAB_LOGGING() is 'Returns whether logging to table is to be done asynchronously or not.
033: $Header: svn+ssh://thiemo@svn.code.sf.net/p/pglogger/code/functions/IS_ASYNCH_TAB_LOGGING.pg_sql 7 2018-06-12 04:15:42Z thiemo $';
034: 
035: commit; -- unlike Oracle not all ddl commit implicitly
036: 
037: \echo End functions/IS_ASYNCH_TAB_LOGGING.pg_sql