Re: Problems with Postgis-geometries under Windows 7 64 Bit

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

I have just done a quick test case with the given steps, but i am not able to reproduce the case in Cent OS6.0. In CentOS 6, i am getting all the 16 non null grid values and 2 null values. Would you mind to share the query/steps what you have performed in pgAdmin.

Thanks in advance.

Dinesh

-- 
Dinesh Kumar

Software Engineer

Ph: +918087463317

Skype ID: dinesh.kumar432

www.enterprisedb.com

Follow us on Twitter
@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more