On Tue, Jan 24, 2012 at 7:38 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > On 23.01.2012 22:52, Jim Mlodgenski wrote: >> >> On Wed, Jan 18, 2012 at 9:19 AM, Jim Mlodgenski<jimm...@gmail.com> wrote: >>> >>> On Wed, Jan 18, 2012 at 3:08 AM, Heikki Linnakangas >>>> >>>> I don't think that's a problem, it's just a free-form message to >>>> display. >>>> >>>> But it also doesn't seem very useful to have it PGC_USERSET: if it's >>>> only >>>> displayed at connect time, there's no point in changing it after >>>> connecting. >>> >>> Should we make it PGC_BACKEND? > > > In hindsight, making it PGC_BACKEND makes it much less useful, because then > you can't set it on a per-database basis with "ALTER DATABASE foo SET ..." > So I made it PGC_USERSET again. > > >> Here is the revised patch based on the feedback. > > > Thanks! I renamed the GUC to "welcome_message", to avoid confusion with > "client_min_messages". I also moved it to "Connection Settings" category. > Although it's technically settable within a session, the purpose is to > display a message when connecting, so "Connection Settings" feels more > fitting. > > There's one little problem remaining with this, which is what to do if the > message is in a different encoding than used by the client? That's not a new > problem, we have the same problem with any string GUC, if you do "SHOW > <setting>". We restricted application_name to ASCII characters, which is an > obvious way to avoid the problem, but I think it would be a shame to > restrict this to ASCII-only. Isn't that an issue for the administrator understanding his audience. Maybe some additional documentation explaining the encoding issue?
> > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers