comparison: src/server/plugins/postgresql/test/postgresql_vfs_testdata.sql
src/server/plugins/postgresql/test/postgresql_vfs_testdata.sql
- changeset 385
- a1f4cb076d2f
- parent 288
- 7dd45173f68a
equal
deleted
inserted
replaced
| 210:21274e5950af | 385:a1f4cb076d2f |
|---|---|
| 1 | |
| 2 do $$ | |
| 3 declare | |
| 4 res_id int; | |
| 5 begin | |
| 6 insert into Resource (nodename, iscollection) values ('', true); | |
| 7 res_id := lastval(); | |
| 8 | |
| 9 insert into Resource(parent_id, nodename, resoid) values | |
| 10 (res_id, 'file1.txt', (select lo_create(0))), | |
| 11 (res_id, 'file2.txt', (select lo_create(0))), | |
| 12 (res_id, 'file3.txt', (select lo_create(0))), | |
| 13 (res_id, 'file4.txt', (select lo_create(0))); | |
| 14 | |
| 15 insert into Resource(parent_id, nodename, iscollection) values | |
| 16 (res_id, 'dir1', true); | |
| 17 res_id := lastval(); | |
| 18 | |
| 19 insert into Resource(parent_id, nodename, iscollection) values | |
| 20 (res_id, 'dir2', true); | |
| 21 res_id := lastval(); | |
| 22 | |
| 23 insert into Resource(parent_id, nodename, resoid) values | |
| 24 (res_id, 'd1file1.txt', (select lo_create(0))), | |
| 25 (res_id, 'd2file1.txt', (select lo_create(0))), | |
| 26 (res_id, 'd2file2.txt', (select lo_create(0))); | |
| 27 | |
| 28 end $$; | |
| 29 |
