Do you loaded the data contained in the table used from the view with the
shp2pgsql utility?
If so it does not use the typmod feature for adding the geometry column to
the table, when creating views PostGIS does not populate the
geometry_columns unless you perform a cast on the geoemtry column of the
view.
You may try dropping your view and recreating using a syntax like this:
create view xxx as
select
...
the_geom::geometry(POLYGON,4326) As the_geom
from
...
Of course change the POLYGON according to your shape type
Stefano
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
2013/11/21 Eugenio Trumpy <[email protected]>
> 2.0.3 r11128
>
> ------------------------------
> From: [email protected]
> Date: Thu, 21 Nov 2013 10:55:55 +0100
> Subject: Re: Operation on mixed SRID geometries
> To: [email protected]
> CC: [email protected]; [email protected]
>
>
>
> 2013/11/21 Eugenio Trumpy <[email protected]>
>
> Hi,
> actually the result of that query has srid value = 0
>
>
> So GeoServer can't recognize native SRS.
>
> By the way, which version of PostGIS are you using?
>
> Stefano
>
> ---------------------------------------------------
> 41.95581N 12.52854E
>
>
> http://www.linkedin.com/in/stefanoiacovella
>
> http://twitter.com/#!/Iacovellas
>
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
