Weird PG 8.1.3 date error - Mailing list pgsql-general

From Tony Caduto
Subject Weird PG 8.1.3 date error
Date
Msg-id 45802C33.2030509@amsoftwaredesign.com
Whole thread Raw
Responses Re: Weird PG 8.1.3 date error  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Weird PG 8.1.3 date error  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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


pgsql-general by date:

Previous
From: Gene
Date:
Subject: Re: grant select on all tables of schema or database
Next
From: Tom Lane
Date:
Subject: Re: [girgen@FreeBSD.org: Re: port fault on pg_ctl's place]