Opened 6 years ago

Closed 6 years ago

#4241 closed defect (duplicate)

PostgreSQL 12 build against trunk is broken - pg_constraint.consrc was removed

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 3.0.0
Component: postgis Version: 2.5.x -- EOL
Keywords: Cc:

Description

Failing on raster constraint check

psql:/var/lib/jenkins/workspace/postgis/branches/3.0/regress/00-regress-install/share/contrib/postgis/postgis.sql:6921: ERROR:  column s.consrc does not exist
LINE 3: SELECT replace(replace(split_part(s.consrc, ' = ', 2), ')', ...
                                          ^
HINT:  Perhaps you meant to reference the column "s.conkey" or the column "s.conbin".
-----------------------------------------------------------------------------
make[2]: *** [Makefile:259: check] Error 1
make[2]: Leaving directory '/var/lib/jenkins/workspace/postgis/branches/3.0/regress/core'
make[1]: *** [Makefile:28: check] Error 2
make[1]: Leaving directory '/var/lib/jenkins/workspace/postgis/branches/3.0/regress'
make: *** [GNUmakefile:20: check] Error 1
Build step 'Execute shell' marked build as failure
An attempt to send an e-mail to empty list of recipients, ignored.

I'm guessing they dropped some system columns or renamed them

Change History (4)

comment:1 by robe, 6 years ago

Milestone: PostGIS 3.0.0PostGIS 2.5.2

I'm guessing its broken on 2.5 too.

comment:2 by robe, 6 years ago

Component: rasterpostgis

Okay I think this issue is a problem in both raster and postgis views and the error above is actually coming from postgis insteall, not raster one.

comment:3 by robe, 6 years ago

Milestone: PostGIS 2.5.2PostGIS 3.0.0
Summary: PostgreSQL 12 build against trunk is brokenPostgreSQL 12 build against trunk is broken - pg_constraint.consrc was removed
Version: 2.4.x2.5.x

oh boy oh boy. They seem to have changed the pg_catalog.pg_constraint table structure and all our views and a bunch of our functions are using this consrc column.

I'm tempted to say this might be a big enough change to warrent not backporting which means we'll need to release 3.0 sooner than later.

anyrate it's too deep of a change to try to rush into 2.5.1 release as I had hoped so I guess we'll just have to live with 2.5.1 will be broken for head of PostgreSQL 12.

comment:4 by robe, 6 years ago

Resolution: duplicate
Status: assignedclosed

okay turns out someone already complained about this.

This is a dupe of #4231 which has a solution. So closing this out as a duplicate.

Note: See TracTickets for help on using tickets.