Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#4518 closed defect (fixed)

Fix geometry_columns and other views

Reported by: pramsey Owned by: pramsey
Priority: medium Milestone: PostGIS 2.3.11
Component: postgis Version: 2.3.x
Keywords: Cc:

Description

Both geometry_columns and raster_columns use SQL against pg_constraint that makes no sense in Pg12, which is usually no problem since we don't support PG12 in 2.4, but does bork up pg_upgrade processes, so those changes and a handful of regression fixes are bundled here.

Change History (5)

comment:1 by pramsey, 4 years ago

Resolution: fixed
Status: newclosed

In 17840:

Backport system views
Closes #4518

comment:2 by robe, 4 years ago

Milestone: PostGIS 2.4.9PostGIS 2.3.11
Resolution: fixed
Status: closedreopened
Version: 2.4.x2.3.x

I think we should do this for 2.3 before we EOL it. So reopening and targetting for 2.3

comment:3 by Regina Obe <lr@…>, 4 years ago

Resolution: fixed
Status: reopenedclosed

In e719d49/git:

Replace use of consrc with pg_get_constraintdef in postgis views, raster functions and views closes #4518 for PostGIS 2.3.11

comment:4 by Regina Obe <lr@…>, 4 years ago

In 4e1e1f4/git:

Replace use of consrc with pg_get_constraintdef from raster functions missed add References #4518 for PostGIS 2.3.11

comment:5 by Regina Obe <lr@…>, 4 years ago

In 22a0333/git:

Add back conname from raster functions References #4518 for PostGIS 2.3.11

Note: See TracTickets for help on using tickets.