H i On Tue, Aug 6, 2013 at 7:31 PM, Christian H. Bruhn <br...@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. > > 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.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community>
