`string_to_table` fails with Postgres < 14

developmentseed / tipg

Simple and Fast Geospatial OGC Features and Tiles API for PostGIS.

https://developmentseed.org/tipg/

MIT License

150 stars 22 forks source link

`string_to_table` fails with Postgres < 14 #67

Closed yoninachmany closed 11 months ago

yoninachmany commented 1 year ago

asyncpg.exceptions.UndefinedFunctionError: function string_to_table(text, unknown) does not exist
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

https://github.com/developmentseed/tipg/blob/main/tipg/sql/dbcatalog.sql#L131-L139

Result of running uvicorn tipg.main:app

vincentsarago commented 1 year ago

string_to_table was added in postgres 14 😓 (https://pgpedia.info/s/string_to_table.html)

cc @bitner