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.confadd_missing_from = false
Setting the parameter via psql, functions properly
SET add_missing_from TO FALSEUsing: 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