--
-- Tests for start and end session hooks
--
-- Only activity from role regress_sess_hook_usr2 is logged.
CREATE ROLE regress_sess_hook_usr1 SUPERUSER LOGIN;
CREATE ROLE regress_sess_hook_usr2 SUPERUSER LOGIN;
\set prevdb :DBNAME
\set prevusr :USER
CREATE TABLE session_hook_log(id SERIAL, dbname TEXT, username TEXT, hook_at TEXT);
SELECT * FROM session_hook_log ORDER BY id;
 id | dbname | username | hook_at 
----+--------+----------+---------
(0 rows)

\c :prevdb regress_sess_hook_usr1
SELECT * FROM session_hook_log ORDER BY id;
 id | dbname | username | hook_at 
----+--------+----------+---------
(0 rows)

\c :prevdb regress_sess_hook_usr2
SELECT * FROM session_hook_log ORDER BY id;
 id |       dbname       |        username        | hook_at 
----+--------------------+------------------------+---------
  1 | contrib_regression | regress_sess_hook_usr2 | START
(1 row)

\c :prevdb :prevusr
SELECT * FROM session_hook_log ORDER BY id;
 id |       dbname       |        username        | hook_at 
----+--------------------+------------------------+---------
  1 | contrib_regression | regress_sess_hook_usr2 | START
  2 | contrib_regression | regress_sess_hook_usr2 | END
(2 rows)

DROP ROLE regress_sess_hook_usr1;
DROP ROLE regress_sess_hook_usr2;