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
|
set client_min_messages = 'warning';
\set VERBOSITY 'terse'
select 1
from (select set_config(name, 'escape', false) as ignore
from pg_settings where name = 'bytea_output') x
where x.ignore = 'foo';
--
-- tables
--
create table leafdata (
id serial primary key,
data text
);
select current_database();
select * from pgq_node.register_location('leafq', 'lq_node1', 'dbname=db', false);
select * from pgq_node.register_location('leafq', 'lq_node2', 'dbname=db2', false);
select * from pgq_node.create_node('leafq', 'leaf', 'lq_node2', 'londiste_leaf', 'lq_node1', 100, null::text);
select * from londiste.local_show_missing('leafq');
select * from londiste.local_add_table('leafq', 'public.leafdata');
select * from londiste.global_add_table('leafq', 'public.leafdata');
select * from londiste.local_add_table('leafq', 'public.leafdata');
select * from londiste.global_add_table('leafq', 'public.tmp');
select * from londiste.get_table_list('leafq');
select tgname, tgargs from pg_trigger
where tgrelid = 'public.leafdata'::regclass
order by 1;
insert into leafdata values (1, 'asd');
select * from londiste.global_remove_table('leafq', 'public.tmp');
select * from londiste.local_remove_table('leafq', 'public.leafdata');
select * from londiste.local_remove_table('leafq', 'public.leafdata');
select * from londiste.get_table_list('leafq');
select * from londiste.local_show_missing('leafq');
|
