[Featureserver] BBOX request throws error for PostGIS

[Josh Livni]

Ed,

Don't change the default srid in PostGIS.py, but do add 'srid=4269' in 
your cfg file.

However, since that's seemingly not the issue anyway, try adding a line 
right above 205 in PostGIS.py that says:
raise Exception (sql % attrs)

And then try again, and paste the exception error back here - it should 
be what the actual select statement looks like (and of course try 
running that select statement directly if you want, to get a little further)

Also, feel free to join in on irc - #featureserver  - if you want 
potential for quicker assistance

  -Josh

Ed Fialkowski wrote:
> Hey Jennifer, thanks for that.  Unfortunately, it didn't work for me.
>
> I'm using SRID 4269, from postGIS:
>     "enforce_srid_the_geom" CHECK (srid(the_geom) = 4269)
>
> so I tried adding SRID into featureserver.cfg and changing postGIS.py to:
>
> def __init__(self, name, srid = 4269, fid = "ogc_fid", geometry =
> "the_geom", order = "", attribute_cols = '*', writable = True,
> **args):
>         DataSource.__init__(self, name, **args)
>
>
> both of them still say:
> An error occurred: current transaction is aborted, commands ignored
> until end of transaction block
>
>   File "/opt/lampp/cgi-bin/featureserver3/FeatureServer/Server.py",
> line 296, in cgiHandler
>     format, content = service.dispatchRequest( params, path_info,
> host, post_data, request_method, accepts )
>   File "/opt/lampp/cgi-bin/featureserver3/FeatureServer/Server.py",
> line 145, in dispatchRequest
>     result = method(action)
>   File "/opt/lampp/cgi-bin/featureserver3/FeatureServer/DataSource/PostGIS.py",
> line 205, in select
>     cursor.execute(str(sql), attrs)
>
> :(
>