[postgis-users] upgrade postgis

[Cedric BERNIER]

Hello, I try to ugrade my postgis 0.6 to 0.7.2
but when I use :

pg_dump -t "*" -f dumpfile.sql <yourdatabase>

there is an error : Archiver could not set output.

Have I forgot to do something? sure, but what?

Chris Hodgson a écrit :

> Sounds kinda buggy to me... can you send me the table & data?
>
> Chris
>
> Randy.Goss at kimley-horn.com wrote:
>
> > I have an example table that consists of a number of overlapping
> > polygons of various sizes. I am using this table to query features
> > inside of other features; for example, to find all of the features
> > inside of a feature called 'Hillsborough' I run the following query, and
> > receive the following results:
> >
> > QUERY:
> > select name from florida where the_geom~(select the_geom from florida
> > where name='Hillsborough')
> >
> > RESULTS:
> > Plant City
> > Tampa
> > Temple Terrace
> > Ruskin
> > Sun City Center
> > Hillsborough
> >
> > Next, I create a GIST index on the geometry column using the following:
> >
> > create index idx_geo on florida using GIST (the_geom GIST_GEOMETRY_OPS);
> >
> > Re-running the original query now produces the following results:
> >
> > RESULTS:
> > Hillsborough
> >
> > Why does the query return a single value on the indexed table?
> >
> > _______________________________________________
> > 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cedric.bernier.vcf
Type: text/x-vcard
Size: 377 bytes
Desc: Carte pour Cedric BERNIER
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020524/31b8b4b0/attachment.vcf>