Re: changing datestyle

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