Re: 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(at)candle(dot)pha(dot)pa(dot)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