Ticket #474 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Analyzing a table with a "geography" column crashes the PostgreSQL server

Reported by: dtoupin Owned by: pramsey
Priority: medium Milestone: PostGIS 1.5.2
Component: postgis Version: 1.5.X
Keywords: Cc:

Description

To reproduce this problem, simply create a table with a geography column and populate it:

create table geography_crash (geog geography);
insert into geography_crash (geog) VALUES (geography('POINT (1 2)')), (geography('POINT (1 2)'));

and run this SQL query to get the crash:

analyse geography_crash;

Note that you need to have at least two rows to get the crash.

Change History

Changed 3 years ago by ravenAtSafe

If your two points are both (0 0), analyse does does not crash.

Changed 3 years ago by pramsey

  • status changed from new to closed
  • resolution set to fixed

Fixed in 1.5 at r5624

Fixed in trunk at r5625

Note: See TracTickets for help on using tickets.