Re: [GENERAL] error message

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: "Jackson, Kevin J(dot)" <KJJACKS(at)twa(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] error message
Date: 2000-01-28 17:14:13
Message-ID: 3891CE65.A6C1A00C@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-01-28 17:19:11 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Previous Message LIVIU ILIE 2000-01-28 17:12:55 [Fwd: how to install postgresql-6.5.1 binaries on nt]