Thread: misleading (or perhaps confusing) error messages

misleading (or perhaps confusing) error messages

From
pgsql-bugs@postgresql.org
Date:
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