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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
