misleading (or perhaps confusing) error messages - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject misleading (or perhaps confusing) error messages
Date
Msg-id 200008310008.e7V08gk90036@hub.org
Whole thread Raw
List pgsql-bugs
Dave E Martin (xxiii@cyberdude.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
misleading (or perhaps confusing) error messages

Long Description
When an error is generated as the result of a trigger (or other indirect action) it would be helpful if the error
messagecould somehow indicate the trigger was the cause, rather than the executed statement itself. 
<PRE>
for instance:

insert into NAS values (...);
ERROR:  nas_make: Permission denied

</PRE>
While the error message is technically correct, it tends to leave one scratching one's head, until one remembers or
realizesthat a trigger was involved. 
When dealing with a complicated series of statements and/or transactions it may be considerably more difficult to make
therequired inference from the error message. 

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Page 13 of tutorial has a typo I believe
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Responses to bugs should appear publically with bug reports