RE: [GENERAL] 6.4.2 and 6.5 date usertype difference

1999-07-01 Thread Colin Price (EML)
Cheers everyone. Therefore : - At runtime level : test=> show DATESTYLE; test=> SET DATESTYLE TO 'ISO'; - At boot up (/etc/rc.d/init.d/postgres) : Add : export PGDATESTYLE=ISO just before exec

Re: [GENERAL] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Darold Gilles
"Colin Price (EML)" wrote: > > I have just replicated a db in 6.5 from 6.4.2. > > The table selects the date differently from the identical table. > I obviously set a parameter in 6.4.2 which I now cannot find (from > mail list archive and doc as well). > You've probably done a localization wi

Re: [GENERAL] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Herbert Liechti
"Colin Price (EML)" wrote: > I have just replicated a db in 6.5 from 6.4.2. > > The table selects the date differently from the identical table. > I obviously set a parameter in 6.4.2 which I now cannot find (from > mail list archive and doc as well). > > Please aid someone who is tearing his hai

[GENERAL] 6.4.2 and 6.5 date usertype difference

1999-06-29 Thread Colin Price (EML)
I have just replicated a db in 6.5 from 6.4.2. The table selects the date differently from the identical table. I obviously set a parameter in 6.4.2 which I now cannot find (from mail list archive and doc as well). Please aid someone who is tearing his hair out. Thank you in advance, Colin. Th