[postgis-users] [newbie][install] AddGeometryColumn fails ...

Nicolas Ribot nicky666 at gmail.com
Tue Oct 10 06:23:06 PDT 2006


> Hi all, I know it's quite a frequently asked question, but after two
> days of hard search I cannot find any way to make the example
> SELECT AddGeometryColumn('mySchema', 'myTable', 'myColumn', -1,
> 'LINESTRING', 2);
> work.
> I've well loaded the lwpostgis.sql script in my instance, using psql,
> but it didn't change anything.
> For your information, I installed postgres+postgis on Windows XP using
> the 8.1 installer available on postgres website. Of course, I
> activated (or though I did) postGIS at install time as well as at
> database creation.
> What could I have forgotten ?
>

What exactly is returning select addgeometrycolumn(....)
Did you create the table myTable ?
Does it contains data already ?

Nicolas



More information about the postgis-users mailing list