gis Database

Parameters

Name	Type	Mode
temporary_table	text	IN
table_type	text	IN

Definition

DECLARE
    sqltemplate text;
BEGIN
    -- Drop table if exists
    EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(temporary_table);
    -- Create temporary table
    IF table_type = 'audit' THEN
        EXECUTE 'CREATE TEMP TABLE ' || quote_ident(temporary_table) || ' (
            tid                       serial,
            event_id                  bigint,
            action_tstamp_tx          timestamp with time zone,
            action_tstamp_epoch       numeric,
            ident                     text,
            action_type               text,
            origine                   text,
            action                    text,
            updated_field             text,
            uid                       uuid,
            original_action_tstamp_tx numeric
        )
        --ON COMMIT DROP
        ';
    END IF;
    IF table_type = 'conflict' THEN
        EXECUTE 'CREATE TEMP TABLE ' || quote_ident(temporary_table) || ' (
            tid                     serial                   ,
            conflict_time           timestamp with time zone ,
            object_table            text                     ,
            object_uid              uuid                     ,
            central_tid             integer                  ,
            clone_tid               integer                  ,
            central_event_id        integer                  ,
            central_event_timestamp timestamp with time zone ,
            central_sql             text                     ,
            clone_sql               text                     ,
            rejected                text                     ,
            rule_applied            text
        )
        --ON COMMIT DROP
        ';
    END IF;

RETURN True;
END;

create_temporary_table

Description

Parameters

Definition