[postgis-users] pg-dump from postgis 0.8 to 0.9.1

[Ethan Alpert]

Actaully I'm refering to *REMOVING* these when dumping the schema. Loading different versions of postgis.sql causes problems if they are left in the schema.

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of TECHER Jean David
Sent: Wednesday, December 15, 2004 2:29 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1


Hi Ethan

I don't think that's a great idea to dump postgis functions since postgis functions are in a librairy

First of all, dumping implies that you need to updates version so uninstalling old version (postgis, geos and so on...)...

Perhaps some functions could diseappear in a new postgis version (truly_inside(),....)...

I don't want to do errors....
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
K-S:"The greatest trick the devil pulled off was convincing people he didn't exist"
------------------------------------------------------------
----- Original Message -----
From: <strk at refractions.net>
To: "Ethan Alpert" <ealpert at digitalglobe.com>
Cc: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Tuesday, December 14, 2004 8:20 PM
Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1


> On Tue, Dec 14, 2004 at 12:13:16PM -0700, Ethan Alpert wrote:
> >
> > Hey now...that's sweet! Now do you have a select that will filter 
> > out
all the postgis functions when you dump the schema?
> >
> > -e
>
> functions, types, operators, operator classes, aggregates. The more 
> people test it the more we'll get it stable. --strk;
>
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of TECHER Jean David
> > Sent: Tuesday, December 14, 2004 7:48 AM
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1
> >
> >
> > One way
> >
> > In a SQL file (example toto.sql), writes this
> >
> > select 'pg_dump -c -O -t ' || tablename || '  your_database >> dump 
> > .sql
' from pg_tables  where  (tablename not like 'pg_%') and (tablename not like
'sql_%') (tablename not like 'spatial_ref_sys_%')
> >
> > then do
> >
> > psql -d your_database -f toto.sql  > dump.sh
> >
> > dropdb your_database
> > createdb your_database
> > createlang plpgsql your_database
> > psql -d your_database  -f postgis.sql
> > ./dump.sh
> > ----------------------------------------------------------------
> > TECHER Jean David
> > Responsable Informatique 01MAP
> > e-mail: davidtecher at yahoo.fr
> > site perso : http://techer.pascal.free.fr/postgis/
> > site pro: http://www.01map.com/download/
> > K-S:"The greatest trick the devil pulled off was convincing people 
> > he
didn't exist"
> > ------------------------------------------------------------
> > ----- Original Message -----
> > From: "Guillaume SUEUR (Géosignal)" <guillaume.sueur at geosignal.fr>
> > To: "PostGIS Users Discussion" 
> > <postgis-users at postgis.refractions.net>
> > Sent: Tuesday, December 14, 2004 3:37 PM
> > Subject: Re: [postgis-users] pg-dump from postgis 0.8 to 0.9.1
> >
> >
> > > -t pour la table, -d pour les inserts
> > >
> > >
> > > TECHER Jean David wrote:
> > > > ***********************
> > > > Your mail has been scanned by InterScan VirusWall.
> > > > ***********-***********
> > > >
> > > >
> > > > what are options you use with pg_dump???
> > > > ----------------------------------------------------------------
> > > > TECHER Jean David
> > > > Responsable Informatique 01MAP
> > > > e-mail: davidtecher at yahoo.fr
> > > > site perso : http://techer.pascal.free.fr/postgis/
> > > > site pro: http://www.01map.com/download/
> > > > K-S:"The greatest trick the devil pulled off was convincing 
> > > > people he
> > didn't
> > > > exist"
> > > > ------------------------------------------------------------
> > > > ----- Original Message -----
> > > > From: "Guillaume SUEUR (Géosignal)" 
> > > > <guillaume.sueur at geosignal.fr>
> > > > To: "PostGIS Users Discussion"
> > > > <postgis-users at postgis.refractions.net>
> > > > Sent: Tuesday, December 14, 2004 3:29 PM
> > > > Subject: [postgis-users] pg-dump from postgis 0.8 to 0.9.1
> > > >
> > > >
> > > >
> > > >>Hi,
> > > >>
> > > >>I've dumped my database to load it into a new one with postgis 
> > > >>0.9.1. On the psql -d database -f dumpFile.sql, for all spatial 
> > > >>table i've got a 'couldn't parse objetcs in geometry'
> > > >>
> > > >>Any idea ?
> > > >>
> > > >>Thanks
> > > >>--
> > > >>---------------------------
> > > >>Guillaume SUEUR
> > > >>GEOSIGNAL - Groupe BVA
> > > >>25bis Avenue Marcel Dassault
> > > >>31505 TOULOUSE CEDEX 5
> > > >>----------------------------
> > > >>
> > > >>_______________________________________________
> > > >>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
> > > >
> > > >
> > > >
> > > >
> > >
> > > --
> > > ---------------------------
> > > Guillaume SUEUR
> > > GEOSIGNAL - Groupe BVA
> > > 25bis Avenue Marcel Dassault
> > > 31505 TOULOUSE CEDEX 5
> > > ----------------------------
> > >
> > > _______________________________________________
> > > 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
> _______________________________________________
> 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