CONTEXT: SQL statement "SELECT pgv_select('vars3', 'r3')"

PL/pgSQL function inline_code_block line 3 at PERFORM

-- Check that the hash table was cleaned up after rollback

SET client_min_messages to 'ERROR';

SELECT pgv_select('vars3', 'r1', 1);

pgv_select

------------

(1 row)

SELECT pgv_select('vars3', 'r1') LIMIT 2; -- warning

WARNING: leaked hash_seq_search scan for hash table 0x561738129110

pgv_select

------------

(,strNULL)

CLOSE r1_cur;

COMMIT; -- warning

-- Clean memory after unsuccessful creation of a variable

SELECT pgv_insert('vars4', 'r1', row('str1', 'str1')); -- fail

ERROR: could not identify a hash function for type unknown

PERFORM pgv_select('vars3','r3');

END$$;

SET client_min_messages to'ERROR';

SELECT pgv_select('vars3','r1',1);

SELECT pgv_select('vars3','r1')LIMIT2;-- warning

SELECT pgv_select('vars3','r1')LIMIT2 OFFSET2;

FETCH1in r1_cur;

CLOSE r1_cur;

COMMIT;-- warning

RESET client_min_messages;

SELECT pgv_insert('vars4','r1', row('str1','str1'));-- fail