SHARE
TWEET

Untitled

a guest Feb 16th, 2014 97 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- easyloader create table stuff
  2.  
  3. 2014-02-16 10:34:24 UTC LOG:  statement: select 1 from "mapinfo"."mapinfo_mapcatalog"
  4. 2014-02-16 10:34:24 UTC LOG:  statement: select 1 from "planning"."polygons_bng5365"
  5. 2014-02-16 10:34:24 UTC ERROR:  relation "planning.polygons_bng5365" does not exist at character 15
  6. 2014-02-16 10:34:24 UTC STATEMENT:  select 1 from "planning"."polygons_bng5365"
  7. 2014-02-16 10:34:24 UTC LOG:  statement: SELECT * FROM public.spatial_ref_sys WHERE srid = 27700
  8. 2014-02-16 10:34:24 UTC LOG:  statement: create table "planning"."polygons_bng5365"( "app_ref" varchar(20),"id" int4,"MI_STYLE" VARCHAR(254),"MI_PRINX" SERIAL PRIMARY KEY)
  9. 2014-02-16 10:34:24 UTC NOTICE:  CREATE TABLE will create implicit sequence "polygons_bng5365_MI_PRINX_seq" for serial column "polygons_bng5365.MI_PRINX"
  10. 2014-02-16 10:34:24 UTC STATEMENT:  create table "planning"."polygons_bng5365"( "app_ref" varchar(20),"id" int4,"MI_STYLE" VARCHAR(254),"MI_PRINX" SERIAL PRIMARY KEY)
  11. 2014-02-16 10:34:24 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "polygons_bng5365_pkey" for table "polygons_bng5365"
  12. 2014-02-16 10:34:24 UTC STATEMENT:  create table "planning"."polygons_bng5365"( "app_ref" varchar(20),"id" int4,"MI_STYLE" VARCHAR(254),"MI_PRINX" SERIAL PRIMARY KEY)
  13. 2014-02-16 10:34:24 UTC LOG:  statement: SELECT AddGeometryColumn ('planning', 'polygons_bng5365', 'SP_GEOMETRY', 27700, 'GEOMETRY', 2)
  14. 2014-02-16 10:34:24 UTC LOG:  statement: BEGIN;insert into "planning"."polygons_bng5365"( "app_ref","id","MI_STYLE","SP_GEOMETRY") values ( E'AT/14114/08',14,E'Pen (1, 2, 0) Brush (1, 0, 16777215) ',st_geomfromwkb(E'\\001\\003\\000\\000\\000\\001\\000\\000\\000\\013\\000\\000\\000\\1752\\220t \\310\\035Af\\234\\300\\013\\307\\345\\003A\\347\\263\\056\\263\\360\\307\\035AJ\\254QgC\\345\\003A\\352FcY\\016\\310\\035AU\\335J\\274\\031\\345\\003A\\227\\330\\303\\334s\\310\\035AB\\274\\257A\\212\\344\\003A\\317\\233mL\\242\\310\\035At\\235\\323\\236\\010\\345\\003A5N\\023\\367\\230\\310\\035A\\201\\255S\\211\\026\\345\\003A\\2029\\321\\215\\215\\310\\035A5\\246\\362\\053\\047\\345\\003AC\\233\\217Cg\\310\\035A2k\\330\\047\\137\\345\\003A\\263a\\277\\001A\\310\\035A\\050\\026\\035\\212\\227\\345\\003A\\230\\215\\362j0\\310\\035At \\307\\305\\257\\345\\003A\\1752\\220t \\310\\035Af\\234\\300\\013\\307\\345\\003A', 27700))
  15. 2014-02-16 10:34:24 UTC LOG:  statement: COMMIT
  16. 2014-02-16 10:34:24 UTC LOG:  statement: DROP INDEX "planning"."SIndex_polygons_bng5365_SP_GEOMETRY"
  17. 2014-02-16 10:34:24 UTC ERROR:  index "SIndex_polygons_bng5365_SP_GEOMETRY" does not exist
  18. 2014-02-16 10:34:24 UTC STATEMENT:  DROP INDEX "planning"."SIndex_polygons_bng5365_SP_GEOMETRY"
  19. 2014-02-16 10:34:24 UTC LOG:  statement: CREATE INDEX "SIndex_polygons_bng5365_SP_GEOMETRY" ON "planning"."polygons_bng5365" USING GIST ("SP_GEOMETRY")
  20. 2014-02-16 10:34:24 UTC LOG:  statement: VACUUM ANALYZE "planning"."polygons_bng5365"("SP_GEOMETRY")
  21. 2014-02-16 10:34:24 UTC LOG:  statement: select VIEW_X_LL,VIEW_Y_LL,VIEW_X_UR,VIEW_Y_UR from MAPINFO.MAPINFO_MAPCATALOG
  22. 2014-02-16 10:34:24 UTC LOG:  statement: insert into "mapinfo"."mapinfo_mapcatalog" (spatialtype, tablename, ownername, spatialcolumn, db_x_ll, db_y_ll, db_x_ur, db_y_ur, coordinatesystem, symbol, xcolumnname, ycolumnname, renditiontype, renditioncolumn, renditiontable, view_x_ll, view_y_ll, view_x_ur, view_y_ur) values ( 19.2, 'polygons_bng5365', 'planning', 'SP_GEOMETRY', 487932.174983, 162961.282073, 487976.574637, 163000.880738, 'Earth Projection 8, 79, "m", -2, 49, 0.9996012717, 400000, -100000 Bounds (-7845061.1011, -15524202.1641) (8645061.1011, 4470074.53373)', '', 'NO_COLUMN', 'NO_COLUMN', 1, 'MI_STYLE', '' , 487932.174983, 160574.965150, 490597.036446, 163000.880738)
  23. 2014-02-16 10:34:24 UTC ERROR:  duplicate key value violates unique constraint "mapcatalog_idx"
  24. 2014-02-16 10:34:24 UTC DETAIL:  Key (tablename, ownername)=(polygons_bng5365, planning) already exists.
  25. 2014-02-16 10:34:24 UTC STATEMENT:  insert into "mapinfo"."mapinfo_mapcatalog" (spatialtype, tablename, ownername, spatialcolumn, db_x_ll, db_y_ll, db_x_ur, db_y_ur, coordinatesystem, symbol, xcolumnname, ycolumnname, renditiontype, renditioncolumn, renditiontable, view_x_ll, view_y_ll, view_x_ur, view_y_ur) values ( 19.2, 'polygons_bng5365', 'planning', 'SP_GEOMETRY', 487932.174983, 162961.282073, 487976.574637, 163000.880738, 'Earth Projection 8, 79, "m", -2, 49, 0.9996012717, 400000, -100000 Bounds (-7845061.1011, -15524202.1641) (8645061.1011, 4470074.53373)', '', 'NO_COLUMN', 'NO_COLUMN', 1, 'MI_STYLE', '' , 487932.174983, 160574.965150, 490597.036446, 163000.880738)
  26. 2014-02-16 10:34:24 UTC LOG:  statement: select VIEW_X_LL,VIEW_Y_LL,VIEW_X_UR,VIEW_Y_UR from MAPINFO.MAPINFO_MAPCATALOG
  27. 2014-02-16 10:34:24 UTC LOG:  statement: update "mapinfo"."mapinfo_mapcatalog" SET  SPATIALTYPE  = 19.2, SPATIALCOLUMN = 'SP_GEOMETRY', DB_X_LL  = 487932.174983, DB_Y_LL = 162961.282073, DB_X_UR = 487976.574637, DB_Y_UR = 163000.880738, COORDINATESYSTEM = 'Earth Projection 8, 79, "m", -2, 49, 0.9996012717, 400000, -100000 Bounds (-7845061.1011, -15524202.1641) (8645061.1011, 4470074.53373)', SYMBOL = '', XCOLUMNNAME = 'NO_COLUMN', YCOLUMNNAME = 'NO_COLUMN', RENDITIONTYPE = 1, RENDITIONCOLUMN = 'MI_STYLE', RENDITIONTABLE = '', VIEW_X_LL  = 487932.174983, VIEW_Y_LL = 160574.965150, VIEW_X_UR = 490597.036446, VIEW_Y_UR = 163000.880738 where  TABLENAME  =  'polygons_bng5365' and OWNERNAME =  'planning'
  28.  
  29. -- ogr create table stuff
  30.  
  31. 2014-02-16 10:35:04 UTC LOG:  statement: CREATE TABLE "planning"."polygons_ogr_28777" ( OGC_FID SERIAL, CONSTRAINT "polygons_ogr_28777_pk" PRIMARY KEY (OGC_FID) )
  32. 2014-02-16 10:35:04 UTC NOTICE:  CREATE TABLE will create implicit sequence "polygons_ogr_28777_ogc_fid_seq" for serial column "polygons_ogr_28777.ogc_fid"
  33. 2014-02-16 10:35:04 UTC STATEMENT:  CREATE TABLE "planning"."polygons_ogr_28777" ( OGC_FID SERIAL, CONSTRAINT "polygons_ogr_28777_pk" PRIMARY KEY (OGC_FID) )
  34. 2014-02-16 10:35:04 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "polygons_ogr_28777_pk" for table "polygons_ogr_28777"
  35. 2014-02-16 10:35:04 UTC STATEMENT:  CREATE TABLE "planning"."polygons_ogr_28777" ( OGC_FID SERIAL, CONSTRAINT "polygons_ogr_28777_pk" PRIMARY KEY (OGC_FID) )
  36. 2014-02-16 10:35:04 UTC LOG:  statement: DELETE FROM geometry_columns WHERE f_table_name = 'polygons_ogr_28777' AND f_table_schema = 'planning'
  37. 2014-02-16 10:35:04 UTC LOG:  statement: SELECT AddGeometryColumn('planning','polygons_ogr_28777','wkb_geometry',27700,'GEOMETRY',2)
  38. 2014-02-16 10:35:04 UTC LOG:  statement: CREATE INDEX "polygons_ogr_28777_geom_idx" ON "planning"."polygons_ogr_28777" USING GIST ("wkb_geometry")
  39. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  40. 2014-02-16 10:35:04 UTC LOG:  statement: SELECT a.attname, a.attnum, t.typname, t.typname = ANY(ARRAY['int2','int4','serial']) AS isfid FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n, pg_index i WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND c.relnamespace = n.oid AND c.oid = i.indrelid AND i.indisprimary = 't' AND t.typname !~ '^geom' AND c.relname = 'polygons_ogr_28777' AND (i.indkey[0]=a.attnum OR i.indkey[1]=a.attnum OR i.indkey[2]=a.attnum OR i.indkey[3]=a.attnum OR i.indkey[4]=a.attnum OR i.indkey[5]=a.attnum OR i.indkey[6]=a.attnum OR i.indkey[7]=a.attnum OR i.indkey[8]=a.attnum OR i.indkey[9]=a.attnum) AND n.nspname='planning' ORDER BY a.attnum
  41. 2014-02-16 10:35:04 UTC LOG:  statement: BEGIN
  42. 2014-02-16 10:35:04 UTC LOG:  statement: DECLARE mycursor CURSOR for SELECT DISTINCT a.attname, t.typname, a.attlen,       format_type(a.atttypid,a.atttypmod) FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE c.relname = 'polygons_ogr_28777' AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND c.relnamespace=n.oid AND n.nspname='planning'
  43. 2014-02-16 10:35:04 UTC LOG:  statement: FETCH ALL in mycursor
  44. 2014-02-16 10:35:04 UTC LOG:  statement: CLOSE mycursor
  45. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  46. 2014-02-16 10:35:04 UTC LOG:  statement: SELECT type, coord_dimension FROM geometry_columns WHERE f_table_name='polygons_ogr_28777' AND f_geometry_column='wkb_geometry' AND f_table_schema='planning'
  47. 2014-02-16 10:35:04 UTC LOG:  statement: BEGIN
  48. 2014-02-16 10:35:04 UTC LOG:  statement: ALTER TABLE "planning"."polygons_ogr_28777" ADD COLUMN "app_ref" CHAR(20)
  49. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  50. 2014-02-16 10:35:04 UTC LOG:  statement: BEGIN
  51. 2014-02-16 10:35:04 UTC LOG:  statement: ALTER TABLE "planning"."polygons_ogr_28777" ADD COLUMN "id" INTEGER
  52. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  53. 2014-02-16 10:35:04 UTC LOG:  statement: BEGIN
  54. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  55. 2014-02-16 10:35:04 UTC LOG:  statement: BEGIN
  56. 2014-02-16 10:35:04 UTC LOG:  statement: INSERT INTO "planning"."polygons_ogr_28777" ("wkb_geometry" , "app_ref", "id") VALUES (GeomFromEWKT('SRID=27700;POLYGON ((487944.11383131874 163000.88073846998,487948.10444089165 162997.97157121045,487952.25170662551 162994.94243829072,487961.81597750279 162987.89445575472,487971.38849344116 162980.89645891049,487974.24128458212 162978.81705413392,487976.57463687373 162977.07755206121,487964.96559084341 162961.28207346992,487939.58729277423 162979.21693966788,487932.17498284433 162984.42544874767,487944.11383131874 163000.88073846998))'::TEXT) , 'AT/14114/08', 14) RETURNING ogc_fid
  57. 2014-02-16 10:35:04 UTC LOG:  statement: COMMIT
  58.  
  59. -- mapinfo access to easyloader table
  60.  
  61. 2014-02-16 10:36:21 UTC LOG:  statement: SELECT SPATIALTYPE, TABLENAME, OWNERNAME, SPATIALCOLUMN, DB_X_LL, DB_Y_LL, DB_X_UR, DB_Y_UR, COORDINATESYSTEM, SYMBOL, XCOLUMNNAME, YCOLUMNNAME ,RENDITIONTYPE, RENDITIONCOLUMN, RENDITIONTABLE,NUMBER_ROWS,VIEW_X_LL, VIEW_Y_LL, VIEW_X_UR, VIEW_Y_UR FROM "mapinfo"."mapinfo_mapcatalog" WHERE TABLENAME = 'polygons_bng5365' AND OWNERNAME = 'planning'
  62. 2014-02-16 10:36:21 UTC LOG:  statement: select 1 from pg_views where schemaname = 'planning' and viewname = 'polygons_bng5365'
  63. 2014-02-16 10:36:21 UTC LOG:  statement: select find_srid('planning', 'polygons_bng5365', 'SP_GEOMETRY')
  64. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like E'polygons_bng5365' and n.nspname like E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  65. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'polygons_bng5365' and u.nspname = E'planning'
  66. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname = E'polygons_bng5365' and n.nspname = E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  67. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname, c.relhasrules, n.nspname, c.oid, d.relhasoids from pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a, pg_catalog.pg_namespace n where d.relname = E'polygons_bng5365' and n.nspname = E'planning' and n.oid = d.relnamespace and d.oid = i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by i.indisprimary desc, i.indisunique, n.nspname, c.relname
  68. 2014-02-16 10:36:21 UTC LOG:  statement: select "app_ref", "id", "MI_PRINX", "MI_STYLE", public.ST_AsBinary("SP_GEOMETRY") as "SP_GEOMETRY" from "sdw"."planning"."polygons_bng5365"
  69. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 64604) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  70. 2014-02-16 10:36:21 UTC LOG:  statement: select 1 from pg_views where schemaname = 'planning' and viewname = 'polygons_bng5365'
  71. 2014-02-16 10:36:21 UTC LOG:  statement: select coord_dimension from public.geometry_columns where f_table_schema = 'planning' and f_table_name = 'polygons_bng5365'
  72. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 16754) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  73. 2014-02-16 10:36:21 UTC LOG:  statement: SELECT SPATIALTYPE, TABLENAME, OWNERNAME, SPATIALCOLUMN, DB_X_LL, DB_Y_LL, DB_X_UR, DB_Y_UR, COORDINATESYSTEM, SYMBOL, XCOLUMNNAME, YCOLUMNNAME ,RENDITIONTYPE, RENDITIONCOLUMN, RENDITIONTABLE,NUMBER_ROWS,VIEW_X_LL, VIEW_Y_LL, VIEW_X_UR, VIEW_Y_UR FROM "mapinfo"."mapinfo_mapcatalog" WHERE TABLENAME = 'polygons_bng5365' AND OWNERNAME = 'planning'
  74. 2014-02-16 10:36:21 UTC LOG:  statement: select 1 from pg_views where schemaname = 'planning' and viewname = 'polygons_bng5365'
  75. 2014-02-16 10:36:21 UTC LOG:  statement: select find_srid('planning', 'polygons_bng5365', 'SP_GEOMETRY')
  76. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like E'polygons_bng5365' and n.nspname like E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  77. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'polygons_bng5365' and u.nspname = E'planning'
  78. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname = E'polygons_bng5365' and n.nspname = E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  79. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname, c.relhasrules, n.nspname, c.oid, d.relhasoids from pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a, pg_catalog.pg_namespace n where d.relname = E'polygons_bng5365' and n.nspname = E'planning' and n.oid = d.relnamespace and d.oid = i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by i.indisprimary desc, i.indisunique, n.nspname, c.relname
  80.  
  81. 2014-02-16 10:36:21 UTC LOG:  statement: select "app_ref", "id", "MI_PRINX", "MI_STYLE", public.ST_AsBinary("SP_GEOMETRY") as "SP_GEOMETRY" from "sdw"."planning"."polygons_bng5365"
  82.  
  83. 2014-02-16 10:36:21 UTC LOG:  statement: select 1 from pg_views where schemaname = 'planning' and viewname = 'polygons_bng5365'
  84. 2014-02-16 10:36:21 UTC LOG:  statement: select coord_dimension from public.geometry_columns where f_table_schema = 'planning' and f_table_name = 'polygons_bng5365'
  85. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'polygons_bng5365' and u.nspname = E'planning'
  86. 2014-02-16 10:36:21 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname = E'polygons_bng5365' and n.nspname = E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  87. 2014-02-16 10:36:21 UTC LOG:  statement: select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname, c.relhasrules, n.nspname, c.oid, d.relhasoids from pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a, pg_catalog.pg_namespace n where d.relname = E'polygons_bng5365' and n.nspname = E'planning' and n.oid = d.relnamespace and d.oid = i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by i.indisprimary desc, i.indisunique, n.nspname, c.relname
  88. 2014-02-16 10:36:21 UTC LOG:  statement: select "app_ref", "id", "MI_PRINX", "MI_STYLE", public.ST_AsBinary("SP_GEOMETRY") as "SP_GEOMETRY" from "sdw"."planning"."polygons_bng5365"  where "polygons_bng5365"."MI_PRINX" = NULL
  89. 2014-02-16 10:36:21 UTC LOG:  statement: SELECT "polygons_bng5365"."MI_PRINX" from "sdw"."planning"."polygons_bng5365" WHERE "polygons_bng5365"."MI_PRINX" >= 0 ORDER BY "polygons_bng5365"."MI_PRINX"
  90. 2014-02-16 10:36:21 UTC LOG:  statement: SELECT max("MI_PRINX") from "sdw"."planning"."polygons_bng5365"
  91. 2014-02-16 10:36:21 UTC LOG:  statement: select "app_ref", "id", "MI_PRINX", "MI_STYLE", public.ST_AsBinary("SP_GEOMETRY") as "SP_GEOMETRY" from "sdw"."planning"."polygons_bng5365"  where "polygons_bng5365"."MI_PRINX" = 1
  92.  
  93. -- mapinfo access to ogr table
  94.  
  95. 2014-02-16 10:36:36 UTC LOG:  statement: SELECT SPATIALTYPE, TABLENAME, OWNERNAME, SPATIALCOLUMN, DB_X_LL, DB_Y_LL, DB_X_UR, DB_Y_UR, COORDINATESYSTEM, SYMBOL, XCOLUMNNAME, YCOLUMNNAME ,RENDITIONTYPE, RENDITIONCOLUMN, RENDITIONTABLE,NUMBER_ROWS,VIEW_X_LL, VIEW_Y_LL, VIEW_X_UR, VIEW_Y_UR FROM "mapinfo"."mapinfo_mapcatalog" WHERE TABLENAME = 'polygons_ogr_28777' AND OWNERNAME = 'planning'
  96. 2014-02-16 10:36:36 UTC LOG:  statement: select 1 from pg_views where schemaname = 'planning' and viewname = 'polygons_ogr_28777'
  97. 2014-02-16 10:36:36 UTC LOG:  statement: select find_srid('planning', 'polygons_ogr_28777', 'wkb_geometry')
  98. 2014-02-16 10:36:36 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like E'polygons_ogr_28777' and n.nspname like E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  99. 2014-02-16 10:36:36 UTC LOG:  statement: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'polygons_ogr_28777' and u.nspname = E'planning'
  100. 2014-02-16 10:36:36 UTC LOG:  statement: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname = E'polygons_ogr_28777' and n.nspname = E'planning') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum
  101. 2014-02-16 10:36:36 UTC LOG:  statement: select c.relname, i.indkey, i.indisunique, i.indisclustered, a.amname, c.relhasrules, n.nspname, c.oid, d.relhasoids from pg_catalog.pg_index i, pg_catalog.pg_class c, pg_catalog.pg_class d, pg_catalog.pg_am a, pg_catalog.pg_namespace n where d.relname = E'polygons_ogr_28777' and n.nspname = E'planning' and n.oid = d.relnamespace and d.oid = i.indrelid and i.indexrelid = c.oid and c.relam = a.oid order by i.indisprimary desc, i.indisunique, n.nspname, c.relname
  102.  
  103. 2014-02-16 10:36:36 UTC ERROR:  zero-length delimited identifier at or near """" at character 74
  104. 2014-02-16 10:36:36 UTC STATEMENT:  select "ogc_fid", "app_ref", "id", "sdw"."planning"."polygons_ogr_28777"."", public.ST_AsBinary("wkb_geometry") as "wkb_geometry" from "sdw"."planning"."polygons_ogr_28777"
RAW Paste Data
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
 
Top