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

H
i

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