Hi,
I am trying to enter the following sql into the new SQL View Editor.
SELECT
"Regions"."gid" as rgid,
"Regions"."name" as rname,
district_borough_unitary_region.gid,
district_borough_unitary_region."name",
district_borough_unitary_region.area_code,
district_borough_unitary_region.descriptio,
district_borough_unitary_region.file_name,
district_borough_unitary_region."number",
district_borough_unitary_region.number0,
district_borough_unitary_region.unit_id,
district_borough_unitary_region.polygon_id,
district_borough_unitary_region.code,
district_borough_unitary_region.hectares,
district_borough_unitary_region.area,
district_borough_unitary_region.type_code,
district_borough_unitary_region.descript0,
district_borough_unitary_region.type_cod0,
district_borough_unitary_region.descript1,
district_borough_unitary_region.the_geom
FROM
public."Regions" INNER JOIN
public.district_borough_unitary_region
ON ST_Intersects("Regions".the_geom,district_borough_unitary_region.the_geom)
where "Regions"."gid" = 1;
When I run it I get this error
Failed to create SQL view: ERROR: syntax error at or near ";"
Position: 1027
but the same sql works perfectly well in pgAdmin III.
Getting rid of the where clause fixes the problem but I really need to filter
the results since the dataset is too large.
Any Ideas what I may be doing wrong?
Thanks
Farouk A
--- On Thu, 9/9/10, farouk alhassan <osbert252...@yahoo.com> wrote:
From: farouk alhassan <osbert252...@yahoo.com>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: geoserver-users@lists.sourceforge.net
Date: Thursday, 9 September, 2010, 4:16
Hi Justin,
Thanks for the tip. I deleted my whole tomcat installation and installed a new
version and deployed new version of the geoserver war file and the links now
appear.
May have been caused by traces of my previous geoserver war still being held on
to by tomcat.
Thanks for the help. Very much appreciated
Regards
Farouk A
--- On Wed, 8/9/10, Justin Deoliveira <jdeol...@opengeo.org> wrote:
From: Justin Deoliveira <jdeol...@opengeo.org>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: geoserver-users@lists.sourceforge.net
Date: Wednesday, 8 September, 2010, 23:41
Hi Farouk,
It is appreciated if you
can keep all correspondance on the public list. Thanks.
So this seems strange. If you have a postgis store setup and are not seeing the
links when you add a new layer it leads me to believe there is an issue with
the installation. Perhaps some old versions of the geoserver jars around.
Can you navigate to the WEB-INF/lib directory of the geoserver installation and
verify that only 2.1-beta jars are present. What type of setup are you running?
Windows installer? platform independent binary?
On Wed, Sep 8, 2010 at 7:55 PM, farouk alhassan <osbert252...@yahoo.com> wrote:
Hi
I'm trying with PostGIS.
Regards
Farouk A
--- On Wed, 8/9/10, Justin Deoliveira <jdeol...@opengeo.org> wrote:
From: Justin Deoliveira <jdeol...@opengeo.org>
Subject: Re: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new
SQL view
To: "farouk alhassan" <osbert252...@yahoo.com>
Cc: geoserver-users@lists.sourceforge.net
Date: Wednesday, 8 September, 2010, 9:31
Hi Farouk,
Are you trying with arcsde? Or another database?
On Wed, Sep 8, 2010 at 7:06 AM, farouk alhassan <osbert252...@yahoo.com> wrote:
Hi
I am also trying to do the same thing but could not find any of the links
mentioned in the article.
I'm using this document as a guide
http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html
Let me know if you make any progress on it.
Regards
Farouk A
--- On Wed, 8/9/10, sonya.dow...@dpipwe.tas.gov.au
<sonya.dow...@dpipwe.tas.gov.au> wrote:
From: sonya.dow...@dpipwe.tas.gov.au <sonya.dow...@dpipwe.tas.gov.au>
Subject: [Geoserver-users] GeoServer 2.1beta1: unable to configure a new SQL
view
To: geoserver-users@lists.sourceforge.net
Date: Wednesday, 8 September, 2010, 3:16
Hi All,
I have installed GeoServer 2.1-beta1
onto my local PC to try out the new SQL views.
When I go to add new ArcSDE layers,
at the bottom of the page I have the option to create new feature type,
but there is nothing to allow me to configure a new SQL view.
Is there something I missed when installing,
or is this option only available to some databases?
Cheers,
Sonya
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin DeoliveiraOpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Justin DeoliveiraOpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
-----Inline Attachment Follows-----
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-----Inline Attachment Follows-----
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
