Re: [BUGS] data forma error in pgsql 7.1

2003-10-21 Thread Ivan E. Rivera Uria
Tom you right!! We only set PGDATESTYLE on root env and then restart the httpd thanks Tom Lane wrote: "Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes: the date format that we use is DD/MM/ but whet we execute a select command we get this information: Sounds to me like you haven't told t

Re: [BUGS] data forma error in pgsql 7.1

2003-10-17 Thread Tom Lane
"Ivan E. Rivera Uria" <[EMAIL PROTECTED]> writes: > the date format that we use is DD/MM/ 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" forma

[BUGS] data forma error in pgsql 7.1

2003-10-17 Thread Ivan E. Rivera Uria
We are developing a Vehicle Control Application for Mexico Government (Morelia, Michoacan), and we have a problem with the date format in the database. The Operating System is RedHat Linux 7.2 and database is PostgreSQL Ver. 7.1.3. Explanation: The comand that we execute is: insert into docs