[postgis-users] Function dos not exist

[Robert Burgholzer]

Kris,
Don't know if you got a resolution on this. If you are on windows, Postgis installs very easily during the actrual Postgresql install, and I believe you can default all new databases to be PG-enabled. 

Once you are certain that PostGIS is installed, if you are still having trouble, you might find that the source of the trouble is that you added a field of type POINT via pgAdminIII. You must use the function AddGeometryColumn (see the postgis reference manual for details) to add geometry columns, the type is specified in the command syntax.

Good luck.

r.b.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Kris Nackaerts
Sent: Sunday, December 04, 2005 4:16 AM
To: PostGIS Users Discussion
Cc: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] Function dos not exist

Forgot to tell I use PostGreSQL 8.1.0, pgAdmin 1.4.0.

I'f I'm correct, PostGis is implemented into this version of postgres so no
extra installations are needed?

Kris

> --- Ursprüngliche Nachricht ---
> Von: "Kris Nackaerts" <knackaerts at gmx.net>
> An: postgis-users at postgis.refractions.net
> Betreff: [postgis-users] Function dos not exist
> Datum: Sun, 4 Dec 2005 10:08:27 +0100 (MET)
> 
> Dear,
> 
> The first time I use PostGis. I created a simple table with X,Y,Z
> coordinates and uploaded 20milj records. Now, i need to create spatial
> points.
> 
> I altered the table via pgAdminIII and added a field of type POINT
> 
> Next, I try to update that field as:
> 
> update dtm_point set mypoint=MakePoint(x,y);
> 
> or
> 
> update dtm_point set mypoint=geometryfromtext('POINT('||x||'
> '||y||')',-1);
> 
> In both cases I get the error that the function does not exist
> 
> As you might see, I'm new to postgis. I tried Google for some hints.
> 
> Any clue is welcome.
> 
> Kris
> 
> -- 
> Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
> Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse für Mail, Message, More +++
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users