diff -r 4090fc1b1c52 -r 09676b559091 src/server/plugins/postgresql/pgtest.c
--- a/src/server/plugins/postgresql/pgtest.c	Tue Apr 26 15:19:12 2022 +0200
+++ b/src/server/plugins/postgresql/pgtest.c	Tue Apr 26 18:21:25 2022 +0200
@@ -512,7 +512,7 @@
     const char* params[1] = { idstr };
     PGresult *result = PQexecParams(
             test_connection,
-            "insert into Property(resource_id, xmlns, pname, pvalue) values ($1, 'http://example.com/', 'test', 'testvalue');",
+            "insert into Property(resource_id, prefix, xmlns, pname, pvalue) values ($1, 'x', 'http://example.com/', 'test', 'testvalue');",
             1,     // number of parameters
             NULL,
             params, // parameter value
@@ -525,7 +525,7 @@
     
     result = PQexecParams(
             test_connection,
-            "insert into Property(resource_id, xmlns, pname, pvalue) values ($1, 'http://example.com/', 'prop2', 'value2');",
+            "insert into Property(resource_id, prefix, xmlns, pname, pvalue) values ($1, 'x', 'http://example.com/', 'prop2', 'value2');",
             1,     // number of parameters
             NULL,
             params, // parameter value
@@ -540,7 +540,7 @@
     snprintf(idstr, 32, "%" PRId64, res2_id);
     result = PQexecParams(
             test_connection,
-            "insert into Property(resource_id, xmlns, pname, pvalue) values ($1, 'http://example.com/', 'test', 'res2test');",
+            "insert into Property(resource_id, prefix, xmlns, pname, pvalue) values ($1, 'x', 'http://example.com/', 'test', 'res2test');",
             1,     // number of parameters
             NULL,
             params, // parameter value