Sorted. Now working. The problem was the primary key of the table. Thanks to the hint of Davide Zizioli, another of this list, I gave OID as primary key and added DATA "the_geom from monumenti_postgis USING UNIQUE oid USING SRID=32733" to the .map to make the connection working.
I made another layer and gave it gid as primary key. It also works. Now i'll try to modify the data, via php, and do multiple queries with search.xml Thanks a lot to all of you. "See" you for my next issue. Stefano Date: Tue, 25 Nov 2008 18:08:56 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: pmapper-users@lists.sourceforge.net Subject: Re: [pmapper-users] problem in connecting to PostGIS layers from p.mapper Stefano Gambini ha scritto: Sorry sure, Postgresql reports the error as 'ERROR: column reference "the_geom" is ambiguous LINE 1: ...SOR FOR SELECT asbinary(force_collection(force_2d(the_geom))... ^ Try to remove the_geom inside the () and left only * this should be work :) I hope W -- Walter Lorenzetti email: [EMAIL PROTECTED] skype: aiki74 Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684 Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca Italy _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users