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?
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!