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