On Thursday 12 June 2008 17:38:26 Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > looking in my freshly installed 8.3.3, I see this in the postgresql.conf > > #client_encoding = sql_ascii # actually, defaults to database > > # encoding > > > > Now, certainly initdb can't know for sure what encoding a future database > > will be in, but since it does know what encoding template0 & friends will > > be in, and most databases are copied from those (including encoding), > > wouldn't a better default be to set it the encoding of template0? > > No. Setting it at all in postgresql.conf is generally the wrong thing; > the right thing is to let the default behavior (ie, make it equal to the > database encoding) happen. >
But isn't putting a default that is likely to be wrong just encouraging people to set it to something more permanent as an attempt to "correct" this? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers