[postgis] Error in creating WKBPolygon by Postgis in Cygwin PostgreSQL

[Hisaji ONO]

 Hi.

  I've got the following errors for.Error in creating WKBPolygon from
WKTMultiPolygon, created by shp2pgml,  by PostGis 0.5.1 in Cygwin PostgreSQL
7.1.2 on WinNT Server 4.0 SP6a (Memory 256MBytes).

> #create table ku2 as select * from ku;
> #alter table ku2 add column geo2_val wkb;
> # update ku2 set geo2_val = asbinary(geo_value,'NDR');
>
> requested NDR
> TopMemoryContext: 24600 total in 3 blocks; 19016 free (30 chunks); 5584
> used
> TopTransactionContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16
> used
> DeferredTriggerXact: 8192 total in 1 blocks; 8176 free (0 chunks); 16
> used
> TransactionCommandContext: 8192 total in 1 blocks; 2712 free (3 chunks);
> 5480 us
> ed
> JunkFilterContext: 3072 total in 2 blocks; 1480 free (0 chunks); 1592
> used
> PlanExprContext: 169071400 total in 3 blocks; 8152 free (8 chunks);
> 169063248 us
> ed
> QueryContext: 8192 total in 1 blocks; 6136 free (6 chunks); 2056 used
> DeferredTriggerSession: 8192 total in 1 blocks; 8176 free (0 chunks); 16
> used
> CacheMemoryContext: 516096 total in 6 blocks; 176952 free (145 chunks);
> 339144 u
> sed
> pg_user: 5120 total in 5 blocks; 912 free (0 chunks); 4208 used
> PortalMemory: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
> MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
> DynaHash: 24576 total in 2 blocks; 6392 free (2 chunks); 18184 used
> ErrorContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used
> ERROR:  Memory exhausted in AllocSetAlloc(169026186)
> ERROR:  Memory exhausted in AllocSetAlloc(169026186)
>

 After above result, nothing created in new wkb column.

And I also have troubles in creating WKBPoint from WKTPolygon. No error
message, but created WKB contained only 0x010180s (01 = little endian, 01 =
WKBPoint, 80=?).

 Please tell me how to solve these?




To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/