Re: [GENERAL] error message

"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