Skip site navigation (1) Skip section navigation (2)

Re: Problem of creating geometry column (linestring)

From: Newperson <useintowngas(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem of creating geometry column (linestring)
Date: 2009-09-22 03:11:03
Message-ID: 25530549.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice

Michael Wood-8 wrote:
> 
> 2009/9/18 Newperson <useintowngas(at)gmail(dot)com>:
> 
> You have a typo in the name of the function.
> I have never done this, but maybe if you fix the typo above it will work?
> 
> -- 
> Michael Wood <esiotrot(at)gmail(dot)com>
> 
> -- 
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
> 
> 
Dear all,

I have fixed the above error.

the sql which works is:

SELECT AddGeometryColumn( 'public', 'pipe', 'pipe_geom', 4269, 'POINT', 2 ); 

I think this part has no typo.

UPDATE pipe
SET pipe_geom = GeometryFromText('LINESTRING('||x1||' '||y1||','||x2||'
'||y2||',
'||x3||' '||y3||','||x4||' '||y4||')' , 4269);

This part cannot work if there is no space between ' '.
-- 
View this message in context: http://www.nabble.com/Problem-of-creating-geometry-column-%28linestring%29-tp25502605p25530549.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


In response to

pgsql-novice by date

Next:From: Bhushan VermaDate: 2009-09-22 05:54:04
Subject: Re: Databse installation problem
Previous:From: Tom LaneDate: 2009-09-22 01:03:56
Subject: Re: Logging Question (SSL)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group