Horton

Re: changing datestyle

Thomas Good <tomg@q8.nrnet.org>

View thread View on postgr.es
From: Thomas Good <tomg@q8.nrnet.org>
To: Jason Davis <jdavis@tassie.net.au>
Cc: pgsql-novice@hub.org
Date: 2000-10-31T16:28:03Z
Lists: pgsql-novice 
On Tue, 31 Oct 2000, Jason Davis wrote:

> Hi 
> 
> I had the same problem with my web database stuff. The trick is to put the
> line
> 
> SetEnv PGDATESTYLE Postgres
> 
> in your apache.conf (assuming you are running apache). Seems to be fussy
> where it goes - works if you put it directly above the User and Group
> directives.

G'Day Jason and thanks!

I did a rebuild, after editing ./src/backend/utils/init/globals.c
to say:       int           DateStyle = USE_POSTGRES_DATES;

It wasn't too tough to shutdown the server, do a make/make install
and restart but your solution is definitely more elegant.
I am going to hack my apache conf files on the other machines here
running pg7.

Cheers,
Tom
 
--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA                 Phone: 718-354-5528 
                                     Fax:   718-354-5056  
--------------------------------------------------------------------
Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
               RDBMS       |---------- linux      The Power To Serve
--------------------------------------------------------------------