[postgis-users] Create View with PostGis table

[chodgson@refractions.net]

Do you really need to use a view? Did you know that it is possible to specify 
more complicated queries in the mapserver config file? 

Read this:

http://postgis.refractions.net/docs/x552.html#AEN610

I don't think you need a view for what you are doing.

Chris

Quoting OpenGis <opengis@libero.it>:

> Thanks every one!
> [1]
> CREATE VIEW only_pg_land_use AS SELECT t0.oid, t0.* FROM landusea_region t0;
> Work fine!
> 
> >My landusea_region table:
> >Field		Type
> >gid 		int4
> >polygon_id 	int8
> >name 		varchar
> >langcode 	varchar
> >type 		varchar
> >city 		varchar
> >the_geom 	geometry
> >
> But it's not enough!
> I found another trouble next step:
> I try to perform view with a condition like:
> [2]
> test=> CREATE VIEW v_pG_w AS SELECT t0.oid, t0.* FROM landusea_region t0
> where gid < 10;
> CREATE VIEW
> or
> [3]
> test=> CREATE VIEW v_land_t AS SELECT t0.oid, t0.*, num_pop FROM
> landusea_region t0, tab_zu where t0.name= tab_zu.nm;
> CREATE VIEW
> 
> -- both run OK in psql & in phpPgAdmin
> 
> Instead doesn't work with this mapfile:
> LAYER
>     NAME LandUseA_region
> #    DATA LandUseA_region                               # original shape
> file -- work fine
>     CONNECTIONTYPE postgis
>     CONNECTION "user=pg_user password=pg_passwd dbname=test host=linux_box"
> #    DATA "the_geom from landusea_region"        # OK (table from shp2pgsql)
> #    DATA "the_geom from only_pg_land_use"     # OK (view from previous
> tab with oid column) [1]
>     DATA "the_geom from v_pg_w"                      # NO ERROR NO
> DISPLAY [2]
> #    DATA "the_geom from v_land_t"                   # NO ERROR NO
> DISPLAY [3]
> 
> When I run mapserver I've map with all layer less LandUseA_region layer
> and It's very strange there isn't any error!?
> 
> It's a big problem because only in [2] I can use FILTER in mapfile, but
> in [3] I need to perform where condition before mapfile in order to
> obtain data from another table.
> 
> I think that where condition lose geometry data type. It's right? How
> can resolve [3]?
> 
> Have you any advice?
> 
> Thanks in advance
> 
> --
> opengis (at) libero (dot) it
> AOL: open2gis
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>