[postgis-devel] postgis_restore.pl problem

Sandro Santilli strk at keybit.net
Thu Jan 24 07:51:50 PST 2013


On Thu, Jan 24, 2013 at 04:25:36PM +0100, Daniele Debernardi wrote:
> Hi,
> using the postgis_restore.pl in postgis 2.0.2, I found a problem
> when he rewrite the spatial table constraints (around line ~230),
> he skips geometry columns that has upper case letters and than they
> have double "" around it.
> 
> changing the line:
> if ( $subline =~ /CONSTRAINT enforce_srid_/i ) {
> 
> to:
> if ( $subline =~ /CONSTRAINT enforce_srid_/i || $subline =~
> /CONSTRAINT "enforce_srid_/i) {
> 
> solves the problem considering them too

Could you try this line please:

 if ( $subline =~ /CONSTRAINT "?enforce_srid_/i ) {

--strk;



More information about the postgis-devel mailing list