|
1
|
2015-02-10 00:00:35 CET LOG: database system was interrupted; last known up at 2015-02-09 23:53:12 CET
|
|
2
|
2015-02-10 00:00:35 CET LOG: database system was not properly shut down; automatic recovery in progress
|
|
3
|
2015-02-10 00:00:35 CET LOG: record with zero length at 0/377D250
|
|
4
|
2015-02-10 00:00:35 CET LOG: redo is not required
|
|
5
|
2015-02-10 00:00:35 CET LOG: database system is ready to accept connections
|
|
6
|
2015-02-10 00:00:35 CET LOG: autovacuum launcher started
|
|
7
|
2015-02-10 00:01:43 CET LOG: statement: set client_encoding to 'UNICODE'
|
|
8
|
2015-02-10 00:01:43 CET LOG: statement: select regclass('pg_class')::oid
|
|
9
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
10
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
|
|
11
|
2015-02-10 00:01:44 CET LOG: statement: fetch forward 1 from oidcursor
|
|
12
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE oidcursor
|
|
13
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
14
|
2015-02-10 00:01:44 CET LOG: statement: SELECT postgis_version()
|
|
15
|
2015-02-10 00:01:44 CET LOG: statement: SELECT postgis_geos_version(),postgis_proj_version()
|
|
16
|
2015-02-10 00:01:44 CET LOG: statement: SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND c.relname='topology' )
|
|
17
|
2015-02-10 00:01:44 CET LOG: statement: SET application_name='QGIS'
|
|
18
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."building" LIMIT 1
|
|
19
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
20
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."building"','DELETE'),has_any_column_privilege('"public"."building"','UPDATE'),has_column_privilege('"public"."building"','geom','UPDATE'),has_table_privilege('"public"."building"','INSERT'),current_schema()
|
|
21
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='building' AND nspname='public'
|
|
22
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='building' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
23
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."building"')::oid
|
|
24
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36267 AND objsubid=0
|
|
25
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."building" LIMIT 0
|
|
26
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
27
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36267 AND attnum=1
|
|
28
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36267 AND objsubid=1
|
|
29
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
30
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36267 AND attnum=2
|
|
31
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36267 AND objsubid=2
|
|
32
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
33
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36267 AND attnum=3
|
|
34
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36267 AND objsubid=3
|
|
35
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."building"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
36
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36420 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
37
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."bunker" LIMIT 1
|
|
38
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
39
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."bunker"','DELETE'),has_any_column_privilege('"public"."bunker"','UPDATE'),has_column_privilege('"public"."bunker"','geom','UPDATE'),has_table_privilege('"public"."bunker"','INSERT'),current_schema()
|
|
40
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='bunker' AND nspname='public'
|
|
41
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='bunker' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
42
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."bunker"')::oid
|
|
43
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=0
|
|
44
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."bunker" LIMIT 0
|
|
45
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
46
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=1
|
|
47
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=1
|
|
48
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
49
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=2
|
|
50
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=2
|
|
51
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
52
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=3
|
|
53
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=3
|
|
54
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
55
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=4
|
|
56
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=4
|
|
57
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
58
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=5
|
|
59
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=5
|
|
60
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
61
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=6
|
|
62
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=6
|
|
63
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
64
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=7
|
|
65
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=7
|
|
66
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
67
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36275 AND attnum=8
|
|
68
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36275 AND objsubid=8
|
|
69
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."bunker"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
70
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36422 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
71
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."diseases" LIMIT 1
|
|
72
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
73
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."diseases"','DELETE'),has_any_column_privilege('"public"."diseases"','UPDATE'),has_column_privilege('"public"."diseases"','geom','UPDATE'),has_table_privilege('"public"."diseases"','INSERT'),current_schema()
|
|
74
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='diseases' AND nspname='public'
|
|
75
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='diseases' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
76
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."diseases"')::oid
|
|
77
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=0
|
|
78
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."diseases" LIMIT 0
|
|
79
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
80
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=1
|
|
81
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=1
|
|
82
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
83
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=2
|
|
84
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=2
|
|
85
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
86
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=3
|
|
87
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=3
|
|
88
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
89
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=4
|
|
90
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=4
|
|
91
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
92
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=5
|
|
93
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=5
|
|
94
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
95
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=6
|
|
96
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=6
|
|
97
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
98
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=7
|
|
99
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=7
|
|
100
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
101
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36283 AND attnum=8
|
|
102
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36283 AND objsubid=8
|
|
103
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."diseases"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
104
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36424 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
105
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."hole_shape" LIMIT 1
|
|
106
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
107
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."hole_shape"','DELETE'),has_any_column_privilege('"public"."hole_shape"','UPDATE'),has_column_privilege('"public"."hole_shape"','geom','UPDATE'),has_table_privilege('"public"."hole_shape"','INSERT'),current_schema()
|
|
108
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='hole_shape' AND nspname='public'
|
|
109
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='hole_shape' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
110
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."hole_shape"')::oid
|
|
111
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36291 AND objsubid=0
|
|
112
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."hole_shape" LIMIT 0
|
|
113
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
114
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36291 AND attnum=1
|
|
115
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36291 AND objsubid=1
|
|
116
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
117
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36291 AND attnum=2
|
|
118
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36291 AND objsubid=2
|
|
119
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
120
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36291 AND attnum=3
|
|
121
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36291 AND objsubid=3
|
|
122
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
123
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36291 AND attnum=4
|
|
124
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36291 AND objsubid=4
|
|
125
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."hole_shape"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
126
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36426 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
127
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_object" LIMIT 1
|
|
128
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
129
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."irr_object"','DELETE'),has_any_column_privilege('"public"."irr_object"','UPDATE'),has_column_privilege('"public"."irr_object"','geom','UPDATE'),has_table_privilege('"public"."irr_object"','INSERT'),current_schema()
|
|
130
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='irr_object' AND nspname='public'
|
|
131
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='irr_object' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
132
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."irr_object"')::oid
|
|
133
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=0
|
|
134
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_object" LIMIT 0
|
|
135
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
136
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=1
|
|
137
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=1
|
|
138
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
139
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=2
|
|
140
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=2
|
|
141
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
142
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=3
|
|
143
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=3
|
|
144
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
145
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=4
|
|
146
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=4
|
|
147
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
148
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=5
|
|
149
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=5
|
|
150
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
151
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=6
|
|
152
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=6
|
|
153
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
154
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=7
|
|
155
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=7
|
|
156
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
157
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=8
|
|
158
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=8
|
|
159
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
160
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=9
|
|
161
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=9
|
|
162
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
163
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36299 AND attnum=10
|
|
164
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36299 AND objsubid=10
|
|
165
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."irr_object"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
166
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36428 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
167
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_pipe" LIMIT 1
|
|
168
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
169
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."irr_pipe"','DELETE'),has_any_column_privilege('"public"."irr_pipe"','UPDATE'),has_column_privilege('"public"."irr_pipe"','geom','UPDATE'),has_table_privilege('"public"."irr_pipe"','INSERT'),current_schema()
|
|
170
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='irr_pipe' AND nspname='public'
|
|
171
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='irr_pipe' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
172
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."irr_pipe"')::oid
|
|
173
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=0
|
|
174
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_pipe" LIMIT 0
|
|
175
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
176
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=1
|
|
177
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=1
|
|
178
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
179
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=2
|
|
180
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=2
|
|
181
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
182
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=3
|
|
183
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=3
|
|
184
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=21
|
|
185
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=4
|
|
186
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=4
|
|
187
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
188
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=5
|
|
189
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=5
|
|
190
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
191
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=6
|
|
192
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=6
|
|
193
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
194
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=7
|
|
195
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=7
|
|
196
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
197
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=8
|
|
198
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=8
|
|
199
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
200
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=9
|
|
201
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=9
|
|
202
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
203
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=10
|
|
204
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=10
|
|
205
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
206
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=11
|
|
207
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=11
|
|
208
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
209
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=12
|
|
210
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=12
|
|
211
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
212
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36307 AND attnum=13
|
|
213
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36307 AND objsubid=13
|
|
214
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."irr_pipe"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
215
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36430 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
216
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_sprink" LIMIT 1
|
|
217
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
218
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."irr_sprink"','DELETE'),has_any_column_privilege('"public"."irr_sprink"','UPDATE'),has_column_privilege('"public"."irr_sprink"','geom','UPDATE'),has_table_privilege('"public"."irr_sprink"','INSERT'),current_schema()
|
|
219
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='irr_sprink' AND nspname='public'
|
|
220
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='irr_sprink' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
221
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."irr_sprink"')::oid
|
|
222
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=0
|
|
223
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."irr_sprink" LIMIT 0
|
|
224
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
225
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36315 AND attnum=1
|
|
226
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=1
|
|
227
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
228
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36315 AND attnum=2
|
|
229
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=2
|
|
230
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
231
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36315 AND attnum=3
|
|
232
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=3
|
|
233
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
234
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36315 AND attnum=4
|
|
235
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=4
|
|
236
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
237
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36315 AND attnum=5
|
|
238
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36315 AND objsubid=5
|
|
239
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."irr_sprink"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
240
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36432 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
241
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."objects" LIMIT 1
|
|
242
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
243
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."objects"','DELETE'),has_any_column_privilege('"public"."objects"','UPDATE'),has_column_privilege('"public"."objects"','geom','UPDATE'),has_table_privilege('"public"."objects"','INSERT'),current_schema()
|
|
244
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='objects' AND nspname='public'
|
|
245
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='objects' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
246
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."objects"')::oid
|
|
247
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=0
|
|
248
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."objects" LIMIT 0
|
|
249
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
250
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=1
|
|
251
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=1
|
|
252
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
253
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=2
|
|
254
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=2
|
|
255
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
256
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=3
|
|
257
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=3
|
|
258
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
259
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=4
|
|
260
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=4
|
|
261
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
262
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=5
|
|
263
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=5
|
|
264
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
265
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36323 AND attnum=6
|
|
266
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36323 AND objsubid=6
|
|
267
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."objects"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
268
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36434 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
269
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."path" LIMIT 1
|
|
270
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
271
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."path"','DELETE'),has_any_column_privilege('"public"."path"','UPDATE'),has_column_privilege('"public"."path"','geom','UPDATE'),has_table_privilege('"public"."path"','INSERT'),current_schema()
|
|
272
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='path' AND nspname='public'
|
|
273
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='path' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
274
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."path"')::oid
|
|
275
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36331 AND objsubid=0
|
|
276
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."path" LIMIT 0
|
|
277
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
278
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36331 AND attnum=1
|
|
279
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36331 AND objsubid=1
|
|
280
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
281
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36331 AND attnum=2
|
|
282
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36331 AND objsubid=2
|
|
283
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
284
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36331 AND attnum=3
|
|
285
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36331 AND objsubid=3
|
|
286
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
287
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36331 AND attnum=4
|
|
288
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36331 AND objsubid=4
|
|
289
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."path"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
290
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36436 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
291
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."pin_posit" LIMIT 1
|
|
292
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
293
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."pin_posit"','DELETE'),has_any_column_privilege('"public"."pin_posit"','UPDATE'),has_column_privilege('"public"."pin_posit"','geom','UPDATE'),has_table_privilege('"public"."pin_posit"','INSERT'),current_schema()
|
|
294
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='pin_posit' AND nspname='public'
|
|
295
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='pin_posit' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
296
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."pin_posit"')::oid
|
|
297
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36339 AND objsubid=0
|
|
298
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."pin_posit" LIMIT 0
|
|
299
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
300
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36339 AND attnum=1
|
|
301
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36339 AND objsubid=1
|
|
302
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
303
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36339 AND attnum=2
|
|
304
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36339 AND objsubid=2
|
|
305
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
306
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36339 AND attnum=3
|
|
307
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36339 AND objsubid=3
|
|
308
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
309
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36339 AND attnum=4
|
|
310
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36339 AND objsubid=4
|
|
311
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."pin_posit"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
312
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36438 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
313
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."playline" LIMIT 1
|
|
314
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
315
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."playline"','DELETE'),has_any_column_privilege('"public"."playline"','UPDATE'),has_column_privilege('"public"."playline"','geom','UPDATE'),has_table_privilege('"public"."playline"','INSERT'),current_schema()
|
|
316
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='playline' AND nspname='public'
|
|
317
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='playline' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
318
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."playline"')::oid
|
|
319
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36347 AND objsubid=0
|
|
320
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."playline" LIMIT 0
|
|
321
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
322
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36347 AND attnum=1
|
|
323
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36347 AND objsubid=1
|
|
324
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
325
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36347 AND attnum=2
|
|
326
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36347 AND objsubid=2
|
|
327
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
328
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36347 AND attnum=3
|
|
329
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36347 AND objsubid=3
|
|
330
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
331
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36347 AND attnum=4
|
|
332
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36347 AND objsubid=4
|
|
333
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."playline"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
334
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36440 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
335
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."tee_marker" LIMIT 1
|
|
336
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
337
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."tee_marker"','DELETE'),has_any_column_privilege('"public"."tee_marker"','UPDATE'),has_column_privilege('"public"."tee_marker"','geom','UPDATE'),has_table_privilege('"public"."tee_marker"','INSERT'),current_schema()
|
|
338
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='tee_marker' AND nspname='public'
|
|
339
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='tee_marker' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
340
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."tee_marker"')::oid
|
|
341
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36355 AND objsubid=0
|
|
342
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."tee_marker" LIMIT 0
|
|
343
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
344
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36355 AND attnum=1
|
|
345
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36355 AND objsubid=1
|
|
346
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
347
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36355 AND attnum=2
|
|
348
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36355 AND objsubid=2
|
|
349
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."tee_marker"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
350
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36442 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
351
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."trees" LIMIT 1
|
|
352
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
353
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."trees"','DELETE'),has_any_column_privilege('"public"."trees"','UPDATE'),has_column_privilege('"public"."trees"','geom','UPDATE'),has_table_privilege('"public"."trees"','INSERT'),current_schema()
|
|
354
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='trees' AND nspname='public'
|
|
355
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='trees' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
356
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."trees"')::oid
|
|
357
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=0
|
|
358
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."trees" LIMIT 0
|
|
359
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
360
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=1
|
|
361
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=1
|
|
362
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
363
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=2
|
|
364
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=2
|
|
365
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
366
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=3
|
|
367
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=3
|
|
368
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
369
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=4
|
|
370
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=4
|
|
371
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
372
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=5
|
|
373
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=5
|
|
374
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
375
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=6
|
|
376
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=6
|
|
377
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
378
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36363 AND attnum=7
|
|
379
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36363 AND objsubid=7
|
|
380
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."trees"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
381
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36444 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
382
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."turf" LIMIT 1
|
|
383
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
384
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."turf"','DELETE'),has_any_column_privilege('"public"."turf"','UPDATE'),has_column_privilege('"public"."turf"','geom','UPDATE'),has_table_privilege('"public"."turf"','INSERT'),current_schema()
|
|
385
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='turf' AND nspname='public'
|
|
386
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='turf' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
387
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."turf"')::oid
|
|
388
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=0
|
|
389
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."turf" LIMIT 0
|
|
390
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
391
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=1
|
|
392
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=1
|
|
393
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
394
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=2
|
|
395
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=2
|
|
396
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
397
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=3
|
|
398
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=3
|
|
399
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
400
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=4
|
|
401
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=4
|
|
402
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
403
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=5
|
|
404
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=5
|
|
405
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
406
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=6
|
|
407
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=6
|
|
408
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
409
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=7
|
|
410
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=7
|
|
411
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=21
|
|
412
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=8
|
|
413
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=8
|
|
414
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
415
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=9
|
|
416
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=9
|
|
417
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
418
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=10
|
|
419
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=10
|
|
420
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
421
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36371 AND attnum=11
|
|
422
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36371 AND objsubid=11
|
|
423
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."turf"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
424
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36446 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
425
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."vegetation" LIMIT 1
|
|
426
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
427
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."vegetation"','DELETE'),has_any_column_privilege('"public"."vegetation"','UPDATE'),has_column_privilege('"public"."vegetation"','geom','UPDATE'),has_table_privilege('"public"."vegetation"','INSERT'),current_schema()
|
|
428
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='vegetation' AND nspname='public'
|
|
429
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='vegetation' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
430
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."vegetation"')::oid
|
|
431
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=0
|
|
432
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."vegetation" LIMIT 0
|
|
433
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
434
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=1
|
|
435
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=1
|
|
436
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
437
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=2
|
|
438
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=2
|
|
439
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
440
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=3
|
|
441
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=3
|
|
442
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
443
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=4
|
|
444
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=4
|
|
445
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
446
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=5
|
|
447
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=5
|
|
448
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
449
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=6
|
|
450
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=6
|
|
451
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
452
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36379 AND attnum=7
|
|
453
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36379 AND objsubid=7
|
|
454
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."vegetation"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
455
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36448 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
456
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."water" LIMIT 1
|
|
457
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
458
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."water"','DELETE'),has_any_column_privilege('"public"."water"','UPDATE'),has_column_privilege('"public"."water"','geom','UPDATE'),has_table_privilege('"public"."water"','INSERT'),current_schema()
|
|
459
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='water' AND nspname='public'
|
|
460
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='water' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
461
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."water"')::oid
|
|
462
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=0
|
|
463
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."water" LIMIT 0
|
|
464
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
465
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=1
|
|
466
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=1
|
|
467
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
468
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=2
|
|
469
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=2
|
|
470
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
471
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=3
|
|
472
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=3
|
|
473
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
474
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=4
|
|
475
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=4
|
|
476
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
477
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=5
|
|
478
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=5
|
|
479
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
480
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=6
|
|
481
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=6
|
|
482
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
483
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36387 AND attnum=8
|
|
484
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36387 AND objsubid=8
|
|
485
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."water"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
486
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36450 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
487
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."weeds" LIMIT 1
|
|
488
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_is_in_recovery()
|
|
489
|
2015-02-10 00:01:44 CET LOG: statement: SELECT has_table_privilege('"public"."weeds"','DELETE'),has_any_column_privilege('"public"."weeds"','UPDATE'),has_column_privilege('"public"."weeds"','geom','UPDATE'),has_table_privilege('"public"."weeds"','INSERT'),current_schema()
|
|
490
|
2015-02-10 00:01:44 CET LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='weeds' AND nspname='public'
|
|
491
|
2015-02-10 00:01:44 CET LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='weeds' AND f_geometry_column='geom' AND f_table_schema='public'
|
|
492
|
2015-02-10 00:01:44 CET LOG: statement: SELECT regclass('"public"."weeds"')::oid
|
|
493
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=0
|
|
494
|
2015-02-10 00:01:44 CET LOG: statement: SELECT * FROM "public"."weeds" LIMIT 0
|
|
495
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
|
|
496
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=1
|
|
497
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=1
|
|
498
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
499
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=2
|
|
500
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=2
|
|
501
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
502
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=3
|
|
503
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=3
|
|
504
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1082
|
|
505
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=4
|
|
506
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=4
|
|
507
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
508
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=5
|
|
509
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=5
|
|
510
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
511
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=6
|
|
512
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=6
|
|
513
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
514
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=7
|
|
515
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=7
|
|
516
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
517
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=8
|
|
518
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=8
|
|
519
|
2015-02-10 00:01:44 CET LOG: statement: SELECT typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
|
|
520
|
2015-02-10 00:01:44 CET LOG: statement: SELECT pg_catalog.format_type(atttypid,atttypmod) FROM pg_attribute WHERE attrelid=36395 AND attnum=9
|
|
521
|
2015-02-10 00:01:44 CET LOG: statement: SELECT description FROM pg_description WHERE objoid=36395 AND objsubid=9
|
|
522
|
2015-02-10 00:01:44 CET LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"public"."weeds"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1
|
|
523
|
2015-02-10 00:01:44 CET LOG: statement: SELECT attname FROM pg_index,pg_attribute WHERE indexrelid=36452 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey)
|
|
524
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='building' AND attname='geom'
|
|
525
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."building"
|
|
526
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='bunker' AND attname='geom'
|
|
527
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."bunker"
|
|
528
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='diseases' AND attname='geom'
|
|
529
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."diseases"
|
|
530
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='hole_shape' AND attname='geom'
|
|
531
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."hole_shape"
|
|
532
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='irr_object' AND attname='geom'
|
|
533
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."irr_object"
|
|
534
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='irr_pipe' AND attname='geom'
|
|
535
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."irr_pipe"
|
|
536
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='irr_sprink' AND attname='geom'
|
|
537
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."irr_sprink"
|
|
538
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='objects' AND attname='geom'
|
|
539
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."objects"
|
|
540
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='path' AND attname='geom'
|
|
541
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."path"
|
|
542
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='pin_posit' AND attname='geom'
|
|
543
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."pin_posit"
|
|
544
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='playline' AND attname='geom'
|
|
545
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."playline"
|
|
546
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='tee_marker' AND attname='geom'
|
|
547
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."tee_marker"
|
|
548
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='trees' AND attname='geom'
|
|
549
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."trees"
|
|
550
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='turf' AND attname='geom'
|
|
551
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."turf"
|
|
552
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='vegetation' AND attname='geom'
|
|
553
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."vegetation"
|
|
554
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='water' AND attname='geom'
|
|
555
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."water"
|
|
556
|
2015-02-10 00:01:44 CET LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='public' AND tablename='weeds' AND attname='geom'
|
|
557
|
2015-02-10 00:01:44 CET LOG: statement: SELECT st_extent("geom") FROM "public"."weeds"
|
|
558
|
2015-02-10 00:01:44 CET LOG: statement: set client_encoding to 'UNICODE'
|
|
559
|
2015-02-10 00:01:44 CET LOG: statement: select regclass('pg_class')::oid
|
|
560
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN
|
|
561
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
|
|
562
|
2015-02-10 00:01:44 CET LOG: statement: fetch forward 1 from oidcursor
|
|
563
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE oidcursor
|
|
564
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
565
|
2015-02-10 00:01:44 CET LOG: statement: SELECT postgis_version()
|
|
566
|
2015-02-10 00:01:44 CET LOG: statement: SELECT postgis_geos_version(),postgis_proj_version()
|
|
567
|
2015-02-10 00:01:44 CET LOG: statement: SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND c.relname='topology' )
|
|
568
|
2015-02-10 00:01:44 CET LOG: statement: SET application_name='QGIS'
|
|
569
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
570
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_1 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."weeds" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
571
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
|
572
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_1
|
|
573
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
574
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
575
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_2 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."weeds" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
576
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_2
|
|
577
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_2
|
|
578
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
579
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
580
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_3 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."water" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
581
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_3
|
|
582
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_3
|
|
583
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
584
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
585
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_4 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."vegetation" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
586
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_4
|
|
587
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_4
|
|
588
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
589
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
590
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_5 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."turf" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
591
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_5
|
|
592
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_5
|
|
593
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
594
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
595
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_6 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."trees" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
596
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_6
|
|
597
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_6
|
|
598
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
599
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
600
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_7 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."tee_marker" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
601
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_7
|
|
602
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_7
|
|
603
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
604
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
605
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_8 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."playline" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
606
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_8
|
|
607
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_8
|
|
608
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
609
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
610
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_9 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."pin_posit" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
611
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_9
|
|
612
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_9
|
|
613
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
614
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
615
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_10 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."path" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
616
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_10
|
|
617
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_10
|
|
618
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
619
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
620
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_11 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."objects" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
621
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_11
|
|
622
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_11
|
|
623
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
624
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
625
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_12 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."irr_sprink" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
626
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_12
|
|
627
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_12
|
|
628
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
629
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
630
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_13 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."irr_pipe" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
631
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_13
|
|
632
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_13
|
|
633
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
634
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
635
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_14 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"id" FROM "public"."irr_object" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
636
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_14
|
|
637
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_14
|
|
638
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
639
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
640
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_15 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."hole_shape" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
641
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_15
|
|
642
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_15
|
|
643
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
644
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
645
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_16 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."diseases" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
646
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_16
|
|
647
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_16
|
|
648
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
649
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
650
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_17 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."bunker" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
651
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_17
|
|
652
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_17
|
|
653
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
654
|
2015-02-10 00:01:44 CET LOG: statement: BEGIN READ ONLY
|
|
655
|
2015-02-10 00:01:44 CET LOG: statement: DECLARE qgis_18 BINARY CURSOR FOR SELECT st_asbinary(st_snaptogrid("geom",1.59686),'NDR'),"id" FROM "public"."building" WHERE "geom" && st_makeenvelope(-8781445.67319201491773129,4565621.29365538712590933,-8779910.69624516926705837,4566650.26714836340397596,3857)
|
|
656
|
2015-02-10 00:01:44 CET LOG: statement: FETCH FORWARD 2000 FROM qgis_18
|
|
657
|
2015-02-10 00:01:44 CET LOG: statement: CLOSE qgis_18
|
|
658
|
2015-02-10 00:01:44 CET LOG: statement: COMMIT
|
|
659
|
2015-02-10 00:01:56 CET LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
|
|
660
|
|
|
661
|
2015-02-10 00:02:07 CET LOG: received fast shutdown request
|
|
662
|
2015-02-10 00:02:07 CET LOG: aborting any active transactions
|
|
663
|
2015-02-10 00:02:07 CET LOG: autovacuum launcher shutting down
|
|
664
|
2015-02-10 00:02:07 CET LOG: shutting down
|
|
665
|
2015-02-10 00:02:07 CET LOG: database system is shut down
|