Turns out we did already have the 2 postgis indices created as well. FWIW.
On 2/27/07, Doug B <[EMAIL PROTECTED]> wrote:
On 2/27/07, Daniel Morissette <[EMAIL PROTECTED]> wrote: > Doug B wrote: > > Ok. I'll return to that. (I take it that also means that getShape() > > is not deprecated in PHP/MapScript?) > > > > Correct. > > > > > One other, possibly related, piece of information is that my postgres > > console window seems to be outputting "ERROR: cursor "mycursor" does > > not exist" every time I execute this query. > > > > Unfortunately I am not a postgis guru, but the following post suggests > that adding an index on OID might help: > > http://postgis.refractions.net/pipermail/postgis-users/2004-June/004982.html Sounds like that may be just a performance issue, not what's actually preventing the data from appearing at all. Thanks, though. I take it you don't have any ideas for me on the root problem? > Daniel > -- > Daniel Morissette > http://www.mapgears.com/ >
