[postgis-devel] Tested postgis_restore.pl

Sandro Santilli strk at keybit.net
Wed Dec 28 14:16:32 PST 2011


On Wed, Dec 28, 2011 at 01:29:16PM -0800, dustymugs wrote:
> On 12/28/2011 01:04 PM, 'Sandro Santilli' wrote:
> >On Wed, Dec 28, 2011 at 11:06:28AM -0800, Bborie Park wrote:
> >>
> >>The default search_path is: userland, postgis, contrib

Your database default ?

> >>On the whole, the script works.  But I'm finding that two PostGIS
> >>1.5 functions are getting through to the userland schema.
> >
> >Only _after_ the call to postgis_restore.pl ?
> 
> Correct.

Could you please pass the -v switch to postgis_restore.pl and
save stderr in a file ? It'd have a log of kept/skipped items.

> >I guess the only way to do that would be dropping the
> >'SET search_path' produced by pg_restore, right ?
> 
> For my setup, I have to alter the search_path to include the other
> two schemas.

Are you modifying the output of postgis_restore.pl ?
How ? And why ?

--strk;

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'




More information about the postgis-devel mailing list