From: | "Ivan E(dot) Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: data forma error in pgsql 7.1 |
Date: | 2003-10-21 17:45:14 |
Message-ID: | 3F9570AA.6080807@bnchq.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Tom you right!!
We only set PGDATESTYLE on root env and then restart the httpd
thanks
Tom Lane wrote:
> "Ivan E. Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx> writes:
>
>>the date format that we use is DD/MM/YYYY but whet we execute a select
>>command we get this information:
>
>
> Sounds to me like you haven't told the database what format you're
> using. See the DATESTYLE parameter; you need to select "european"
> format to get it to default to dd-before-mm date order.
>
>
>>We need to know if is necessary to install some patch to fix this
>>problem or upgrade the database.
>
>
> An upgrade would be a good idea in any case. 7.1.3 is pretty old.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
===============================================
Ivan E. Rivera Uria
BNC - Systems FPS Manager
Tel. +(52)-55-2614-0510
Fax. +(52)-55-
Email: irivera(at)bnchq(dot)com(dot)mx
Web: http://www.bnchq.com.mx
==============================================
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-10-21 23:14:58 | Bug or Feature? Subquery issue. |
Previous Message | CN | 2003-10-21 04:09:30 | Contraints problem in PLPGSQL |