Weird PG 8.1.3 date error

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Weird PG 8.1.3 date error
Date: 2006-12-13 16:37:07
Message-ID: 45802C33.2030509@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have a user who is getting this error on a 8.1.3 server when importing
some data from a dbf file:

PostgreSQL Error Code: (1)
ERROR: date/time field value out of range: "08-01-2006"

He says the db is SQL-ASCII and the datestyle is at the default.

Of course on all my test servers the insert works perfectly without the
range error.

Anyone have any Ideas? I don't know if the pg server is win32 or Unix.

Thanks,

--
Tony

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-12-13 16:37:47 Re: [girgen@FreeBSD.org: Re: port fault on pg_ctl's place]
Previous Message Gene 2006-12-13 16:33:26 Re: grant select on all tables of schema or database