[postgis-users] Same tablename, different schema problems

[Don Drake]

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

-----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