[postgis-tickets] [PostGIS] #4303: Getting this error on many bots -ALTER EXTENSION failing

PostGIS trac at osgeo.org
Mon Jan 21 14:58:06 PST 2019


#4303: Getting this error on many bots -ALTER EXTENSION failing
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 {{{
 17:30:49                                                               ^
 17:30:49 HINT:  Perhaps you meant to reference the column "proc.probin".
 17:30:49 QUERY:  SELECT 'ALTER EXTENSION ' || e.extname || ' DROP ' || $3
 || ' ' || COALESCE(proc.proname || '(' || oidvectortypes(proc.proargtypes)
 || ')' ,typ.typname, cd.relname, op.oprname,
 17:30:49                                        cs.typname || ' AS ' ||
 ct.typname || ') ', opcname, opfname) || ';' AS remove_command
 17:30:49                        FROM pg_depend As d INNER JOIN
 pg_extension As e
 17:30:49                                ON d.refobjid = e.oid INNER JOIN
 pg_class As c ON
 17:30:49                                        c.oid = d.classid
 17:30:49                                        LEFT JOIN pg_proc AS proc
 ON proc.oid = d.objid
 17:30:49                                        LEFT JOIN pg_type AS typ
 ON typ.oid = d.objid
 17:30:49                                        LEFT JOIN pg_class As cd
 ON cd.oid = d.objid
 17:30:49                                        LEFT JOIN pg_operator As
 op ON op.oid = d.objid
 17:30:49                                        LEFT JOIN pg_cast AS ca ON
 ca.oid = d.objid
 17:30:49                                        LEFT JOIN pg_type AS cs ON
 ca.castsource = cs.oid
 17:30:49                                        LEFT JOIN pg_type AS ct ON
 ca.casttarget = ct.oid
 17:30:49                                        LEFT JOIN pg_opclass As oc
 ON oc.oid = d.objid
 17:30:49                                        LEFT JOIN pg_opfamily As
 ofa ON ofa.oid = d.objid
 17:30:49                        WHERE d.deptype = 'e' and e.extname = $1
 and c.relname = $2 AND (proc.prokind = 'a')  = $4;
 17:30:49 CONTEXT:  PL/pgSQL function
 postgis_extension_remove_objects(text,text) line 48 at FOR over EXECUTE
 statement
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4303>
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.


More information about the postgis-tickets mailing list