regress/sql/foreign_data.sql

104 CREATE SERVER s1 FOREIGN DATA WRAPPER foo;
105 COMMENT ON SERVER s1 IS 'foreign server';
106 CREATE USER MAPPING FOR current_user SERVER s1;
120 CREATE SERVER s1 FOREIGN DATA WRAPPER foo;                  -- ERROR
122 CREATE SERVER s1 FOREIGN DATA WRAPPER foo;
123 CREATE SERVER s1 FOREIGN DATA WRAPPER foo;                  -- ERROR
124 CREATE SERVER s2 FOREIGN DATA WRAPPER foo OPTIONS (host 'a', dbname 'b');
125 CREATE SERVER s3 TYPE 'oracle' FOREIGN DATA WRAPPER foo;
126 CREATE SERVER s4 TYPE 'oracle' FOREIGN DATA WRAPPER foo OPTIONS (host 'a', dbname 'b');
127 CREATE SERVER s5 VERSION '15.0' FOREIGN DATA WRAPPER foo;
128 CREATE SERVER s6 VERSION '16.0' FOREIGN DATA WRAPPER foo OPTIONS (host 'a', dbname 'b');
129 CREATE SERVER s7 TYPE 'oracle' VERSION '17.0' FOREIGN DATA WRAPPER foo OPTIONS (host 'a', dbname 'b…
130 CREATE SERVER s8 FOREIGN DATA WRAPPER postgresql OPTIONS (foo '1'); -- ERROR
131 CREATE SERVER s8 FOREIGN DATA WRAPPER postgresql OPTIONS (host 'localhost', dbname 's8db');
134 CREATE SERVER t1 FOREIGN DATA WRAPPER foo;                 -- ERROR: no usage on FDW
138 CREATE SERVER t1 FOREIGN DATA WRAPPER foo;
145 CREATE SERVER t2 FOREIGN DATA WRAPPER foo;                 -- ERROR
149 CREATE SERVER t2 FOREIGN DATA WRAPPER foo;
155 ALTER SERVER s0;                                            -- ERROR
156 ALTER SERVER s0 OPTIONS (a '1');                            -- ERROR
157 ALTER SERVER s1 VERSION '1.0' OPTIONS (servername 's1');
158 ALTER SERVER s2 VERSION '1.1';
159 ALTER SERVER s3 OPTIONS ("tns name" 'orcl', port '1521');
160 GRANT USAGE ON FOREIGN SERVER s1 TO regress_test_role;
161 GRANT USAGE ON FOREIGN SERVER s6 TO regress_test_role2 WITH GRANT OPTION;
164 ALTER SERVER s1 VERSION '1.1';                              -- ERROR
165 ALTER SERVER s1 OWNER TO regress_test_role;                 -- ERROR
167 ALTER SERVER s1 OWNER TO regress_test_role;
170 ALTER SERVER s1 VERSION '1.1';
171 ALTER SERVER s1 OWNER TO regress_test_role2;                -- ERROR
173 ALTER SERVER s8 OPTIONS (foo '1');                          -- ERROR option validation
174 ALTER SERVER s8 OPTIONS (connect_timeout '30', SET dbname 'db1', DROP host);
176 ALTER SERVER s1 OWNER TO regress_test_indirect;             -- ERROR
180 ALTER SERVER s1 OWNER TO regress_test_indirect;
184 ALTER SERVER s1 OWNER TO regress_test_indirect;
189 ALTER SERVER s8 RENAME to s8new;
191 ALTER SERVER s8new RENAME to s8;
194 DROP SERVER nonexistent;                                    -- ERROR
195 DROP SERVER IF EXISTS nonexistent;
198 DROP SERVER s2;                                             -- ERROR
199 DROP SERVER s1;
202 ALTER SERVER s2 OWNER TO regress_test_role;
204 DROP SERVER s2;
207 CREATE USER MAPPING FOR current_user SERVER s3;
209 DROP SERVER s3;                                             -- ERROR
210 DROP SERVER s3 CASCADE;
215 CREATE USER MAPPING FOR regress_test_missing_role SERVER s1;  -- ERROR
216 CREATE USER MAPPING FOR current_user SERVER s1;             -- ERROR
217 CREATE USER MAPPING FOR current_user SERVER s4;
218 CREATE USER MAPPING FOR user SERVER s4;                     -- ERROR duplicate
219 CREATE USER MAPPING FOR public SERVER s4 OPTIONS ("this mapping" 'is public');
220 CREATE USER MAPPING FOR user SERVER s8 OPTIONS (username 'test', password 'secret');    -- ERROR
221 CREATE USER MAPPING FOR user SERVER s8 OPTIONS (user 'test', password 'secret');
222 ALTER SERVER s5 OWNER TO regress_test_role;
223 ALTER SERVER s6 OWNER TO regress_test_indirect;
225 CREATE USER MAPPING FOR current_user SERVER s5;
226 CREATE USER MAPPING FOR current_user SERVER s6 OPTIONS (username 'test');
227 CREATE USER MAPPING FOR current_user SERVER s7;             -- ERROR
228 CREATE USER MAPPING FOR public SERVER s8;                   -- ERROR
231 ALTER SERVER t1 OWNER TO regress_test_indirect;
233 CREATE USER MAPPING FOR current_user SERVER t1 OPTIONS (username 'bob', password 'boo');
234 CREATE USER MAPPING FOR public SERVER t1;
239 ALTER USER MAPPING FOR regress_test_missing_role SERVER s4 OPTIONS (gotcha 'true'); -- ERROR
240 ALTER USER MAPPING FOR user SERVER ss4 OPTIONS (gotcha 'true'); -- ERROR
241 ALTER USER MAPPING FOR public SERVER s5 OPTIONS (gotcha 'true');            -- ERROR
242 ALTER USER MAPPING FOR current_user SERVER s8 OPTIONS (username 'test');    -- ERROR
243 ALTER USER MAPPING FOR current_user SERVER s8 OPTIONS (DROP user, SET password 'public');
245 ALTER USER MAPPING FOR current_user SERVER s5 OPTIONS (ADD modified '1');
246 ALTER USER MAPPING FOR public SERVER s4 OPTIONS (ADD modified '1'); -- ERROR
247 ALTER USER MAPPING FOR public SERVER t1 OPTIONS (ADD modified '1');
252 DROP USER MAPPING FOR regress_test_missing_role SERVER s4;  -- ERROR
253 DROP USER MAPPING FOR user SERVER ss4;
254 DROP USER MAPPING FOR public SERVER s7;                     -- ERROR
255 DROP USER MAPPING IF EXISTS FOR regress_test_missing_role SERVER s4;
256 DROP USER MAPPING IF EXISTS FOR user SERVER ss4;
257 DROP USER MAPPING IF EXISTS FOR public SERVER s7;
258 CREATE USER MAPPING FOR public SERVER s8;
260 DROP USER MAPPING FOR public SERVER s8;                     -- ERROR
262 DROP SERVER s7;
267 CREATE SERVER s0 FOREIGN DATA WRAPPER dummy;
269 CREATE FOREIGN TABLE ft1 () SERVER no_server;                   -- ERROR
270 CREATE FOREIGN TABLE ft1 () SERVER s0 WITH OIDS;                -- ERROR
275 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value'); -- ERROR
281 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value'); -- ERROR
288 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value'); -- ERROR
294 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value');
397 DROP USER MAPPING FOR current_user SERVER t1;
430 GRANT USAGE ON FOREIGN SERVER s8 TO regress_test_role;
432 REVOKE USAGE ON FOREIGN SERVER s8 FROM regress_test_role;
434 GRANT USAGE ON FOREIGN SERVER s4 TO regress_test_role;
435 DROP USER MAPPING FOR public SERVER s4;
436 ALTER SERVER s6 OPTIONS (DROP host, DROP dbname);
437 ALTER USER MAPPING FOR regress_test_role SERVER s6 OPTIONS (DROP username);
447 CREATE SERVER s9 FOREIGN DATA WRAPPER foo;                      -- ERROR
448 ALTER SERVER s4 VERSION '0.5';                                  -- ERROR
449 ALTER SERVER s4 OWNER TO regress_unprivileged_role;             -- ERROR
450 DROP SERVER s4;                                                 -- ERROR
451 GRANT USAGE ON FOREIGN SERVER s4 TO regress_test_role;          -- ERROR
452 CREATE USER MAPPING FOR public SERVER s4;                       -- ERROR
453 ALTER USER MAPPING FOR regress_test_role SERVER s6 OPTIONS (gotcha 'true'); -- ERROR
454 DROP USER MAPPING FOR regress_test_role SERVER s6;              -- ERROR
465 CREATE SERVER s9 FOREIGN DATA WRAPPER postgresql;
466 ALTER SERVER s6 VERSION '0.5';                                  -- ERROR
467 DROP SERVER s6;                                                 -- ERROR
468 GRANT USAGE ON FOREIGN SERVER s6 TO regress_test_role;          -- ERROR
469 GRANT USAGE ON FOREIGN SERVER s9 TO regress_test_role;
470 CREATE USER MAPPING FOR public SERVER s6;                       -- ERROR
471 CREATE USER MAPPING FOR public SERVER s9;
472 ALTER USER MAPPING FOR regress_test_role SERVER s6 OPTIONS (gotcha 'true'); -- ERROR
473 DROP USER MAPPING FOR regress_test_role SERVER s6;              -- ERROR
480 CREATE SERVER s10 FOREIGN DATA WRAPPER foo;                     -- ERROR
481 ALTER SERVER s9 VERSION '1.1';
482 GRANT USAGE ON FOREIGN SERVER s9 TO regress_test_role;
483 CREATE USER MAPPING FOR current_user SERVER s9;
486 DROP SERVER s9 CASCADE;
489 CREATE SERVER s9 FOREIGN DATA WRAPPER foo;
490 GRANT USAGE ON FOREIGN SERVER s9 TO regress_unprivileged_role;
492 ALTER SERVER s9 VERSION '1.2';                                  -- ERROR
493 GRANT USAGE ON FOREIGN SERVER s9 TO regress_test_role;          -- WARNING
494 CREATE USER MAPPING FOR current_user SERVER s9;
495 DROP SERVER s9 CASCADE;                                         -- ERROR
499 CREATE SERVER s10 FOREIGN DATA WRAPPER foo;
500 CREATE USER MAPPING FOR public SERVER s10 OPTIONS (user 'secret');
501 CREATE USER MAPPING FOR regress_unprivileged_role SERVER s10 OPTIONS (user 'secret');
512 DROP SERVER s10 CASCADE;
566   SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value');
575 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value');
586   SERVER s0;
645 ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value');
693 IMPORT FOREIGN SCHEMA s1 FROM SERVER s9 INTO public; -- ERROR
694 IMPORT FOREIGN SCHEMA s1 LIMIT TO (t1) FROM SERVER s9 INTO public; --ERROR
695 IMPORT FOREIGN SCHEMA s1 EXCEPT (t1) FROM SERVER s9 INTO public; -- ERROR
696 IMPORT FOREIGN SCHEMA s1 EXCEPT (t1, t2) FROM SERVER s9 INTO public
712 DROP SERVER t1 CASCADE;
713 DROP USER MAPPING FOR regress_test_role SERVER s6;
716 DROP SERVER s8 CASCADE;