search

stac-utils / pgstac

Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL
MIT License
146 stars 34 forks source link

`_where` and `orderby` fields not being populated in `search` table, `search_wheres` not populated at all #292

Open zstatmanweil opened 2 months ago

zstatmanweil commented 2 months ago

I am running pgstac v0.9.1 and I am just noticing that none of the _where or orderby fields are populating in the search table, and the search_wheres is not being populated at all. I have been successfully using this backend with stac-fastapi, but didn't notice until I tried to deploy titiler-pgstac, which threw a pydantic error when trying to return the search as JSON.

I have tested this both in my deployed database and the v0.9.1 docker container and found this to be the case in both instances.

I originally opened an issue in titiler-pgstac but after digging in, I believe the issue is happening here. See https://github.com/stac-utils/titiler-pgstac/issues/169 for more context.

fyi @vincentsarago

nprovost-ctrees commented 1 month ago

@vincentsarago I'm still getting this error as well.

zstatmanweil commented 1 month ago

@nprovost-ctrees , it hasn't been addressed in pgstac yet. If you navigated here from the titiler-pgstac issue per chance it should be fixed in 1.3.1.