[postgis-devel] In Place Upgrade

Paul Ramsey pramsey at cleverelephant.ca
Tue Sep 24 10:26:38 PDT 2019


Constraints as a source of geometry_columns metadata hearkens back to 1.x days… any reason not to look at simplifying our *_columns views a little in upcoming releases to just look at typmod?

P

> On Sep 24, 2019, at 10:20 AM, Regina Obe <lr at pcorp.us> wrote:
> 
> We just need to fix the view.  I think you can copy the definition from 2.5 and backport to 2.4.
>  
> Looks like the new function pg_get_constraintdef we are using has existed at least since 9.2 so we should be okay with 2.4 fixing
>  
> https://www.postgresql.org/docs/9.2/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE <https://www.postgresql.org/docs/9.2/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE>
>  
>  
> From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Paul Ramsey
> Sent: Tuesday, September 24, 2019 1:00 PM
> To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> Subject: Re: [postgis-devel] In Place Upgrade
>  
>  
> 
> 
>> On Sep 24, 2019, at 9:58 AM, rmrodriguez at carto.com <mailto:rmrodriguez at carto.com> wrote:
>>  
>>> Already at 2.5.3…
>>> postgis25_11-2.5.3-3.rhel7.x86_64
>> 
>> That's the binary, are the scripts installed in the database at 2.5.3 too?
>  
> Yes, this isn’t a production system, this is a blank (with one spatial table) database created today just to test upgrading against packages.
> 
> 
>> 
>> 
>>> What would fixing 2.4 entail? Is there a ticket I can use to track this down? I think it’s worthwhile, probably.
>> 
>> It was done for 3 and 2.5 in https://trac.osgeo.org/postgis/ticket/4231 <https://trac.osgeo.org/postgis/ticket/4231> 
> Thanks,
>  
> P
> 
> 
>> 
>> 
>> -- 
>> Raúl Marín Rodríguez
>> carto.com <http://carto.com/>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org <mailto:postgis-devel at lists.osgeo.org>
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel <https://lists.osgeo.org/mailman/listinfo/postgis-devel>
>  
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org <mailto:postgis-devel at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/postgis-devel <https://lists.osgeo.org/mailman/listinfo/postgis-devel>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20190924/65576860/attachment-0001.html>


More information about the postgis-devel mailing list