Thread: error message

error message

From
"Jackson, Kevin J."
Date:
Can anyone give me the following information:

1) What does the following mean:
PostgresSQL query failed: ERROR: Bad date external representation
I get this error message while trying to add a record to a table from a form
using PHP.

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

Many thanks!

Kevin J. Jackson
Internet Support/Development Specialist
Trans World Airlines, Inc.
kjjacks@twa.com
http://www.twa.com


Re: [GENERAL] error message

From
Ed Loehr
Date:
"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