API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 16th, 2014
203
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 22.55 KB | None | 0 0
raw download clone embed print report
  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"
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!