[postgis-users] Create View with PostGis table

[Obe, Regina DND\MIS]

Thought something like that.  I suspect the problem is with the OID field.
I think when you create a view with * it doesn't put the OID field in and I
think mapserver needs that, but I'm not running the latest version so this
might have changed.

Try changing your view to 

CREATE VIEW only_pg_land_use AS SELECT oid, *  FROM landusea_region;



-----Original Message-----
From: opengis [mailto:opengis at libero.it]
Sent: Wednesday, November 12, 2003 9:24 AM
To: postgis-users
Subject: RE: [postgis-users] Create View with PostGis table


> I'm confused not sure if you put in the right view definition or a typo or
> what, but the view definition you provided is called
> 
> only_pg_view
> 
> But the view you are trying to use is called 
> 
> only_pg_land_use
> 
> Those 2 should match correct?
Thanks but it is only a cut & past mistake, the problem is always data type
(geometry) lose in CREATE VIEW

 ---
 opengis (at) libero (dot) it
 AOL: open2gis



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users