postgis -  functions -  public.unlockrows

Description

Function properties

Usage

result = public.unlockrows();

Code

CREATE FUNCTION unlockrows(text) RETURNS integer
    AS $_$
DECLARE
    ret int;
BEGIN

    IF NOT LongTransactionsEnabled() THEN
        RAISE EXCEPTION 'Long transaction support disabled, use EnableLongTransaction() to enable.';
    END IF;

    EXECUTE 'DELETE FROM authorization_table where authid = ' ||
        quote_literal($1);

    GET DIAGNOSTICS ret = ROW_COUNT;

    RETURN ret;
END;
$_$
    LANGUAGE plpgsql STRICT;