The log is showing the same syntax error
2017-02-07 09:27:14 CST [1564-1] terrapop_v1_94_01032017_demo_green ERROR:
syntax error at or near "%" at character 166
2017-02-07 09:27:14 CST [1564-2] terrapop_v1_94_01032017_demo_green
STATEMENT: select * from (select gi_id::text || '_0'::text as fake_id,
gi_id AS id, short_label, geom, feat_label, 0 as zoom from
terrascope.sgl_boundaries_view where sgl_id = %id%
On Wed, Feb 8, 2017 at 7:56 PM, P O'Toole <[email protected]> wrote:
> David -
>
> >I will try switching it to xml and see how that works. Are you sure the
> >> REST isn't skipping the java layer and submitting directly to
> PostgreSQL?
> >Hum... I did not write the REST api, but I cannot see how it might submit
> >direclty to postgresql, makes no sense.
> >Can you also share the request you're sending over?
>
> Have you checked your $PGDATA/pg_log/whatever.log file to see what's
> actually being submitted to Postgres itself? That might offer some clues.
>
> - Patrick O'Toole
>
> Application Developer
> Wyoming Natural Diversity Database
> UW Berry Biodiversity Conservation Center
> Department 3381, 1000 E. University Av.
> Laramie, WY 82071
> P: 307-766-3018
>
--
David Haynes, Ph.D.
Research Associate Terra Populus
Minnesota Population Center
612-626-3933
www.terrapop.org
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
