granicus.if.org Git - postgresql/blob - src/test/modules/test_session_hooks/expected/test_session_hooks.out

   1 CREATE ROLE regress_sess_hook_usr1 SUPERUSER LOGIN;
   2 CREATE ROLE regress_sess_hook_usr2 SUPERUSER LOGIN;
   3 \set prevdb :DBNAME
   4 \set prevusr :USER
   5 CREATE TABLE session_hook_log(id SERIAL, dbname TEXT, username TEXT, hook_at TEXT);
   6 SELECT * FROM session_hook_log ORDER BY id;
   7  id | dbname | username | hook_at
   8 ----+--------+----------+---------
   9 (0 rows)
  10
  11 \c :prevdb regress_sess_hook_usr1
  12 SELECT * FROM session_hook_log ORDER BY id;
  13  id | dbname | username | hook_at
  14 ----+--------+----------+---------
  15 (0 rows)
  16
  17 \c :prevdb regress_sess_hook_usr2
  18 SELECT * FROM session_hook_log ORDER BY id;
  19  id |       dbname       |        username        | hook_at
  20 ----+--------------------+------------------------+---------
  21   1 | contrib_regression | regress_sess_hook_usr2 | START
  22 (1 row)
  23
  24 \c :prevdb :prevusr
  25 SELECT * FROM session_hook_log ORDER BY id;
  26  id |       dbname       |        username        | hook_at
  27 ----+--------------------+------------------------+---------
  28   1 | contrib_regression | regress_sess_hook_usr2 | START
  29   2 | contrib_regression | regress_sess_hook_usr2 | END
  30 (2 rows)
  31