On Tue, Aug 6, 2013 at 7:31 PM, Christian H. Bruhn <brogo@arcor.de> wrote:
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.
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.