{"Entry":{"collection":"guc","key":"add_missing_from","name":"add_missing_from","aliases":[],"metadata":{"baseline":true,"boot_human":"Not specified","boot_val":null,"category":"Version and Platform Compatibility","category_zh":"","changed_in":[],"changes":[{"documentation_changed":true,"fields":{},"from":"7.4","status":"changed","to":"8.0"},{"documentation_changed":true,"fields":{},"from":"8.0","status":"changed","to":"8.1"},{"documentation_changed":false,"fields":{},"from":"8.4","status":"removed","to":"9.0"}],"content_hash":"97b3a093d5aed562696bc9f6367fe8ebc3f7db79ca44f541cdde509c00048b60","context":"","default_changed_in":[],"default_history":[],"editorial":{},"enumvals":[],"first_version":"7.4","group":"Version and Platform Compatibility","group_slug":"compatible","imported_at":"2026-09-27T17:57:30.730065+08:00","intro_commit":{},"key":"add_missing_from","last_version":"8.4","max_val":"","min_val":"","name":"add_missing_from","position":3,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4"],"short_desc":"When on, tables that are referenced by a query will be automatically added to the FROM clause if not already present.","short_desc_zh":"","source_rev":"english-manuals:89b5d157c8b1b7542bc14526539c3ff85aef006d538de19cee5048c60e29eb50","unit":"","vartype":"bool"}},"Definition":{"Collection":"guc","Key":"add_missing_from","SourceDatabase":"center","Version":"8.4","SourceTable":"guc","SourceKey":"add_missing_from","SourceRevision":"english-manuals:89b5d157c8b1b7542bc14526539c3ff85aef006d538de19cee5048c60e29eb50","Facts":{"boot_val":null,"category":"Previous PostgreSQL Versions","context":"","description":"When on, tables that are referenced by a query will be automatically added to the FROM clause if not already present. This behavior does not comply with the SQL standard and many people dislike it because it can mask mistakes (such as referencing a table where you should have referenced its alias). The default is off. This variable can be enabled for compatibility with releases of PostgreSQL prior to 8.1, where this behavior was allowed by default. Note that even when this variable is enabled, a warning message will be emitted for each implicit FROM entry referenced by a query. Users are encouraged to update their applications to not rely on this behavior, by adding all tables referenced by a query to the query's FROM clause (or its USING clause in the case of DELETE).","doc":{"anchor":"GUC-ADD-MISSING-FROM","file":"runtime-config-compatible.html","lang":"en","sha256":"5a4f502dc610bc633464e7e9310b5e921d4b70e9b72df63f9a3c23a100d3793c","slug":"8.4"},"documented":true,"enumvals":[],"extra_desc":"","lang":"en","max_val":null,"metadata_version":"","min_val":null,"name":"add_missing_from","short_desc":"","source":"english-manual","unit":"","vartype":"bool"},"ManualEvidence":{"doc":{"anchor":"GUC-ADD-MISSING-FROM","file":"runtime-config-compatible.html","lang":"en","sha256":"5a4f502dc610bc633464e7e9310b5e921d4b70e9b72df63f9a3c23a100d3793c","slug":"8.4"}},"MeasuredEvidence":{"metadata_version":""}},"Text":{"Collection":"guc","Key":"add_missing_from","SourceDatabase":"center","Version":"8.4","Locale":"en","Title":"add_missing_from","Summary":"When on, tables that are referenced by a query will be automatically added to the FROM clause if not already present. This behavior does not comply with the SQL standard and many people dislike it because it can mask mistakes (such as referencing a table where you should have referenced its alias). The default is off. This variable can be enabled for compatibility with releases of PostgreSQL prior to 8.1, where this behavior was allowed by default. Note that even when this variable is enabled, a warning message will be emitted for each implicit FROM entry referenced by a query. Users are encouraged to update their applications to not rely on this behavior, by adding all tables referenced by a query to the query's FROM clause (or its USING clause in the case of DELETE).","BodyHTML":"\u003cp\u003eWhen on, tables that are referenced by a query will be automatically added to the FROM clause if not already present. This behavior does not comply with the SQL standard and many people dislike it because it can mask mistakes (such as referencing a table where you should have referenced its alias). The default is off. This variable can be enabled for compatibility with releases of PostgreSQL prior to 8.1, where this behavior was allowed by default. Note that even when this variable is enabled, a warning message will be emitted for each implicit FROM entry referenced by a query. Users are encouraged to update their applications to not rely on this behavior, by adding all tables referenced by a query to the query\u0026#39;s FROM clause (or its USING clause in the case of DELETE).\u003c/p\u003e","SourceRevision":"english-manuals:89b5d157c8b1b7542bc14526539c3ff85aef006d538de19cee5048c60e29eb50","ContentHash":"b64e4cc5611b82a515284242f8ed2e6a5263cd4f7848b8f2ff81ce45351b7e09","Payload":{"description":"When on, tables that are referenced by a query will be automatically added to the FROM clause if not already present. This behavior does not comply with the SQL standard and many people dislike it because it can mask mistakes (such as referencing a table where you should have referenced its alias). The default is off. This variable can be enabled for compatibility with releases of PostgreSQL prior to 8.1, where this behavior was allowed by default. Note that even when this variable is enabled, a warning message will be emitted for each implicit FROM entry referenced by a query. Users are encouraged to update their applications to not rely on this behavior, by adding all tables referenced by a query to the query's FROM clause (or its USING clause in the case of DELETE)."}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["7.4","8.0","8.1","8.2","8.3","8.4"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}