Configuration / Version and Platform Compatibility
add_missing_from
Read the PG 8.4 manualWhen on, tables that are referenced by a query will be automatically added to the FROM clause if not already present.
Reading PG 8.4·documented in 6 of 24 versions, 7.4 to 8.4
Historical documentation for a PostgreSQL version that is no longer supported.
- Type
- bool
- Context
- See manual
- Measured default
- No measurement for this version
- Unit
- —
Definition PG 8.4 manual
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).
Definition snapshot: english-manuals:89b5d157c8b1b7542bc14526539… · English manual source