• Tom Lane's avatar
    Adjust postgres_fdw's search path handling. · 6d060494
    Tom Lane authored
    Set the remote session's search path to exactly "pg_catalog" at session
    start, then schema-qualify only names that aren't in that schema.  This
    greatly reduces clutter in the generated SQL commands, as seen in the
    regression test changes.  Per discussion.
    
    Also, rethink use of FirstNormalObjectId as the "built-in object" cutoff
    --- FirstBootstrapObjectId is safer, since the former will accept
    objects in information_schema for instance.
    6d060494
connection.c 18.4 KB