[postgis-tickets] [PostGIS] #1959: Upgrading with extensions getting a row is too big

[PostGIS]

#1959: Upgrading with extensions getting a row is too big
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  blocker                |   Milestone:  PostGIS 2.1.0
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Comment(by robe):

 I think Tom might have hit the nail on head.
 http://archives.postgresql.org/pgsql-bugs/2012-12/msg00159.php

 "Hm ... pg_extension does not have a TOAST table.  Could the extconfig
 and extcondition fields be getting bloated unreasonably?  If I
 understand the scenario here, this would require (1) the extension
 contains a configuration table (probably one with a filter condition)
 and (2) for some reason the repeated updates are adding, not replacing,
 entries for the table in these columns.

 If that's the story it would be easy to verify by watching the
 extension's pg_extension entry as you repeatedly upgrade it."

   It's my spatial ref condition that is probably causing this. The
 extcondition array is increasing 1 each time I run the upgrade.



 {{{
 CREATE EXTENSION postgis;
 select array_upper(extcondition,1) from pg_extension where extname =
 'postgis';

 -- 1

 ALTER EXTENSION postgis UPDATE TO "2.1.0SVNnext";

 select array_upper(extcondition,1) from pg_extension where extname =
 'postgis';

 -- 2


 ALTER EXTENSION postgis UPDATE TO "2.1.0SVN";

 select array_upper(extcondition,1) from pg_extension where extname =
 'postgis';

 -- 3


 ALTER EXTENSION postgis UPDATE TO "2.1.0SVNnext";

 ERROR:  row is too big: size 9272, maximum size 8160
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1959#comment:7>
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.