comparison: doc/development/postgresql_vfs_testdata.sql
doc/development/postgresql_vfs_testdata.sql
- branch
- webdav
- changeset 283
- 25e5b771677d
- parent 281
- e9dc53661df4
equal
deleted
inserted
replaced
| 282:cfb588e27198 | 283:25e5b771677d |
|---|---|
| 4 res_id int; | 4 res_id int; |
| 5 begin | 5 begin |
| 6 insert into Resource (nodename, iscollection) values ('', true); | 6 insert into Resource (nodename, iscollection) values ('', true); |
| 7 res_id := lastval(); | 7 res_id := lastval(); |
| 8 | 8 |
| 9 insert into Resource(parent_id, nodename) values | 9 insert into Resource(parent_id, nodename, resoid) values |
| 10 (res_id, 'file1.txt'), | 10 (res_id, 'file1.txt', (select lo_create(0))), |
| 11 (res_id, 'file2.txt'), | 11 (res_id, 'file2.txt', (select lo_create(0))), |
| 12 (res_id, 'file3.txt'), | 12 (res_id, 'file3.txt', (select lo_create(0))), |
| 13 (res_id, 'file4.txt'); | 13 (res_id, 'file4.txt', (select lo_create(0))); |
| 14 | 14 |
| 15 insert into Resource(parent_id, nodename, iscollection) values | 15 insert into Resource(parent_id, nodename, iscollection) values |
| 16 (res_id, 'dir1', true); | 16 (res_id, 'dir1', true); |
| 17 res_id := lastval(); | 17 res_id := lastval(); |
| 18 | 18 |
| 19 insert into Resource(parent_id, nodename, iscollection) values | 19 insert into Resource(parent_id, nodename, iscollection) values |
| 20 (res_id, 'dir2', true); | 20 (res_id, 'dir2', true); |
| 21 res_id := lastval(); | 21 res_id := lastval(); |
| 22 | 22 |
| 23 insert into Resource(parent_id, nodename) values | 23 insert into Resource(parent_id, nodename, resoid) values |
| 24 (res_id, 'd1file1.txt'), | 24 (res_id, 'd1file1.txt', (select lo_create(0))), |
| 25 (res_id, 'd2file1.txt'), | 25 (res_id, 'd2file1.txt', (select lo_create(0))), |
| 26 (res_id, 'd2file2.txt'); | 26 (res_id, 'd2file2.txt', (select lo_create(0))); |
| 27 | 27 |
| 28 end $$; | 28 end $$; |
| 29 | 29 |
