[postgis-devel] postgis_restore.pl

[strk]

I've fixed the operator issue.
Current CVS version seems to be pretty usable.
Please test it ( utils/postgis_restore.pl ).
DEBUG is activated by default.
--strk;

On Tue, Aug 03, 2004 at 11:34:45AM +0200, strk wrote:
> On Tue, Aug 03, 2004 at 10:04:46AM +0200, strk wrote:
> > Hi all,
> > I've been working on a postgis restore script.
> > Basically the script extracts the ToC from a dump
> > and skips all objects that will be defined by postgis.sql.
> > Then enables postgis, then restores the dump.
> > 
> > Under the directory utils/ you can find an initial
> > implementation.
> > 
> > Known issues:
> > 
> > 	- operators in the dump are always skipped
> > 	  because from the ToC there's no way to tell
> > 	  wheter or not they belong to postgis.
> > 
> > 	- It seems that when creating tables in schema 'MySchema'
> > 	  pg_restore sets the search path to 'MyScheme', 'pg_catalogue'.
> > 	  This means that postgis constraints will invoke functions
> > 	  unfindable (geometrytype and srid) w/out the 'public' suffix,
> > 	  which is not added :! Any test with this is appreciated.
> 
> I've bypassed the second issue always adding 'public' at the end.
> I've succeeded in restoring a dump from pgsql 7.3 to pgsql 7.4.
> 
> --strk;
> 
> > 
> > --strk;
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel