Thanks Sharon, I found same from the Documentation.

Hi Jim, I moved the create temp table statement just after the begin transaction. But when I am trying to insert data using "COPY temp_table_name FROM STDIN DIRECT DELIMITER '|' RECORD TERMINATOR '\r\n';" I am facing the same issue of auto commit. The transaction committed automatically while issuin...

Thanks for the update Jim. But creating physical table instead of temp table is very costly in our application. We have almost 50 or more temp table in entire application. What we are thinking is to change the order of execution and issue all temp table creation in the beginning of transaction. Appr...

Hi Jim, Thanks for the quick response. Is there any option to turn OFF the auto commit feature before issuing CREATE statement? Actually we are using this temp table concept for inserting bulk data to a physical table after some validations in the temp table itself. If you can suggest any other meth...

Hi Friends, I am using Vertica .Net data provider 4.1.7 in my .NET appliation. I am facing a strange issue on TEMP table creation. I have started a new TRANSACTION and exectuing couple of insert and update queries. After that I am creating a TEMP table using the same transaction. But after the CREAT...