feat: issue2550852 - support using a specified PostgreSQL db schema Finally after 7 years this is closed. roundup/backends/back_postgresql.py: Support use of schema when specified in RDBMS_NAME. Stuart McGraws code is finally merged 8-). test/test_postgresql.py, test/conftest.py: Run all postgresql tests in the schema db as well. Also make sure that db_nuke raises an error when trying to delete the schema test database. Conftest defines pg_schema mark that can be used to exclude schema tests with pytest -m "not pg_schema". roundup/configuration.py: change doc on RDBMS_NAME to include db.schema form. .travis.yml, .github/workflows/ci-test.yml: create schema test db; add user for testing with schema; grant new user create privs for schema. doc/installation.txt: Reference to roundup-admin init deleting schema added. doc/mysql.txt doc/postgresql.txt: New documentation on psql/mysql commands to set up a production db. doc/upgrading.txt: mention schema support, also document service setting for selecting connection from pg_service.conf. doc/reference.txt: update config.ini documentation for RDBMS_NAME.

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/test/conftest.py	Wed Dec 27 22:52:14 2023 -0500
@@ -0,0 +1,14 @@
+# simple way to see if there are order dependencies in tests
+# can use if pytest-random-order --random-order mode isn't
+# usable (e.g. python2).
+
+#def pytest_collection_modifyitems(items): 
+#    items.reverse()
+
+# Add a marker for pg_schema tests.
+# They duplicate the postgresql tests exactly but uses a named
+# schema rather than the default 'public' schema.
+def pytest_configure(config):
+    config.addinivalue_line(
+        "markers", "pg_schema: tests using schema for postgres"
+    )