[postgis-users] INSERT problem

[Kevin Jardine]

I believe that you are missing a set of brackets after MULTIPOLYGON. A 
POLYGON is a list of rings and has two sets of brackets. A MULTIPOLYGON 
is a list of POLYGONs and so has 3 brackets.

Cheers,
Kevin

Guillaume SUEUR (Géosignal) wrote:

> HI there,
> 
> This statement :
> 
> INSERT INTO polysTemp (idSession, taille, couleur, interieur,the_geom) VALUES 
> ('94d91bd4793280a26ba83abe4abc3412','5','33CC00','33FF66','MULTIPOLYGON((526802 
> 154535, 517313 148794, 515240 142414, 521539 139225, 528557 139225, 534139 
> 145604, 532943 152781, 526802 154535))');
> 
> returns
> *Warning*: pg_query(): Query failed: ERROR: couldnt parse object in GEOMETRY
> 
> What's wrong ? It works with MULTILINESTRING on another table.


-- 
Kevin Jardine
New Media Campaigner
Greenpeace International

Tel: + 31205148150 (main switchboard)
Mobile: + 31652062980

Become a cyberactivist!
http://act.greenpeace.org/register