Table of Contents
database_name | admin_role | postgres_version
---------------+------------+-----------------------------------------------------------------------------------------------------------
veridotest | veridon | PostgreSQL 18.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-14), 64-bit
(1 row)
rolname | rolsuper | rolcreaterole | rolcreatedb | rolcanlogin ---------+----------+---------------+-------------+------------- veridon | f | f | f | t (1 row)
can_create_schema
t (1 row)
application_schema | can_use | can_create --------------------+---------+------------ audit | t | t cmdb | t | t iam | t | t workflow | t | t (4 rows)
BEGIN psql:test.sql:38: ERROR: permission denied to create role DETAIL: Only roles with the CREATEROLE attribute may create roles. psql:test.sql:39: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:40: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:43: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:48: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:50: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:51: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:53: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:65: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:67: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:69: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:71: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:72: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:77: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:79: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:82: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:85: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:88: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:91: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:92: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:95: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:98: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql💯 ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:168: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:test.sql:170: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK sh-4.4$