[postgis-tickets] [PostGIS] #4231: PostGIS can't build with PostgreSQL v12devel because "pg_constraint.consrc" has been removed

[PostGIS]

#4231: PostGIS can't build with PostgreSQL v12devel because "pg_constraint.consrc"
has been removed
--------------------------+---------------------------
 Reporter:  Laurenz Albe  |      Owner:  pramsey
     Type:  defect        |     Status:  new
 Priority:  medium        |  Milestone:  PostGIS 3.0.0
Component:  postgis       |    Version:  trunk
 Keywords:                |
--------------------------+---------------------------
 PostgreSQL v12 has removed the `pg_constraint.consrc` column in commit
 [https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=96b00c433cd615144a34ff1a79d691d8b297120d
 96b00c43].

 The recommendation is to use [https://www.postgresql.org/docs/current
 /functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE 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.

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