[postgis-tickets] [PostGIS] #2982: Crashing on PostgreSQL9.5 dev on topology

[PostGIS]

#2982: Crashing on PostgreSQL9.5 dev on topology
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  strk              
     Type:  defect          |      Status:  new               
 Priority:  blocker         |   Milestone:  PostGIS PostgreSQL
Component:  topology        |     Version:  trunk             
 Keywords:  postgresql 9.5  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 Okay this test that doesn't involve postgis at all seems to crash also
 which points the finger at 9.5:


 {{{
 CREATE OR REPLACE FUNCTION crash_test(table_name varchar, column_name
 varchar)
   RETURNS bigint AS
 $$
 DECLARE
  var_result bigint;
 BEGIN
        EXECUTE 'ALTER TABLE ' || quote_ident(table_name) || ' ADD COLUMN '
 || quote_ident(column_name) || ' text;';
        var_result = (random()*100000)::bigint;
        RETURN var_result;
 END
 $$
   LANGUAGE plpgsql VOLATILE
   COST 100;

 DROP TABLE IF EXISTS test_1;
 CREATE TABLE test_1(id serial primary key);
 DROP TABLE IF EXISTS test_crash;
 CREATE TEMP TABLE test_crash AS
 SELECT 1 As id, crash_test('test_1', 'lyr1') As layer;

 INSERT INTO test_crash(id, layer)
 SELECT id + 1, crash_test('test_1', 'lyr' || (id + 1)::text)
 FROM test_crash
 WHERE id = 1;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2982#comment:10>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.