[fdo-users] Exception in FDO with PostGIS provider

[gimbrogno at smartlab]

Hi, thanks... yes, Id is primary key...

This is the SQL for table creation

CREATE TABLE puntodemo 
( 
   ogc_fid serial NOT NULL,  
   descrizione varchar(25),
   CONSTRAINT puntodemo_pkey PRIMARY KEY (ogc_fid)
   
); 
select AddGeometryColumn('','puntodemo','the_geom','4326','POINT',2);

I also have inserted two points... If I use QuantumGIS, I can show these
points, but in Mapguide Studio I have an exception :(


zspitzer wrote:
> 
> is ID the primary key?
> 
> On Wed, Jul 2, 2008 at 5:45 PM, gimbrogno @smartlab <magnitudo9 at email.it>
> wrote:
>>
>> Hi all,
>>
>> I am a new FDO user and I have some problems with PostGIS provider. I
>> made a
>> demo table in PostGIS, with an Id (ogr_fid int4), a title (varchar(25))
>> and
>> a geometry column(POINT). When I try to connect Mapguide Studio via FDO,
>> the
>> connection test is OK, Mapguide Studio can find correctly the coordinate
>> system that I used for the table (PostGIS_4326). When I click the
>> preview, I
>> can show the table but when I click "view data" or "view feature" I have
>> this message " An exception occurred in FDO component. The execution of
>> Select command failed. "
>> The FDO libraries are running under a linux System (CentOS 5), and so
>> also
>> MapGuide O.S. 2.0.1.
>>
>> Can anyone helps me? Tanks in advance...
>> --
>> View this message in context:
>> http://www.nabble.com/Exception-in-FDO-with-PostGIS-provider-tp18231998p18231998.html
>> Sent from the FDO Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com (My Blog)
> +61 405 847 168
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Exception-in-FDO-with-PostGIS-provider-tp18231998p18232414.html
Sent from the FDO Users mailing list archive at Nabble.com.