[postgis-users] PostGIS binairy from CVS for Windows Updates

[Dan R Greening]

OK, so a slight correction to Steffen's posting:

You also have to copy 

  postgis.sql
  postgis_undef.sql
  README.postgis
  spatial_ref_sys.sql

from the ZIP file to overwrite the files in

  ...\share\contrib\

And then it works.  At least then the postgis.sql works.

But if I try running my little test script, I get this:

test=# drop table poiloc ;
DROP TABLE
test=# \i test.sql
psql:test.sql:6: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit
index
"poiloc_pkey" for table "poiloc"
CREATE TABLE
CREATE INDEX
CREATE INDEX
INSERT 100605 1
INSERT 100606 1
INSERT 100607 1
INSERT 100608 1
INSERT 100609 1
INSERT 100610 1
INSERT 100611 1
psql:test.sql:16: ERROR:  function addgeometrycolumn(name, "unknown",
"unknown",
 integer, "unknown", integer) does not exist
HINT:  No function matches the given name and argument types. You may need
to ad
d explicit type casts.
psql:test.sql:17: ERROR:  column "geom" of relation "poiloc" does not exist
psql:test.sql:18: ERROR:  column "geom" does not exist
psql:test.sql:19: ERROR:  column "geom" does not exist
test=#

Alas.  Cygwin for me!  :)

Dan Greening, Ph.D.  CEO BigTribe http://dan.greening.name/contact.htm 
 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Dan R Greening
> Sent: Monday, August 16, 2004 9:50 PM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] PostGIS binairy from CVS for 
> Windows Updates
> 
> I got this error:
> 
> C:\Program Files\PostgreSQL\8.0-beta1\share\contrib>psql -f 
> postgis.sql -d poi -U bigtribe
> 
> ...
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:postgis.sql:1863: ERROR:  could not find function 
> "assvg_geometry" in file "C:/Program 
> Files/PostgreSQL/8.0-beta1/lib/libpostgis.dll"
> psql:postgis.sql:1868: ERROR:  current transaction is 
> aborted, commands ignored until end of transaction block ROLLBACK
> 
> Which apparently rolls back everything in postgis.sql.  So I 
> guess this doesn't work?
> 
> Dan Greening, Ph.D.  CEO BigTribe 
> http://dan.greening.name/contact.htm 
>  
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> > Steffen Macke
> > Sent: Monday, August 16, 2004 10:54 AM
> > To: PostGIS Users Discussion
> > Subject: Re: [postgis-users] PostGIS binairy from CVS for Windows 
> > Updates
> > 
> > Dan (and other who would like to fix the crashes of the PostGIS 
> > Windows installer version):
> > 
> > Download the zipfile below.
> > 
> > > As usual You can download it at
> > >
> > > 	
> > 
> http://www.01map.com/download/postgis-082_geos-100_proj-447_assvg.zip
> > 
> > Copy
> > 
> > lib/libgeos.dll
> > lib/libpostgis.dll
> > lib/libproj.dll
> > 
> > from the zipfile over the files of your existing PostGIS 
> installation.
> > You'll find them most probably under
> > c:\program files\PostgreSQL\8.0-beta1\lib
> > 
> > I prefer to release a new installer once PostGIS 0.83 is out. 
> > However, if this will take a long time, I'll create an intermediate 
> > 0.82+cvs version of the installer.
> > 
> > Steffen
> > _______________________________________________
> > 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
>