• Tom Lane's avatar
    Repair problem identified by Olivier Prenant: ALTER DATABASE SET search_path · 9bd681a5
    Tom Lane authored
    should not be too eager to reject paths involving unknown schemas, since
    it can't really tell whether the schemas exist in the target database.
    (Also, when reading pg_dumpall output, it could be that the schemas
    don't exist yet, but eventually will.)  ALTER USER SET has a similar issue.
    So, reduce the normal ERROR to a NOTICE when checking search_path values
    for these commands.  Supporting this requires changing the API for GUC
    assign_hook functions, which causes the patch to touch a lot of places,
    but the changes are conceptually trivial.
    9bd681a5
variable.c 18.8 KB