src/server/plugins/postgresql/test/postgresql_vfs_testdata.sql

Sat, 14 May 2022 12:51:05 +0200

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Sat, 14 May 2022 12:51:05 +0200
branch
webdav
changeset 358
f3b490a2150c
parent 288
7dd45173f68a
permissions
-rw-r--r--

start threadpool in threadpool_run() if no threads are created yet


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 $$;

mercurial