Skip site navigation (1) Skip section navigation (2)

Re: changing datestyle

From: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
To: Bryan White <bryan(at)arcamax(dot)com>
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: changing datestyle
Date: 2000-10-31 17:05:21
Message-ID: Pine.LNX.3.96.1001031115133.15836A-100000@q8.nrnet.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 31 Oct 2000, Bryan White wrote:

> > 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.
> 
> I did the same thing (changed globals.c).  It seems more elegant because
> only one place had to change to affect the entire system across multiple
> servers, environments and programming languages.

Maybe...then again I have to hack my apache conf files to setup database 
access and /etc/profile to setup Pg env vars for DBI/DBD anyway.  
Adding PGDATESTYLE to my conf TODO list is painless.  In fact, I use
small patches that I read in via vi...being not overly fond of typing.

I suppose it is personal preference, eh?  After all:  TMTOWTDI.  ;-)

--------------------------------------------------------------------
               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
--------------------------------------------------------------------


In response to

pgsql-novice by date

Next:From: Jean-Christophe BoggioDate: 2000-10-31 17:08:14
Subject: Re[2]: changing datestyle
Previous:From: Bryan WhiteDate: 2000-10-31 16:41:02
Subject: Re: changing datestyle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group