Re: setting default date format

On Wednesday 01 October 2003 11:13 am, Oliver Elphick wrote:
> On Wed, 2003-10-01 at 10:41, Gary Stainburn wrote:
> > I want to set the default date format to european dd-mm-yyyy format.
> >
> > Can someone tell me which file, and what I need to add.
>
> In postgresql.conf:
>
> DATESTYLE = 'Postgres,European'

Hi Oliver,

When I did this, and then did 'service postgresql restart' the service failed
to start.

I have managed to get it working by amending the pg_ctl command in
/etc/rc.d/init.d/postgresql to add

-o '-o -e'

but as I said before I seem to remember that this was frowned upon because the
next time I upgrade it'll get overridden.

BTW, I'm running 7.2.3 from the RH RPMS.
--
Gary Stainburn

This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000