Opened 14 years ago

Last modified 14 years ago

#13 closed defect (fixed)

estimated_extent throws "corrupted histogram"

Reported by: cnr643...@… Owned by:
Priority: medium Milestone:
Component: postgis Version:
Keywords: Cc:

Description

What steps will reproduce the problem?

  1. create a table with a geometry column
  2. insert data into the table
  3. run vacuum full analyze tablename
  4. select st_estimated_extent(tableName, geomColumnName)

What is the expected output? What do you see instead? Expected output is a box. Instead an error 'corrupted histogram' is thrown

What version of the product are you using? On what operating system? PostgresQL : 'PostgreSQL 8.3.0 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)' PostGIS : '1.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1' OS: Fedora core 8 (32 bit)

Please provide any additional information below. estimated_extent() works in PostGIS 1.2.

Change History (4)

comment:1 Changed 14 years ago by pramsey

Does the svn trunk work any better for you?

comment:2 Changed 14 years ago by cnr643...@…

I have not used the svn trunk as yet. I will try this and keep you posted. Thanks.

comment:3 Changed 14 years ago by mcayland

I can recreate this bug locally; it's another symptom of the varlena changes in PostgreSQL 8.3, so you will not see this bug with older PostgreSQL versions. Will update this bug when the problem has been found and the issue fixed.

Mark.

comment:4 Changed 14 years ago by mcayland

This should now be fixed in SVN head and will appear in PostGIS 1.3.3. Many thanks for the bug report!

Mark.

Note: See TracTickets for help on using tickets.