I just upgraded my development machine to Windows 7 and am therefore reinstalling PostgreSQL and PostGIS. I used the Postgres Plus installer, as recommended on the Postgres website, and followed this tutorial for installation. I created a database using the template_postgis and the application that I am currently developing was able to connect to the database with no problems.
However, my old code is not able to create tables using the PostGIS Geography
like it used to. For example, when I try to create the following table:
CREATE TABLE test_area (
id SERIAL PRIMARY KEY,
name VARCHAR(1000),
area GEOGRAPHY(POLYGON, 4326),
start_time DATE,
end_time DATE
)
I get the following error:
ERROR: type "geography" does not exist
LINE 4: area GEOGRAPHY(POLYGON, 4326),
^
If I look under the database in the Object brower of pgAdmin III, I see a bunch of Geometry
functions, so the installation seems to have run correctly. I'm not sure what my problem might be. Is it possible for the installer to only install PostGIS Geometry
, but not Geography
?
Geography
. I can't figure out how to install PostGIS 1.5 though. When I download the Windows 1-click installer from the Postgres website it only seems to come with PostGIS 1.4. I can download 1.5 binaries from the PostGIS website, but I can't figure out how to install them.Geography
was just added in PostGIS 1.5.