How do I set the default time zone for every new ODBC connection when the timezone we want in the session is different than the default database timezone?

How do I turn on error logging for an ODBC connection in Linux? We're having problems connecting with an ODBC client tools and I'd like to be able to view an error log if in fact there are errors occurring...

Which version of Toad works with Vertica? I can't find a version on Quest Software's site that appears to be specifically for Vertica. Thanks.

Thanks, by the way... You were right about the spaces. That seems silly.

Hello, Our database went down and I can not get it to restart using the admintools. When I try and start it, I get the following messages: *** Starting database: finance_wh01 *** Node Status: v_finance_wh01_node0001: (DOWN) v_finance_wh01_node0002: (DOWN) v_finance_wh01_node0003: (DOWN) Node Status:...

Hi, When I run the install_vertica script I get an error.

Here is the command line I am running:

Does Vertica support the CLOB and BLOB data types like in Oracle? I have several tables in an Oracle database with these data types and I'd like to copy them into Vertica.