On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:Another alternative is to open the .sql file in Notepad++, then add "public." before all the unqualified "earth" and "ll_to_earth" references.And as discussed there are none in that file because those references are within an extension's objects and only create extension appears in the file.Then why would changing search_path work?
Because (I presume) function inlining during execution of create table keeps the search_path of the session executing create table which will then result in the parser resolving the unqualified “earth” function name to the one existing in the public schema when looking through the session’s search_path.
David J.