API tools faq
paste
Advertisement
Guest User

QGIS dropping Postgres cursor.

a guest
Feb 29th, 2016
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.64 KB | None | 0 0
raw download clone embed print report
  1. 2016-02-29T16:12:03 1 Query: DECLARE qgis_25 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(225.01042616514362749,83.57854323779955052,242.70702491522806099,101.27514198788398403,27700) AND st_intersects(st_curvetoline("geom"),st_makeenvelope(225.01042616514362749,83.57854323779955052,242.70702491522806099,101.27514198788398403,27700))) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  2.  
  3. LINE 1: ...91522806099,101.27514198788398403,27700))) AND ("gid" IN ())
  4.  
  5. ^
  6.  
  7. ]
  8.  
  9. 2016-02-29T16:12:03 1 1 cursor states lost.
  10.  
  11. SQL: DECLARE qgis_25 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(225.01042616514362749,83.57854323779955052,242.70702491522806099,101.27514198788398403,27700) AND st_intersects(st_curvetoline("geom"),st_makeenvelope(225.01042616514362749,83.57854323779955052,242.70702491522806099,101.27514198788398403,27700))) AND ("gid" IN ())
  12.  
  13. Result: 7 (ERROR: syntax error at or near ")"
  14.  
  15. LINE 1: ...91522806099,101.27514198788398403,27700))) AND ("gid" IN ())
  16.  
  17. ^
  18.  
  19. )
  20.  
  21. 2016-02-29T16:12:03 1 Query: CLOSE qgis_25 returned 7 [ERROR: cursor "qgis_25" does not exist
  22.  
  23. ]
  24.  
  25. 2016-02-29T16:12:03 1 NOTICE: WARNING: there is no transaction in progress
  26.  
  27. 2016-02-29T16:12:04 1 Query: DECLARE qgis_28 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  28.  
  29. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  30.  
  31. ^
  32.  
  33. ]
  34.  
  35. 2016-02-29T16:12:04 1 1 cursor states lost.
  36.  
  37. SQL: DECLARE qgis_28 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  38.  
  39. Result: 7 (ERROR: syntax error at or near ")"
  40.  
  41. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  42.  
  43. ^
  44.  
  45. )
  46.  
  47. 2016-02-29T16:12:04 1 Query: CLOSE qgis_28 returned 7 [ERROR: cursor "qgis_28" does not exist
  48.  
  49. ]
  50.  
  51. 2016-02-29T16:12:04 1 NOTICE: WARNING: there is no transaction in progress
  52.  
  53. 2016-02-29T16:12:04 1 Query: DECLARE qgis_30 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  54.  
  55. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  56.  
  57. ^
  58.  
  59. ]
  60.  
  61. 2016-02-29T16:12:04 1 1 cursor states lost.
  62.  
  63. SQL: DECLARE qgis_30 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  64.  
  65. Result: 7 (ERROR: syntax error at or near ")"
  66.  
  67. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  68.  
  69. ^
  70.  
  71. )
  72.  
  73. 2016-02-29T16:12:04 1 Query: CLOSE qgis_30 returned 7 [ERROR: cursor "qgis_30" does not exist
  74.  
  75. ]
  76.  
  77. 2016-02-29T16:12:04 1 NOTICE: WARNING: there is no transaction in progress
  78.  
  79. 2016-02-29T16:12:04 1 Query: DECLARE qgis_32 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  80.  
  81. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  82.  
  83. ^
  84.  
  85. ]
  86.  
  87. 2016-02-29T16:12:04 1 1 cursor states lost.
  88.  
  89. SQL: DECLARE qgis_32 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  90.  
  91. Result: 7 (ERROR: syntax error at or near ")"
  92.  
  93. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  94.  
  95. ^
  96.  
  97. )
  98.  
  99. 2016-02-29T16:12:04 1 Query: CLOSE qgis_32 returned 7 [ERROR: cursor "qgis_32" does not exist
  100.  
  101. ]
  102.  
  103. 2016-02-29T16:12:04 1 NOTICE: WARNING: there is no transaction in progress
  104.  
  105. 2016-02-29T16:12:04 1 Query: DECLARE qgis_34 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  106.  
  107. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  108.  
  109. ^
  110.  
  111. ]
  112.  
  113. 2016-02-29T16:12:04 1 1 cursor states lost.
  114.  
  115. SQL: DECLARE qgis_34 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  116.  
  117. Result: 7 (ERROR: syntax error at or near ")"
  118.  
  119. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  120.  
  121. ^
  122.  
  123. )
  124.  
  125. 2016-02-29T16:12:04 1 Query: CLOSE qgis_34 returned 7 [ERROR: cursor "qgis_34" does not exist
  126.  
  127. ]
  128.  
  129. 2016-02-29T16:12:04 1 NOTICE: WARNING: there is no transaction in progress
  130.  
  131. 2016-02-29T16:12:05 1 Query: DECLARE qgis_36 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(233.8587255401859295,83.57854323779955052,251.55532429027036301,101.27514198788398403,27700) AND st_intersects(st_curvetoline("geom"),st_makeenvelope(233.8587255401859295,83.57854323779955052,251.55532429027036301,101.27514198788398403,27700))) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  132.  
  133. LINE 1: ...29027036301,101.27514198788398403,27700))) AND ("gid" IN ())
  134.  
  135. ^
  136.  
  137. ]
  138.  
  139. 2016-02-29T16:12:05 1 1 cursor states lost.
  140.  
  141. SQL: DECLARE qgis_36 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(233.8587255401859295,83.57854323779955052,251.55532429027036301,101.27514198788398403,27700) AND st_intersects(st_curvetoline("geom"),st_makeenvelope(233.8587255401859295,83.57854323779955052,251.55532429027036301,101.27514198788398403,27700))) AND ("gid" IN ())
  142.  
  143. Result: 7 (ERROR: syntax error at or near ")"
  144.  
  145. LINE 1: ...29027036301,101.27514198788398403,27700))) AND ("gid" IN ())
  146.  
  147. ^
  148.  
  149. )
  150.  
  151. 2016-02-29T16:12:05 1 Query: CLOSE qgis_36 returned 7 [ERROR: cursor "qgis_36" does not exist
  152.  
  153. ]
  154.  
  155. 2016-02-29T16:12:05 1 NOTICE: WARNING: there is no transaction in progress
  156.  
  157. 2016-02-29T16:12:06 1 Query: DECLARE qgis_39 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  158.  
  159. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  160.  
  161. ^
  162.  
  163. ]
  164.  
  165. 2016-02-29T16:12:06 1 1 cursor states lost.
  166.  
  167. SQL: DECLARE qgis_39 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  168.  
  169. Result: 7 (ERROR: syntax error at or near ")"
  170.  
  171. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  172.  
  173. ^
  174.  
  175. )
  176.  
  177. 2016-02-29T16:12:06 1 Query: CLOSE qgis_39 returned 7 [ERROR: cursor "qgis_39" does not exist
  178.  
  179. ]
  180.  
  181. 2016-02-29T16:12:06 1 NOTICE: WARNING: there is no transaction in progress
  182.  
  183. 2016-02-29T16:12:06 1 Query: DECLARE qgis_41 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  184.  
  185. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  186.  
  187. ^
  188.  
  189. ]
  190.  
  191. 2016-02-29T16:12:06 1 1 cursor states lost.
  192.  
  193. SQL: DECLARE qgis_41 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  194.  
  195. Result: 7 (ERROR: syntax error at or near ")"
  196.  
  197. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  198.  
  199. ^
  200.  
  201. )
  202.  
  203. 2016-02-29T16:12:06 1 Query: CLOSE qgis_41 returned 7 [ERROR: cursor "qgis_41" does not exist
  204.  
  205. ]
  206.  
  207. 2016-02-29T16:12:06 1 NOTICE: WARNING: there is no transaction in progress
  208.  
  209. 2016-02-29T16:12:09 1 Query: DECLARE qgis_43 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  210.  
  211. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  212.  
  213. ^
  214.  
  215. ]
  216.  
  217. 2016-02-29T16:12:09 1 1 cursor states lost.
  218.  
  219. SQL: DECLARE qgis_43 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_polygons" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  220.  
  221. Result: 7 (ERROR: syntax error at or near ")"
  222.  
  223. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  224.  
  225. ^
  226.  
  227. )
  228.  
  229. 2016-02-29T16:12:09 1 Query: CLOSE qgis_43 returned 7 [ERROR: cursor "qgis_43" does not exist
  230.  
  231. ]
  232.  
  233. 2016-02-29T16:12:09 1 NOTICE: WARNING: there is no transaction in progress
  234.  
  235. 2016-02-29T16:12:09 1 Query: DECLARE qgis_45 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ()) returned 7 [ERROR: syntax error at or near ")"
  236.  
  237. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  238.  
  239. ^
  240.  
  241. ]
  242.  
  243. 2016-02-29T16:12:09 1 1 cursor states lost.
  244.  
  245. SQL: DECLARE qgis_45 BINARY CURSOR FOR SELECT st_asbinary("geom",'NDR'),"gid" FROM "public"."bng_lines" WHERE ("geom" && st_makeenvelope(-397.02501990032465073,-65.07288626290983302,872.70594041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  246.  
  247. Result: 7 (ERROR: syntax error at or near ")"
  248.  
  249. LINE 1: ...041823460429,247.27208167608068834,27700)) AND ("gid" IN ())
  250.  
  251. ^
  252.  
  253. )
  254.  
  255. 2016-02-29T16:12:09 1 Query: CLOSE qgis_45 returned 7 [ERROR: cursor "qgis_45" does not exist
  256.  
  257. ]
  258.  
  259. 2016-02-29T16:12:09 1 NOTICE: WARNING: there is no transaction in progress
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!