[mapguide-users] OGR and PostgreSQL...can't see data in table

[Frank Warmerdam]

Maciej Skorczewski wrote:
>  hi Frank!
> 
>> Is this a postgis enabled postgres instance?  Have you tried standalone
>> OGR tools like ogrinfo to see if they work?
> 
> this is my screen
> http://img229.imageshack.us/img229/7584/18484476su0.jpg
> 
> as you see i  connect to postgres (whit posgis) but can't see any data.
> when i make this whit postgis provider
> http://img229.imageshack.us/img229/7152/57120207tc7.jpg
> i see data... but can't get join.
> http://img229.imageshack.us/img229/6307/22nl8.jpg
> 
> 
> how can i check/try this whit  ogrinfo ?

Maciej,

If you have a postgis enabled ogrinfo, you would do something like:

ogrinfo -ro \
   "PG:host=localhost user=postgres dbname=ch2 password=yourpassword" \
   ulice

You would basically be checking to see if it reports any actual feature
data or not.  If so, then the issue is apparently related to the FDO OGR
provider (or mapguide).  If it reports no features then the issue is
in the OGR Postgres driver.

The Win32 FWTools builds should include a postgres enabled ogrinfo.

   http://fwtools.maptools.org/

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org