diff -r cfb588e27198 -r 25e5b771677d doc/development/postgresql_vfs_testdata.sql --- 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 $$;