postgresql: cannot run inside a transaction block

Question

I am trying to run these commands together in SQLbox of phppgadmin

CREATE DATABASE "ir-staging";
CREATE USER django WITH ENCRYPTED PASSWORD 'django';
GRANT ALL PRIVILEGES ON DATABASE "ir-staging" TO django;

I get

SQL error:

ERROR:  CREATE DATABASE cannot run inside a transaction block
In statement:
CREATE DATABASE "ir-staging";
CREATE USER django WITH ENCRYPTED PASSWORD 'django';
GRANT ALL PRIVILEGES ON DATABASE "ir-staging" TO django

Whereas if I run the

CREATE DATABASE "ir-staging";

alone it works

Adrian Klaver · Accepted Answer · 2021-07-04 00:35:09Z

2

Pretty straight forward:

https://www.postgresql.org/docs/current/sql-createdatabase.html

CREATE DATABASE cannot be executed inside a transaction block.

From the looks of it Sqlbox is starting a transaction with BEGIN; when running multiple statements and tripping the error. Whereas for single transaction it is running in autocommit mode. Look in the docs to see if you can specify autocommit as default action. Or better yet use psql instead.

answered Jul 4, 2021 at 0:35

Adrian Klaver

20.3k3 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql: cannot run inside a transaction block

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related