On Sat, Jul 10, 2010 at 2:37 AM, PARVEEN ARORA <[email protected]>wrote:
> Dear List,
> Hi
>
> I am unable to create a Geometry table in phpPgAdmin
>
> Firstly i have given the following query to create a table:
>
> CREATE TABLE roads (id INT4, name VARCHAR(128));
>
> It was successful and has create two columns.
> But when i tried to add a coulmn of geometry by following query its not
> working.
>
> SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
>
the error genrated by above query is:
*SQL error:*
ERROR: function addgeometrycolumn(unknown, unknown, integer,
unknown, integer) does not exist
LINE 1: SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
^
HINT: No function matches the given name and argument types.
You might need to add explicit type casts.
* In statement:*
SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
>
> Please tell me how to create a Geometry column.
>
> With Kind Regards
> Parveen Arora
> osmpunjab.co.cc
>
>
--
With Kind Regards
Parveen Arora
osmpunjab.co.cc
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
