Fri, 04 Feb 2022 18:41:40 +0100
set error status code directly in vfs_* calls
do $$ declare res_id int; begin insert into Resource (nodename, iscollection) values ('', true); res_id := lastval(); 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); res_id := lastval(); insert into Resource(parent_id, nodename, iscollection) values (res_id, 'dir2', true); res_id := lastval(); 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 $$;