[postgis-users] Using Views as a source of geometric data?

[C F]

Hello,
I didn't see any replies to Vinko's post... I just wanted to add that I too 
am anxiously awaiting any information on this topic.  I did see some 
discussion on this same thing in the Mapserver mailing list archives but I 
didn't really see or understand the conclusion.
At least I think I have the same question as he does.... if so, let me 
phrase it another way...

Can PostGIS views (PostgreSQL views which include the PostGIS geometry 
column) be used as layers in Mapserver?  If so, how?  From what I gather 
from previous posts, it's not as simple as it sounds.

Perhaps this would be better asked on the Mapserver list.  If so, I'll try 
there next.

Thanks!


>From: Vinko Vrsalovic <vinko at cprsig.cl>
>Reply-To: postgis-users at postgis.refractions.net
>To: postgis-users at postgis.refractions.net
>Subject: [postgis-users] Using Views as a source of geometric data?
>Date: Wed, 14 Aug 2002 15:38:50 -0400
>
>
>Hi, I'm using mapscript to access PostGIS layers, and I'd like to
>dynamically create some views to add data to the spatial table. The
>problem is I can't find a way to 'SetGeometryColumn()' from an existing
>View (or table). I have inserted manually the column in
>geometry_columns but mapscript complains that can't create the cursor.
>
>I'm a bit new to both Postgres and PostGIS, so if I'm missing some
>elemental concept here, please forgive me :-)
>
>The other option is altering the spatial table and then add the records,
>but I'm not particularly fond of that solution.
>
>Thanks for any suggestion,
>--
>Vinko Vrsalovic <vinko[|- at -|]cprsig.cl>
>http://www.cprsig.cl
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users






_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com