Error in Estimated_Extent() when used with point geometry

[aroranidh]

What steps will reproduce the problem?

1. Create a Point Table in PostGIS 1.3.5 with PostGRE 8.3
2. SELECT estimated_extent('schema', 'table', 'geometry') AS env
3. Returns ERROR: LWGEOM_estimated_extent: couldn't locate table within

current schema when used on a Point table. But it works fine for line table

What is the expected output? What do you see instead? Extent of the Point table. ERROR: LWGEOM_estimated_extent: couldn't locate table within current schema

What version of the product are you using? On what operating system? PostGIS 1.3.5 with PostGRE 8.3 on Windows XP Professional SP2

Please provide any additional information below. Below attached is the log file generated by MapGUIDE enterprise efition 2009 The Schema name and the table name are perfect.

[mcayland]

Hi,

estimated_extent() can only work after an ANALYZE on the database. What happens if you issue an 'ANALYZE mytable' after 'CREATE mytable ( .. )' and then try using estimated_extent()?

ATB,

Mark.

[aroranidh]

Thnx Mark,

It works after analyze command

[aroranidh]

​http://postgis.googlecode.com/issues/attachment?aid=3815385229419842483&name=mgserver2009_fdopostgis.log

[mcayland]

Closing as 'Won't Fix'.

ATB,

Mark.