[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 reported this issue upstream http://archives.postgresql.org/pgsql-
 bugs/2012-12/msg00154.php

 Andres Freund http://archives.postgresql.org/pgsql-
 bugs/2012-12/msg00155.php  suggested I turn on verbosity.  Duh why didn't
 I think of that.
 running this
 {{{
 SET log_error_verbosity = 'verbose';
 ALTER EXTENSION postgis UPDATE TO "2.1.0SVN";
 }}}

 shows this in the log file
 {{{
 2012-12-17 09:15:10 EST LOG:  statement:
         SET log_error_verbosity = 'verbose';
 2012-12-17 09:15:13 EST LOG:  00000: statement: ALTER EXTENSION postgis
           UPDATE TO "2.1.0SVN";
 2012-12-17 09:15:13 EST LOCATION:  exec_simple_query,
 src\backend\tcop\postgres.c:888
 2012-12-17 09:15:15 EST ERROR:  54000: row is too big: size 9272, maximum
 size 8160
 2012-12-17 09:15:15 EST LOCATION:  RelationGetBufferForTuple,
 src\backend\access\heap\hio.c:241
 }}}

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