Opened 17 years ago

Last modified 17 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 by pramsey, 17 years ago

Does the svn trunk work any better for you?

comment:2 by cnr643...@…, 17 years ago

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

comment:3 by mcayland, 17 years ago

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 by mcayland, 17 years ago

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.