Search Postgresql Archives

Re: Errors when restoring backup created by pg_dumpall

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/5/24 18:44, Ron Johnson wrote:
On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston <david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>> wrote:

    On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx
    <mailto: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 that is set for each database before the objects in that database are created. That means anything that is created subsequently will be have access to all other objects created in the path. This would include objects created indirectly from an extension as well as objects that include non-schema qualified names.


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux