The Vertica Database Forums

Code: Select all

dbadmin=> SELECT parameter_name, database_value, allowed_levels, description
dbadmin->   FROM configuration_parameters WHERE parameter_name = 'TransactionMode';
parameter_name  | database_value | allowed_levels |                                        description
-----------------+----------------+----------------+-------------------------------------------------------------------------------------------
TransactionMode | READ WRITE     | NODE, DATABASE | Determines whether the transaction is read/write or read-only.  Read/write is the default
(1 row)

Code: Select all

dbadmin=> SELECT database_name FROM databases;
database_name
---------------
sfdc
(1 row)

dbadmin=> ALTER DATABASE sfdc SET TransactionMode = 'READ ONLY';
ALTER DATABASE

dbadmin=> INSERT INTO jim VALUES(1);
OUTPUT
--------
      1
(1 row)

Code: Select all

dbadmin=> \q

[dbadmin@s18384357 ~]$ vsql
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

dbadmin=> INSERT INTO jim VALUES(1);
ERROR 2448:  Cannot issue this command in a read-only transaction

Code: Select all

dbadmin=> ALTER DATABASE sfdc SET TransactionMode = 'READ WRITE';
ROLLBACK 2448:  Cannot issue this command in a read-only transaction

Code: Select all

dbadmin=> SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED READ WRITE;
SET

dbadmin=> ALTER DATABASE sfdc SET TransactionMode = 'READ WRITE';
ALTER DATABASE