search

mapbox / postgis-vt-util

postgres helper functions for making vector tiles
BSD 3-Clause "New" or "Revised" License
273 stars 63 forks source link

Search path #21

Open thesocialdev opened 6 years ago

thesocialdev commented 6 years ago

This PR is about calling the pg_catalog schema explicitly to protect the Database's Search Path as suggested by PostgreSQL documentation:

If you write your queries with specific schema.object form, including objects that exist in the pg_catalog (e.g. calling SELECT pg_catalog.lower('ALICE');), then you are not immediately vulnerable to this issue.