Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have the following problem.

SELECT * FROM tgvbn();
ERROR:  function tgvbn() does not exist
LINE 1: SELECT * FROM tgvbn();
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Since Appendix A of the official documentation only states error_codes and conditional names but not the actual messages, one can only guess that "No function matches..." refers to 42883 / undefined_function. I can set log_error_verbosity = verbose in postgresql.conf - but that will affect the logs, not the messages returned to the client:

Controls the amount of detail written in the server log for each message that is logged.

Well, I can consult the logs for this piece of information, but is there any means of including it in the error messages?

share|improve this question
    
This is more a psql problem than a "server configuration" problem. My SQL client does show the SQLSTATE in such a case. –  a_horse_with_no_name Nov 16 '12 at 14:31
    
@a_horse_with_no_name Thanks, your comment directed me towards the solution. –  dezso Nov 16 '12 at 15:05
add comment

1 Answer

up vote 4 down vote accepted

Based on a_horse_with_no_name's comment, I started searching around psql and found the solution:

\set VERBOSITY verbose
SELECT * FROM tgvbn();

ERROR:  42883: function vfjkb() does not exist
...

Now that goes into .psqlrc. Details and further options can be found in the psql documentation.

share|improve this answer
    
I quickly scanned through the manual after posting my comment, but I didn't see that one ;) Thanks for the update. –  a_horse_with_no_name Nov 16 '12 at 15:16
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.