PostGIS can't build with PostgreSQL v12devel because "pg_constraint.consrc" has been removed

[Laurenz Albe]

PostgreSQL v12 has removed the pg_constraint.consrc column in commit ​96b00c43.

The recommendation is to use ​pg_get_constraintdef instead.

Now PostGIS relies pretty heavily on this column, so it won't work with PostgreSQL v12 any more.

I can try and come up with a fix, but it is not a 5 minute affair, and I will habe little time in the near future, so I thought I'd better alert you.

[robe]

Laurenz thanks for the ticket and commit that broke it.

I'll work on a patch for this. It did hit a lot of pieces in our code base.

Much appreciated.

[robe]

It looks like we might be able to backport it as this was something we should have stopped using a while ago evidentally.

[robe]

In 17030:

Put back deprecated functions removed in r17029, but patch them to use newer pg_get_constraintdef function.
Also mark them as undeprecated cause they are used in other management functions, and it's too messy to change those to use teh raw sql.
We maybe stuck with these forever
Closes #4243 for PostGIS 3.0

Also fix error in raster patching
References #4231 for PostGIS 3.0

[robe]

In 17031:

Revert accidental commit
References #4231 for PostGIS 3.0

[robe]

In 17032:

One more error in raster change - hopefully this is it
References #4231 for PostGIS 3.0

[robe]

In 17049:

Replace pg_constraint.consrc for pg_get_constraintdef fix for topology
References #4231 for PostGIS 3.0.0

[Laurenz Albe]

It builds fine for me now, thanks for the effort!

[robe]

In 17060:

Add 2.2.8 to upgrade targets
Remove using of pg_constraint.consrc to allow support of 12 as noted by Laurenz Albe (pg_constraint.consrc was removed in 12devel)
Closes #4231 for postgis 2.5.2

[robe]

In 17061:

Missed a spot in last commit
Closes #4231 for postgis 2.5.2