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

[robe]

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

[robe]

I'm guessing its broken on 2.5 too.

[robe]

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.

[robe]

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.

[robe]

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.