[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