Re: [GENERAL] error message - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] error message
Date
Msg-id 3891CE65.A6C1A00C@austin.rr.com
Whole thread Raw
In response to error message  ("Jackson, Kevin J." <KJJACKS@twa.com>)
List pgsql-general
"Jackson, Kevin J." wrote:
>
> 1) What does the following mean:
> PostgresSQL query failed: ERROR: Bad date external representation

You might have an illegal date string format, though this kind of
message also shows up in other circumstances IIRC.

Try 'MM/DD/YYYY' or 'YYYY-MM-DD'...

> 2) Is there a comprehensive list of PostgreSQL error messages and their
> meanings?

No, and it has been sorely missed every day for quite some time.

Best tool:  power search at www.deja.com ... most problems are
archived there, along with solutions and workarounds.

Other tools:  mailing list archive search engine via
(http://www.postgresql.org/lists/mailing-list.html) ... availability
seems to be spotty, though this search engine is just recently
redesigned...

Cheers,
Ed Loehr

pgsql-general by date:

Previous
From: LIVIU ILIE
Date:
Subject: [Fwd: how to install postgresql-6.5.1 binaries on nt]
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4