Thread: postgresql.conf - add_missing_from

postgres does not seem to pick up
the following parameter in the postgresql.conf

add_missing_from = false

Setting the parameter via psql, functions properly
SET add_missing_from TO FALSE

Using: winxp, Postges 8.0
(note: I did restart the service after updating the parameters in
postgresql.conf)

Niederland wrote:
> postgres does not seem to pick up
> the following parameter in the postgresql.conf
>
> add_missing_from = false
>
> Setting the parameter via psql, functions properly
> SET add_missing_from TO FALSE
>
> Using: winxp, Postges 8.0
> (note: I did restart the service after updating the parameters in
> postgresql.conf)

It works on my BSD system using 8.0 with postgresql.conf of:

    add_missing_from = false

Did you remove the comment?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Yes I removed the comment...

Tail end of postgresql.conf......

#---------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#---------------------------------------------------------------------------

# - Previous Postgres Versions -

# do not allow the database engine to change the from clause
add_missing_from = false
#regex_flavor = advanced    # advanced, extended, or basic
#sql_inheritance = true
#default_with_oids = true
# - Other Platforms & Clients -

#transform_null_equals = false