Re: set permanent date style - Mailing list pgsql-admin

From Tom Lane
Subject Re: set permanent date style
Date
Msg-id 25685.1024407566@sss.pgh.pa.us
Whole thread Raw
In response to Re: set permanent date style  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: set permanent date style
List pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
> in postmaster.conf, add a line that looks something like this:
> PGDATESTYLE=ISO,European

I do not believe that will work in any released version.  It will work
to set PGDATESTYLE as an environment variable in the postmaster's
environment, however.

As of 7.3 it will be possible to set DateStyle in postgresql.conf,
but up through 7.2 DateStyle is specially handled and isn't in the
set of variables that postgresql.conf knows about :-(

For the particular problem at hand, adding -e to the postmaster's
command line switches might have been enough ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Michael Ansley (UK)"
Date:
Subject: Re: Uppercase field names not found
Next
From: "Nick Fankhauser"
Date:
Subject: Re: set permanent date style