[postgis-users] problems with 2.1.2 and new databases

Paul Ramsey pramsey at cleverelephant.ca
Wed Apr 9 12:48:59 PDT 2014


Well, you had me scared, but it's not an attribute of the 2.1.2
release, it's something specific about either windows or your
installation in particular. After building and installing 2.1.2 on
OSX, I can:


foo=# create extension postgis version '2.1.2';

CREATE EXTENSION

foo=# create table bar (g geography(point, 4326));

CREATE TABLE




On Wed, Apr 9, 2014 at 12:31 PM, jamo3 <jaymoss3 at gmail.com> wrote:
> I updated the script to just use the "extension" method.  Those statements
> run, but when I try to create a table with spatial columns, I get:
> psql:./schema/ntdm/currentBaseline/createNtdmTablesRev301902.sql:36: ERROR:
> type "geography" does not exist
> LINE 34:     location geography(Point,4326)
>                       ^
>
> I'll remove the extension lines and try with just the sql scripts.
>
>
>
> --
> View this message in context: http://postgis.17.x6.nabble.com/problems-with-2-1-2-and-new-databases-tp5006071p5006074.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


More information about the postgis-users mailing list