[postgis-devel] ndims in 1.5 dumps (was: ST_ndims, was Geocoder geometry_columns)

[Paragon Corporation]

Yah I have the task here.

http://trac.osgeo.org/postgis/ticket/1123

The uninstall_legacy.sql could as part of the process search for ndims, srid
in table constraints and replace with the new names before it tries to
uninstall.  Changing to typmod is not feasible nor desireable for all.

For example I have data that I process using PostGIS 2.0 new features, but
then restore back to a 1.5 database.  I am able to get away with this
because the current backup bytea format of 2D stuff is the same.  

Using typmod will make that backward compatible restore impossible since the
create table step would fail since 1.5 doesn't support typmod geometry
tables.Then there are the other cases I have mentioned with non-standard
inheritance where typmod just doesn't work.

Thanks,
Regina

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of Sandro
Santilli
Sent: Friday, July 15, 2011 3:22 AM
To: PostGIS Development Discussion
Subject: [postgis-devel] ndims in 1.5 dumps (was: ST_ndims,was Geocoder
geometry_columns)

On Thu, Jul 14, 2011 at 11:49:50PM -0400, maplabs at light42.com wrote:

>   It appeared to me, without studying the problem, that ndims() was 
> required by the dump/restore even though "all" of the old PostGIS was 
> removed..

Robe was telling me the story about table constraints using ndims.
I belive she mentioned something about providing another .sql script to add
things like ndims and yet another to drop them.
Maybe postgis_restore.pl should take care of sourcing the additional legacy
file to allow for proper restore, run updates of the tables to switch to
typmod and finally run the file dropping the now-useless legacy functions.

Of course this will make the script even more complex than it is..

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel