Mercurial > hg > webserver / file diff

--- a/doc/development/postgresql_vfs_testdata.sql	Tue Feb 01 20:07:42 2022 +0100
+++ b/doc/development/postgresql_vfs_testdata.sql	Thu Feb 03 17:26:08 2022 +0100
@@ -6,11 +6,11 @@
     insert into Resource (nodename, iscollection) values ('', true);
     res_id := lastval();
    
-    insert into Resource(parent_id,  nodename) values
-    (res_id, 'file1.txt'),
-    (res_id, 'file2.txt'),
-    (res_id, 'file3.txt'),
-    (res_id, 'file4.txt');
+    insert into Resource(parent_id,  nodename, resoid) values
+    (res_id, 'file1.txt', (select lo_create(0))),
+    (res_id, 'file2.txt', (select lo_create(0))),
+    (res_id, 'file3.txt', (select lo_create(0))),
+    (res_id, 'file4.txt', (select lo_create(0)));
     
     insert into Resource(parent_id,  nodename, iscollection) values
     (res_id, 'dir1', true);
@@ -20,10 +20,10 @@
     (res_id, 'dir2', true);
     res_id := lastval();
     
-    insert into Resource(parent_id,  nodename) values
-    (res_id, 'd1file1.txt'),
-    (res_id, 'd2file1.txt'),
-    (res_id, 'd2file2.txt');
+    insert into Resource(parent_id,  nodename, resoid) values
+    (res_id, 'd1file1.txt', (select lo_create(0))),
+    (res_id, 'd2file1.txt', (select lo_create(0))),
+    (res_id, 'd2file2.txt', (select lo_create(0)));
 
 end $$;