1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
CREATE EXTENSION multicorn;
CREATE server multicorn_srv foreign data wrapper multicorn options (
wrapper 'multicorn.testfdw.TestForeignDataWrapper'
);
CREATE user mapping FOR current_user server multicorn_srv options (usermapping 'test');
CREATE foreign table testmulticorn (
test1 character varying(20),
test2 character varying
) server multicorn_srv options (
option1 'option1'
);
-- Test "normal" usage
select * from testmulticorn;
ALTER foreign table testmulticorn drop column test1;
select * from testmulticorn;
ALTER foreign table testmulticorn add column test1 varchar;
select * from testmulticorn;
ALTER foreign table testmulticorn add column test3 varchar;
select * from testmulticorn;
ALTER foreign table testmulticorn options (SET option1 'option1_update');
select * from testmulticorn;
ALTER foreign table testmulticorn options (ADD option2 'option2');
select * from testmulticorn;
ALTER foreign table testmulticorn options (DROP option2);
select * from testmulticorn;
-- Test dropping column when returning sequences (issue #15)
ALTER foreign table testmulticorn options (ADD test_type 'sequence');
select * from testmulticorn;
ALTER foreign table testmulticorn drop test3;
select * from testmulticorn;
ALTER foreign table testmulticorn alter test1 type varchar(30);
select * from testmulticorn limit 1;
ALTER foreign table testmulticorn alter test1 type text;
select * from testmulticorn limit 1;
ALTER foreign table testmulticorn rename test1 to testnew;
select * from testmulticorn limit 1;
DROP USER MAPPING FOR current_user SERVER multicorn_srv;
DROP EXTENSION multicorn cascade;
|
