[Open.ogc] SQL View error

[Tim Haverland - NOAA Federal]

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> 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
>
> _______________________________________________
> Open.ogc mailing list
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://list.woc.noaa.gov/pipermail/open.ogc/attachments/20130418/662a41e7/attachment.html>