Search error on tables with PostGIS fields

Help me!
1

Searching on tables with PostGIS fields returns an error in Forest Admin. Currently looking for a way to exclude fields from general search. Any way to go about this?

Expected behavior

Expect search to work

Actual behavior

Searching in a table returns an error message.

Failure Logs

 [forest] 🌳🌳🌳  Unexpected error: function lower(geography) does not exist
2020-08-20T21:38:47.239139+00:00 app[web.1]: SequelizeDatabaseError: function lower(geography) does not exist
2020-08-20T21:38:47.239139+00:00 app[web.1]:     at Query.formatError (/app/node_modules/sequelize/lib/dialects/postgres/query.js:354:16)
2020-08-20T21:38:47.239140+00:00 app[web.1]:     at /app/node_modules/sequelize/lib/dialects/postgres/query.js:71:18
2020-08-20T21:38:47.239140+00:00 app[web.1]:     at tryCatcher (/app/node_modules/sequelize/node_modules/bluebird/js/release/util.js:16:23)
2020-08-20T21:38:47.239141+00:00 app[web.1]:     at Promise._settlePromiseFromHandler (/app/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:547:31)
2020-08-20T21:38:47.239150+00:00 app[web.1]:     at Promise._settlePromise (/app/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:604:18)
2020-08-20T21:38:47.239150+00:00 app[web.1]:     at Promise._settlePromise0 (/app/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:649:10)
2020-08-20T21:38:47.239150+00:00 app[web.1]:     at Promise._settlePromises (/app/node_modules/sequelize/node_modules/bluebird/js/release/promise.js:725:18)
2020-08-20T21:38:47.239150+00:00 app[web.1]:     at _drainQueueStep (/app/node_modules/sequelize/node_modules/bluebird/js/release/async.js:93:12)
2020-08-20T21:38:47.239151+00:00 app[web.1]:     at _drainQueue (/app/node_modules/sequelize/node_modules/bluebird/js/release/async.js:86:9)
2020-08-20T21:38:47.239151+00:00 app[web.1]:     at Async._drainQueues (/app/node_modules/sequelize/node_modules/bluebird/js/release/async.js:102:5)
2020-08-20T21:38:47.239151+00:00 app[web.1]:     at Immediate.Async.drainQueues [as _onImmediate] (/app/node_modules/sequelize/node_modules/bluebird/js/release/async.js:15:14)
2020-08-20T21:38:47.239152+00:00 app[web.1]:     at processImmediate (internal/timers.js:456:21)

Context

All the latest.

2

Hi @aspectgfg, and welcome to our community!

I don’t have any postgres database with PostGIS compatible field on hand to test this out, so I’m not sure of the expected result.

Does everything works except for the search ? (Like display a record, update it, …). I don’t think we support PostGIS fields initially, so I’m not surprised that some feature are causing you issues.

For the initial question

Currently looking for a way to exclude fields from general search.

We’ve got a part of the doc here covering this topic. Let me know if that helps :pray: