Re: data forma error in pgsql 7.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ivan E(dot) Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: data forma error in pgsql 7.1
Date: 2003-10-17 19:05:07
Message-ID: 25428.1066417507@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ivan E. Rivera Uria 2003-10-17 19:37:25 data forma error in pgsql 7.1
Previous Message Tom Lane 2003-10-16 23:58:37 Re: Bug in the information_schema.referential_constraints view