[postgis-tickets] [PostGIS] #5193: mixed qualification of pg_catalog arguments
PostGIS
trac at osgeo.org
Fri Jul 29 01:07:41 PDT 2022
#5193: mixed qualification of pg_catalog arguments
---------------------+---------------------------
Reporter: strk | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.3.0
Component: postgis | Version: master
Keywords: |
---------------------+---------------------------
I stumbled upon this line in postgis.sql:
```
postgis/postgis.sql.in:548:CREATE OR REPLACE FUNCTION
_postgis_selectivity(tbl pg_catalog.regclass, att_name text, geom
geometry, mode text default '2')
```
and wondering why do we qualify "regclass" but not "text"
I don't know what's important to qualify but the inconsistency I don't
understand.
NOTE: I found this out while trying to match the `CREATE OR REPLACE
FUNCTION` lines in our SQL file to what's already present in the database,
comparing against the output of `pg_get_function_identity_arguments`
function which (for the record) NEVER qualifies `pg_catalog`, even if it's
not explicitly in your search_path
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5193>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list