Re: set permanent date style

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "Martin Teoh" <martin_teoh(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: set permanent date style
Date: 2002-06-18 13:39:26
Message-ID: 25685.1024407566@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-06-18 14:19:04 Re: set permanent date style
Previous Message Michael Ansley (UK) 2002-06-18 13:32:09 Re: Uppercase field names not found