Re: [postgis-users] hard upgrade from 1.5

On Tue, Jan 11, 2022 at 05:45:16PM +, Nathan Wagner wrote: > Could this have been done via 'create extension postgis from unpackaged'? > I think that doesn't work for an in-place upgrade because it can't > handle converting the internal representation. You are right: "create extension from

Re: [postgis-users] hard upgrade from 1.5

> On Jan 11, 2022, at 9:45 AM, Nathan Wagner wrote: > > On Tue, Jan 11, 2022 at 01:18:27AM +0100, Sandro Santilli wrote: >> On Mon, Jan 10, 2022 at 10:18:34AM -0800, Paul Ramsey wrote: On Jan 10, 2022, at 10:01 AM, Nathan Wagner wrote: >>> So, why exactly is a hard upgrade needed

Re: [postgis-users] hard upgrade from 1.5

On Tue, Jan 11, 2022 at 01:18:27AM +0100, Sandro Santilli wrote: > On Mon, Jan 10, 2022 at 10:18:34AM -0800, Paul Ramsey wrote: > > > On Jan 10, 2022, at 10:01 AM, Nathan Wagner wrote: > > > > > So, why exactly is a hard upgrade needed from 1.5 to 2.5? > > > > Because the pg_dump, pre-2.0 would

[postgis-users] Using Spike finder in PostGIS?

Have they ever solved this one? polygon - Using Spike finder in PostGIS? - Geographic Information Systems Stack Exchange Is there one that can offer clarity and simplicity? Regards, David

Re: [postgis-users] How best to create and use associative array type in Postgres?

Hi, Regina, This looks offering some clarity and simplicity. I was told that hstore can also work as associative array. Does it offer clarity and simplicity? Regards, Shao On Sat, 8 Jan 2022 at 04:20, Regina Obe wrote: > Oh forgot one more very useful operator, the subtraction operator. >

Re: [postgis-users] PostGIS problem after updating from 3.1.4 to 3.2.0

Dear Regina, Just running SELECT postgis_extensions_upgrade(); did not work. I reinstalled PostGIS 3.1.4, and verified that it was functional. I then reinstalled 3.2.0 on top of that, this time successfully (not sure why I had to remove 3.1.4 the first time, but...), and then ran SELECT