[Open.ogc] SQL View error

[Micah Wengren]

Hi John,

Could you include the full SQL query you were trying to use? Tim's right 
about the case sensitivity, although, if your table names are all 
lowercase, you can exclude the double quotes. Double quotes also applies 
to field names as well within the SQL query.  If you're still having 
problems, let us know.

Micah

On 4/18/2013 12:46 PM, Tim Haverland - NOAA Federal wrote:
> John, the database that geoserver is built on (PostGIS), and from my 
> experience the objects are case sensitive. So if you have mixed case 
> in your table names or column names you have to enclose them in double 
> quotes ("select * from "Some_Table_Name").
>
> See if that helps.
>
> Tim
>
>
> On Thu, Apr 18, 2013 at 12:19 PM, John Kennedy - NOAA Affiliate 
> <john.f.kennedy at noaa.gov <mailto:john.f.kennedy at noaa.gov>> wrote:
>
>     Hi,
>
>     I'm getting this: ERROR: relation "us_states_se_gulf" does not
>     exist Position: 30
>     when attempting to create an SQLView in GeoServer
>     (https://services.ogc.noaa.gov
>     <https://services.ogc.noaa.gov/geoserver/nmfs_st/wms?service=WMS&version=1.1.0&request=GetMap&layers=nmfs_st:test_sql_view3&viewparams=colname:Bmu_i_u_d&styles=&bbox=-131.0,30.05,-117.128600366134,48.5060996555303&width=384&height=512&srs=EPSG:4326&format=application/openlayers>).
>     Any suggestions? Thanks in advance!
>
>     Cheers,
>     John
>
>     John F. Kennedy, PhD, CPG
>     GIS Specialist
>     Contractor: Caelum Corp.
>     NOAA Fisheries Office of Science and Technology
>     1315 East-West Highway
>     SSMC3 Rm 9518
>     Silver Spring, MD 20910
>     301-427-8149 <tel:301-427-8149>
>
>     _______________________________________________
>     Open.ogc mailing list
>     Open.ogc at list.woc.noaa.gov <mailto:Open.ogc at list.woc.noaa.gov>
>     https://list.woc.noaa.gov/cgi-bin/mailman/listinfo/open.ogc
>
>
>
>
> -- 
> *Tim Haverland*
> Geospatial Application Developer
> NOAA Fisheries Office of Science and Technology
> 1315 East-West Highway
> SSMC3 Rm 12303
> Silver Spring, MD 20910
> 301-427-8137
>
>
> _______________________________________________
> Open.ogc mailing list
> Open.ogc at list.woc.noaa.gov
> https://list.woc.noaa.gov/cgi-bin/mailman/listinfo/open.ogc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://list.woc.noaa.gov/pipermail/open.ogc/attachments/20130418/ae7fe6a5/attachment-0001.html>