Postgres setting autocommit off globally

postgresql transactions autocommit
ajeeshpu picture ajeeshpu · Dec 12, 2012 · Viewed 12.6k times · Source

How do you set autocommit off in psql 8.4 at a global level? is there a configuration attribute that i can change that will introduce this behaviour for all dbs on a cluster to start db sessions with autocommit off?

Answer

exhuma picture exhuma · Oct 18, 2013

Simply add the following to ~/.psqlrc:

\set AUTOCOMMIT off

Note that this only works when using the psql shell! I assume this is what you are talking about?

Related questions

Transactions are auto committed on PostgreSQL 9.5.2 with no option to change it?

I've just set up a new PostgreSQL 9.5.2, and it seems that all my transactions are auto committed. Running the following SQL: CREATE TABLE test (id NUMERIC PRIMARY KEY); INSERT INTO test (id) VALUES (1); ROLLBACK; results in a warning: WARNING: there …

Read More
Are PostgreSQL functions transactional?

Is a PostgreSQL function such as the following automatically transactional? CREATE OR REPLACE FUNCTION refresh_materialized_view(name) RETURNS integer AS $BODY$ DECLARE _table_name ALIAS FOR $1; _entry materialized_views%ROWTYPE; _result INT; BEGIN EXECUTE 'TRUNCATE TABLE ' || _table_name; …

Read More
now() default values are all showing same timestamp

I have created my tables with a column (type: timestamp with timezone) and set its default value to now() (current_timestamp()). I run a series of inserts in separate statements in a single function and I noticed all the timestamps …

Read More