The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to trigger the error messages in ODBCMessages.xml and VerticaMessages.xml
CharlieCai Community Edition User
Could you please help to give example which can easily trigger the error message in ODBCMessages.xml or VerticaMessages.xml?
I'd like to test and confirm if relative path works for ErrorMessagesPath in vertica.ini
Thanks & Regards,
On Linux, you can test with "isql" client in verbose mode:
$ isql -v vertica
SQL> select count(distinct x), listagg(y) from myTable;
ERROR 2624: Column "x" does not exist
Thanks for your reply.
Yes, I will get the same error, but this error template could not be found in ODBCMessages.xml or VerticaMessages.xml.
Instead, I can find one similar error in ODBCMessages.xml
<!-- Error thrown when a specified column name is invalid or not found. -->
<Error Key="InvalidColumnName" Params="1" NativeErrorCode="20021">Invalid column name: %1%</Error>
Could you please help to provide more information on how to make error messages in these two xml files take effort?