[postgis-users] long geometries aren't display on pgAdmin (Windows 7, 64bit)

[toni hernández]

hi,

I already tried with psql without any luck. ;-(

Let me explain the issue again  with one example.
When I load a sql, like the one below, on pgAdmin, authomatically the 
geometry disappears from the screen.
But only when the geometry is 'too' long.

The insert seems to work fine but only for the columns rec_num and 
data_value. The_Geom column is always empty, even when executing the SQL 
file from psql.
Example:

SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "kirklees" (gid serial PRIMARY KEY,
"rec_num" numeric,
"data_value" numeric);
SELECT AddGeometryColumn('','kirklees','the_geom','-1','MULTIPOLYGON',2);
INSERT INTO "kirklees" ("rec_num","data_value",the_geom) VALUES 
('1','1','010600000001000000010300000001000000D303000000000000501419410000000030941841000000005014194100000000A092184100000000100E194100000000A092184100000000100E1941000000003094184100000000800C1941000000003094184100000000800C194100000000C095184100000000100E194100000000C095184100000000100E1941000000005097184100000000800C1941000000005097184100000000800C194100000000709A184100000000F00A194100000000709A184100000000F00A194100000000009C184100000000D007194100000000009C184100000000D007194100000000909D184100000000B00419
...

Yves Jacolin wrote:
> Le jeudi 26 mai 2011 08:28:32, toni hernández a écrit :
>   
>> Hi,
>>
>> I amb holding a postgresql+postgis course on www.unigis.es
>> Some of our students have experienced some problems when importing shp.
>> These students are running postgresql 32 bit on a Windows7 64 bit platform.
>> I have run the same import with a windows 7, 64bit but haven't
>> encountered any problems.
>>
>> The shp2pgsql seems to be working fine (the output looks good) but when
>> loading the SQL file from pgAdmin some geometries aren't displayed.
>> I think the longest geometries (not very long indeed) are the ones that
>> are not displayed.
>>
>> Any ideas about what's happening?
>>
>> thanks in advance.
>>     
>
> Hi Toni,
>
> I am not sure to have understood your issue, but I know that PgAdmin have some 
> difficulties to display values of geometry field. If you check it via psql you'll 
> see that all geometry values are in the table.
>
> Y.
>