Skip site navigation (1) Skip section navigation (2)

Re: Re: [HACKERS] OSDN Database conference report (long)

From: Tim Uckun <tim(at)diligence(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [HACKERS] OSDN Database conference report (long)
Date: 2000-11-03 18:45:54
Message-ID: 4.2.0.58.20001103104128.014ac7b0@mail.diligence.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
At 11:08 AM 11/3/2000 -0500, Tom Lane wrote:
>"Rob S." <rslifka(at)home(dot)com> writes:
> >> ...  I thought this pointed up the need we've
> >> been aware of for awhile to overhaul our error reporting.
>
> > I'm not sure exactly where the error checking comes in.  I've been using
> > Postgres in two places - at home (Apache/Tomcat) and at work (Apache/iASP)
> > for the last 8 months or so.  The only gripe I have with error messages is
> > that they could be more specific.  "Error near <some character that occurs
> > 20+ times in the query>" is usually pretty useless =)  Otherwise, I can't
> > recall a single time where I said, "man that message should be more clear".

As opposed to SQL server which tends to be extrememly cryptic and goes out 
of it's way to hide information from you. Once I was importing some records 
from a text file and it kept stopping in the middle with a dialog box that 
said "overflow" and that's all. It would not tell me the line number or the 
field it was having trouble with. What I did was to recreate the structure 
of the table in postgres and try to import into there. Postgres told me 
that I had an invalid date on line number whatever. I guess you cna say I 
used postgres as a debugging tool for ms-sql server.

BTW did you know that it's impossible to store dates before 1700 on ms-sql 
server? It's datetime datatype will not support older dates.
----------------------------------------------
              Tim Uckun
       Mobile Intelligence Unit.
----------------------------------------------
    "There are some who call me TIM?"
----------------------------------------------

In response to

pgsql-hackers by date

Next:From: DaveDate: 2000-11-03 19:11:40
Subject: EUC_TW not working in snapshot version
Previous:From: Partyka RobertDate: 2000-11-03 18:32:55
Subject: Re[2]: postgres not use table access permissions ?

pgsql-general by date

Next:From: Justin FosterDate: 2000-11-03 19:56:59
Subject: Re: Memory Leak
Previous:From: Fernan AgueroDate: 2000-11-03 18:09:44
Subject: how to change column type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group