Opened 15 years ago

Closed 15 years ago

#474 closed defect (fixed)

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 (2)

comment:1 by ravenAtSafe, 15 years ago

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

comment:2 by pramsey, 15 years ago

Resolution: fixed
Status: newclosed

Fixed in 1.5 at r5624

Fixed in trunk at r5625

Note: See TracTickets for help on using tickets.