[postgis-users] Same tablename, different schema problems

Don Drake don at drakeconsult.com
Wed Nov 17 11:52:34 PST 2004


No, never used it.  I'll take a look at it.

Thanks.

-Don

-----Original Message-----
From: strk at refractions.net [mailto:strk at refractions.net] 
Sent: Wednesday, November 17, 2004 1:48 AM
To: Don Drake
Cc: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Same tablename, different schema problems

On Tue, Nov 16, 2004 at 04:11:28PM -0600, Don Drake wrote:
> OK, I'm at a good spot to upgrade to 0.9 since I need to reload all of our
> data before we add another 10 million rows (points).
> 
> I hope the upgrades get easier since my DB is only getting bigger.
> 
> Thanks.
> 
> -Don

BTW, are you using utils/postgis_restore.pl ?
--strk;

> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> strk at refractions.net
> Sent: Tuesday, November 16, 2004 11:43 AM
> To: Don Drake; PostGIS Users Discussion
> Subject: Re: [postgis-users] Same tablename, different schema problems
> 
> On Tue, Nov 16, 2004 at 11:13:01AM -0600, Don Drake wrote:
> > In my development database, running PostGIS version  (0.8 USE_GEOS=1
> > USE_PROJ=1 USE_STATS=1) I created a new schema to test some table
> > partitioning.
> > 
> > I created a copy of a table in another schema with the same table
> > name.  I was able to create the table, run addGeometry passing in the
> > schema name, etc.   All was good until I ran  update_geometry_stats().
> > 
> > I now get the following error message:
> > ERROR:  more than one row returned by a subquery used as an expression
> > 
> > If I rename the table in the test schema, the error message goes away.
> >  Is this a known problem?
> > 
> > Thanks.
> > 
> > -Don
> 
> Don, I think the patch was included in postgis-0.9.
> What you can try is download the package, configure and build.
> Then take from postgis.sql just the functions you need:
> 	find_extent(varchar, varchar, varchar);
> 	build_histogram2d(histogram, schema, table, column);
> 	update_geometry_stats();
> 
> Hopefully this kind of upgrades (scripts only) will be easier
> in the future.
> 
> --strk;
> 
> > 
> > -- 
> > Donald Drake
> > President
> > Drake Consulting
> > http://www.drakeconsult.com/
> > 312-560-1574
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users






More information about the postgis-users mailing list