postgresql.conf - add_missing_from

Started by Niederlandover 21 years ago3 messagesgeneral
Jump to latest
#1Niederland
niederland@gmail.com

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)

#2Bruce Momjian
bruce@momjian.us
In reply to: Niederland (#1)
Re: postgresql.conf - add_missing_from

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
#3Niederland
niederland@gmail.com
In reply to: Bruce Momjian (#2)
Re: postgresql.conf - add_missing_from

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