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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
