Problems with Postgis-geometries under Windows 7 64 Bit

From: "Christian H(dot) Bruhn" <brogo(at)arcor(dot)de>
To: pgadmin-support(at)postgresql(dot)org
Subject: Problems with Postgis-geometries under Windows 7 64 Bit
Date: 2013-08-06 19:31:11
Message-ID: 1446266094.20130806213111@arcor.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi!

I just installed Postgres 9.2.4 from [1] with the pgAdmin on Windows 7
Prof. 64 Bit. I also installed Postgis 2.0.3-2. I've tried the
installation with the stackbuilder and also the separate download.

Now I have the problem that some data is missing, when displayed in
pgAdmin. The geometry-column for a lot of entries are empty, although
there are data.

To test:
psql -d postgres -U postgres -c "create database test;"
psql -d test -U postgres -c "create extension postgis;"
psql -d test -U postgres -c "CREATE TABLE plz (geom geometry(Geometry,4326), plz bigint NOT NULL, CONSTRAINT pk_plz PRIMARY KEY (plz));"
psql -d test -U postgres -c "CREATE INDEX idx_plz_geom ON plz USING gist(geom);"

Save the data from http://pastebin.com/YTE94ni0 as plz.csv and change
your path in the following line
psql -d test -U postgres -c "COPY plz FROM 'c:\osm\plz.csv' DELIMITER ',' CSV;"

The data contains 18 lines, 16 have a valid geometry, 2 have none.

When you display the table with pgAdmin, only 6 geometries are shown.
For the rest you cannot say if there is no geometry or is it only not
displayed.

If you query
SELECT COUNT (geom) FROM plz;
you will get the correct result: 16.

Exporting via the psql-commandline or using phppgadmin all geometries
are shown. So it must be an error in pgAdmin.

On Ubuntu 12.10 the same test-scenario works fine.

Christian

[1] http://www.enterprisedb.com/products-services-training/pgdownload#windows

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dinesh Kumar 2013-08-07 07:59:44 Re: Problems with Postgis-geometries under Windows 7 64 Bit
Previous Message Dinesh Kumar 2013-08-06 16:46:37 Re: v 1.16.1 incorrectly displays the properties of a FDW table