Re: Making pgsql error messages more developers' friendly.

On Saturday 28 Jun 2003 8:50 pm, Jan Wieck wrote:
> Rajesh Kumar Mallah wrote:
> > Hi Folks,
> >
> > Shudnt' messages like
> >
> > ERROR: value too long for type character varying(5)
>
> Maybe, yes. It's just not that trivial to do.
>
> > MySQL is better in these small things.
> >
> > I think in 7.4dev fkey violation are reported better,
> > cant such behaviours be extened to other kind of
> > exceptions?
>
> We are working on it.

>But pointing to MySQL doesn't help a bit. If you
> like MySQL better, then use MySQL instead

I am not a MySQL fan. I have been been using PostgreSQL since
7.0.3 version. Posting it here becoz its a public forum and u made
an attempt to paint me worng here ;-)

Regds
Mallah.

> and don't bother with the side
> effects from the data type abstraction you actually bumped into.
>
> Sorry, I'm a bit tired of "MySQL does this ...", "MySQL is better here
> ..." and so on and so forth. No however good error message system can be
> used by the application programmer as replacement for input data
> validation. Type checking, foreign keys, check constraints, they all are
> last lines of defense, so that a bug in the application or a missing
> input validation doesn't cause greater damage. But they are not a
> replacement.
>
>
> Jan

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.