[postgis-users] Vacuum analyse ERROR: Operation on two GEOMETRIESwith different SRIDs
Mark Cave-Ayland
m.cave-ayland at webbased.co.uk
Wed Jun 15 03:09:10 PDT 2005
> -----Original Message-----
> From: Sergey Karin [mailto:sergey.karin at gmail.com]
> Sent: 15 June 2005 10:50
> To: Mark Cave-Ayland (External)
> Subject: Re: [postgis-users] Vacuum analyse ERROR: Operation
> on two GEOMETRIESwith different SRIDs
(cut)
> ogc1=# vacuum;
> VACUUM
> ogc1=# analyse verbose;
> INFO: analyzing "information_schema.sql_features"
> INFO: "sql_features": 5 pages, 360 rows sampled, 360
> estimated total rows
> INFO: analyzing "information_schema.sql_implementation_info"
> INFO: "sql_implementation_info": 1 pages, 12 rows sampled,
> 12 estimated total rows
> INFO: analyzing "information_schema.sql_languages"
> INFO: "sql_languages": 1 pages, 2 rows sampled, 2 estimated
> total rows
> INFO: analyzing "information_schema.sql_packages"
> INFO: "sql_packages": 1 pages, 10 rows sampled, 10 estimated
> total rows
> INFO: analyzing "information_schema.sql_sizing"
> INFO: "sql_sizing": 1 pages, 23 rows sampled, 23 estimated total rows
> INFO: analyzing "information_schema.sql_sizing_profiles"
> INFO: "sql_sizing_profiles": 0 pages, 0 rows sampled, 0
> estimated total rows
> INFO: analyzing "pg_catalog.pg_shadow"
> INFO: "pg_shadow": 1 pages, 4 rows sampled, 4 estimated total rows
> INFO: analyzing "pg_catalog.pg_constraint"
> INFO: "pg_constraint": 32 pages, 976 rows sampled, 976
> estimated total rows
> INFO: analyzing "pg_catalog.pg_database"
> INFO: "pg_database": 1 pages, 41 rows sampled, 41 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_description"
> INFO: "pg_description": 13 pages, 1543 rows sampled, 1543
> estimated total rows
> INFO: analyzing "pg_catalog.pg_group"
> INFO: "pg_group": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "pg_catalog.pg_proc"
> INFO: "pg_proc": 95 pages, 2048 rows sampled, 2048 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_rewrite"
> INFO: "pg_rewrite": 6 pages, 61 rows sampled, 61 estimated total rows
> INFO: analyzing "public.type_object"
> INFO: "type_object": 1 pages, 9 rows sampled, 9 estimated total rows
> INFO: analyzing "public.layer_workspace"
> INFO: "layer_workspace": 1 pages, 28 rows sampled, 28
> estimated total rows
> INFO: analyzing "public.pen"
> INFO: "pen": 2 pages, 210 rows sampled, 210 estimated total rows
> INFO: analyzing "public.text_caption"
> INFO: "text_caption": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "pg_catalog.pg_type"
> INFO: "pg_type": 18 pages, 883 rows sampled, 883 estimated total rows
> INFO: analyzing "pg_catalog.pg_attribute"
> INFO: "pg_attribute": 158 pages, 3000 rows sampled, 9638
> estimated total rows
> INFO: analyzing "pg_catalog.pg_class"
> INFO: "pg_class": 27 pages, 1360 rows sampled, 1360
> estimated total rows
> INFO: analyzing "pg_catalog.pg_inherits"
> INFO: "pg_inherits": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "pg_catalog.pg_index"
> INFO: "pg_index": 18 pages, 603 rows sampled, 603 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_operator"
> INFO: "pg_operator": 12 pages, 616 rows sampled, 616
> estimated total rows
> INFO: analyzing "pg_catalog.pg_opclass"
> INFO: "pg_opclass": 2 pages, 73 rows sampled, 73 estimated total rows
> INFO: analyzing "pg_catalog.pg_am"
> INFO: "pg_am": 1 pages, 4 rows sampled, 4 estimated total rows
> INFO: analyzing "pg_catalog.pg_amop"
> INFO: "pg_amop": 2 pages, 245 rows sampled, 245 estimated total rows
> INFO: analyzing "pg_catalog.pg_amproc"
> INFO: "pg_amproc": 1 pages, 85 rows sampled, 85 estimated total rows
> INFO: analyzing "pg_catalog.pg_language"
> INFO: "pg_language": 1 pages, 4 rows sampled, 4 estimated total rows
> INFO: analyzing "pg_catalog.pg_largeobject"
> INFO: "pg_largeobject": 0 pages, 0 rows sampled, 0 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_aggregate"
> INFO: "pg_aggregate": 1 pages, 65 rows sampled, 65 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_trigger"
> INFO: "pg_trigger": 76 pages, 1850 rows sampled, 1850
> estimated total rows
> INFO: analyzing "pg_catalog.pg_listener"
> INFO: "pg_listener": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "pg_catalog.pg_cast"
> INFO: "pg_cast": 2 pages, 182 rows sampled, 182 estimated total rows
> INFO: analyzing "pg_catalog.pg_namespace"
> INFO: "pg_namespace": 1 pages, 17 rows sampled, 17 estimated
> total rows
> INFO: analyzing "pg_catalog.pg_conversion"
> INFO: "pg_conversion": 2 pages, 114 rows sampled, 114
> estimated total rows
> INFO: analyzing "pg_catalog.pg_depend"
> INFO: "pg_depend": 83 pages, 3000 rows sampled, 12035
> estimated total rows
> INFO: analyzing "pg_catalog.pg_attrdef"
> INFO: "pg_attrdef": 15 pages, 389 rows sampled, 389
> estimated total rows
> INFO: analyzing "public.type_semantic"
> INFO: "type_semantic": 1 pages, 2 rows sampled, 2 estimated
> total rows
> INFO: analyzing "public.s_table_111"
> INFO: "s_table_111": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_111"
> INFO: "t_table_111": 19 pages, 235 rows sampled, 235
> estimated total rows
> INFO: analyzing "public.symbol"
> INFO: "symbol": 1 pages, 82 rows sampled, 82 estimated total rows
> INFO: analyzing "public.brush"
> INFO: "brush": 1 pages, 98 rows sampled, 98 estimated total rows
> INFO: analyzing "public.geom_type"
> INFO: "geom_type": 1 pages, 7 rows sampled, 7 estimated total rows
> INFO: analyzing "public.node"
> INFO: "node": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.s_table_106"
> INFO: "s_table_106": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_106"
> INFO: "t_table_106": 19 pages, 235 rows sampled, 235
> estimated total rows
> INFO: analyzing "public.srs_rus"
> INFO: "srs_rus": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.system_table"
> INFO: "system_table": 1 pages, 1 rows sampled, 1 estimated total rows
> INFO: analyzing "public.s_table_105"
> INFO: "s_table_105": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_105"
> INFO: "t_table_105": 19 pages, 235 rows sampled, 235
> estimated total rows
> INFO: analyzing "public.s_table_104"
> INFO: "s_table_104": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_104"
> INFO: "t_table_104": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.s_table_103"
> INFO: "s_table_103": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_103"
> INFO: "t_table_103": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.raster_type"
> INFO: "raster_type": 1 pages, 1 rows sampled, 1 estimated total rows
> INFO: analyzing "public.s_table_102"
> INFO: "s_table_102": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_102"
> INFO: "t_table_102": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.s_table_101"
> INFO: "s_table_101": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_101"
> INFO: "t_table_101": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.geometry_columns"
> INFO: "geometry_columns": 2 pages, 83 rows sampled, 83
> estimated total rows
> INFO: analyzing "public.s_table_99"
> INFO: "s_table_99": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_99"
> INFO: "t_table_99": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.raster_workspace"
> INFO: "raster_workspace": 0 pages, 0 rows sampled, 0
> estimated total rows
> INFO: analyzing "public.raster"
> INFO: "raster": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.s_table_98"
> INFO: "s_table_98": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_98"
> INFO: "t_table_98": 1 pages, 1 rows sampled, 1 estimated total rows
> INFO: analyzing "public.simple_pen"
> INFO: "simple_pen": 2 pages, 154 rows sampled, 154 estimated
> total rows
> INFO: analyzing "public.pen_simple_pen"
> INFO: "pen_simple_pen": 4 pages, 483 rows sampled, 483
> estimated total rows
> INFO: analyzing "public.scale"
> INFO: "scale": 1 pages, 41 rows sampled, 41 estimated total rows
> INFO: analyzing "public.layer_scale"
> INFO: "layer_scale": 7 pages, 1394 rows sampled, 1394
> estimated total rows
> INFO: analyzing "public.s_table_97"
> INFO: "s_table_97": 6 pages, 610 rows sampled, 610 estimated
> total rows
> INFO: analyzing "public.t_table_97"
> INFO: "t_table_97": 26 pages, 305 rows sampled, 305
> estimated total rows
> INFO: analyzing "public.vendor"
> INFO: "vendor": 1 pages, 3 rows sampled, 3 estimated total rows
> INFO: analyzing "public.s_table_96"
> INFO: "s_table_96": 6 pages, 554 rows sampled, 554 estimated
> total rows
> INFO: analyzing "public.t_table_96"
> INFO: "t_table_96": 23 pages, 277 rows sampled, 277
> estimated total rows
> INFO: analyzing "public.raster_symbol"
> INFO: "raster_symbol": 2 pages, 55 rows sampled, 55
> estimated total rows
> INFO: analyzing "public.s_table_95"
> INFO: "s_table_95": 6 pages, 554 rows sampled, 554 estimated
> total rows
> INFO: analyzing "public.vector_symbol"
> INFO: "vector_symbol": 1 pages, 38 rows sampled, 38
> estimated total rows
> INFO: analyzing "public.t_table_95"
> INFO: "t_table_95": 23 pages, 277 rows sampled, 277
> estimated total rows
> INFO: analyzing "public.s_table_90"
> INFO: "s_table_90": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.t_table_90"
> INFO: "t_table_90": 0 pages, 0 rows sampled, 0 estimated total rows
> INFO: analyzing "public.workspace"
> INFO: "workspace": 1 pages, 15 rows sampled, 15 estimated total rows
> ERROR: Operation on two GEOMETRIES with different SRIDs
Hi Sergey,
The only way I can see that this would fail is that you have a geometry
column in your workspace table which contains geometries of different SRIDs.
Could you also try the following in psql:
\d public.workspace
And then for each column of type geometry (X) in public.workspace can you
do:
select getSRID(X) from public.workspace GROUP BY getSRID(X);
Kind regards,
Mark.
(BTW don't forget to CC to the postgis-users list when replying as it
enables other users to help solve the problem)
------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT
T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk
More information about the postgis-users
mailing list