The Vertica Database Forums

Code: Select all

using (var conn = VerticaHelper.GetConnection())
            {
               conn.Open();
               VerticaTransaction trans = conn.BeginTransaction();
              ExecuteNonQuery("insert into testschema.mytable(id,name) values(1,'fdfd')",conn,trans);

             string createTempTable = "CREATE LOCAL TEMP TABLE temp_1022(id int,name varchar(100)) ON COMMIT PRESERVE ROWS;";
             ExecuteNonQuery(createTempTable,conn,trans); //After executing this command the previous statement also commited why?????
              trans.Commit();
           }


function ExecuteNonQuery(query,conn,trans){
           using (VerticaCommand cmd = new VerticaCommand(query, conn))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Transaction = trans;                    
                    int numChanged = cmd.ExecuteNonQuery();                   

                }
   }

Code: Select all

dbadmin=> begin transaction;
BEGIN
dbadmin=> insert into testschema.mytable(id,name) values(1,'fdfd');
 OUTPUT
--------
      1
(1 row)

dbadmin=> CREATE LOCAL TEMP TABLE temp_1022(id int,name varchar(100)) ON COMMIT PRESERVE ROWS;
CREATE TABLE
dbadmin=> rollback;
INFO 2499:  Cannot rollback; no transaction in progress
ROLLBACK
dbadmin=> select * from testschema.mytable;
 id | name
----+------
  1 | fdfd
(1 row)