Opened 2 years ago

Closed 2 years ago

#5196 closed defect (fixed)

CREATE EXTENSION script for postgis_tiger_geocoder should use CREATE FUNCTION

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.3.0
Component: tiger geocoder Version: 2.5.x -- EOL
Keywords: Cc:

Description

Right now it uses CREATE OR REPLACE FUNCTION. However since CREATE EXTENSION there should be none of these functions existing, it should do a CREATE FUNCTION instead to prevent overwriting of user functions and also hacker exploits.

This is breaking it out of #5165.

Change History (2)

comment:1 by Regina Obe <lr@…>, 2 years ago

In 523502d/git:

Change address_standardizer and postgis_tiger_geocoder
CREATE EXTENSION to use CREATE instead of CREATE OR REPLACE.
References #5195 and #5196 for PostGIS 3.3.0

comment:2 by robe, 2 years ago

Milestone: PostGIS 2.5.8 → PostGIS 3.3.0
Resolution: → fixed
Status: new → closed
Note: See TracTickets for help on using tickets.