Nope, this doesn't work right now. But we should try to get it working,
as it may be easier than I thought. The first problem is that our
JDBCDataStore limits the search of available tables to types { "TABLE"
}
So at the least that should be { "TABLE", "VIEW"}. I'm having major
sourceforge troubles right now, so I can't get the update in any time
soon.
We might run into some problems with postgis, with the geometry_columns
table, as we rely on it pretty heavily, and I kind of doubt it's smart
enough to figure out what column a view really is of. Though I could
be wrong. That would just mean that users who really wanted views
would have to add the table by hand.
Chris
Oh wait, you might be right. Sorry, I was thinking of defining the
view
just with the sql statement directly, which mapserver allows you to
do,
without actually calling it a view in the database. You're right,
this
might work, and if it doesn't it probably should. I'll try to test
it
out this afternoon.
Chris
>
>
> Im not sure why this doesn't work already. You should be able to
> specify the name of the view in place of the table and Geoserver
will
> use that view. We shouldn't need to do anything special in
Geoserver
> or Geotools to support this.
>
> Sean
>
> > -----Original Message-----
> > From: cholmes@anonymised.com [mailto:cholmes@anonymised.com]
> > Sent: Thursday, 15 April 2004 2:53 PM
> > To: Katterfeld, Christiane
> > Cc: geoserver-devel@lists.sourceforge.net
> > Subject: Re: [Geoserver-devel] WFS-request on a database view ?
> >
> > > is it possible to put a WFS-request on a database-view
> > (instead of a =
> > > table) ?
> > >
> > > We are using geoserver WFS with postgis. The view is the
> > result of the
> > > = following SQL-Query:=20
> > >
> > > CREATE OR REPLACE VIEW public.loesch AS SELECT "ID", "FB",
> > "Name", =
> > > "Beschreibung", "Adresse", "Geb-ID", "Datum", "Beginn",
> > "Ende", layer,
> > > = color, name, strasse, z, zd_farbe, bemerkung, id, the_geom=20
> > > FROM (test_veranstaltungen LEFT JOIN unigebaeude ON =
> > > ((test_veranstaltungen."Geb-ID" =3D unigebaeude.id )));=20
> > >
> > > (One table contains geometry and the other one contains no
> geometry.
> > > =
> > > Both are linked by a key. )
> >
> > No, not yet, I'm sorry. There has been talk of doing such
things,
> but
> > the most you can do right now is limit the columns in a table, so
> that
> > not all attributes of a row are shown. There has been talk of
> doing
> > this, making a 'pass-thru' sql query that you could specify, but
it
> > needs to be done in geotools, and no one has really had the
> motivation
> > to put the time in to code it up and make api changes. But it is
> on
> > our radar, and will be done at some point, just not yet. Sorry.
> >
> > Chris
> >
> >
> >
> >
> > ----------------------------------------------------------
> > This mail sent through IMP: https://webmail.limegroup.com/
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux
> > tutorial presented by Daniel Robbins, President and CEO of GenToo
> > technologies. Learn everything from fundamentals to system
> >
>
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO
of
> GenToo technologies. Learn everything from fundamentals to system
>
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Geoserver-devel mailing list
> Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/