Re: Allowing create database within transaction block

2021-02-11 Thread Tom Lane
Hari Sankar writes: > I wanted to see why we do not allow the following statements to be allowed > within a transaction block: > 1. Create database > 2. Drop Database > Is there a detailed reasoning behind disallowing the above statements as > part of the design. Will appreciate it if someone can

Allowing create database within transaction block

2021-02-08 Thread Hari Sankar
Hi everyone, I wanted to see why we do not allow the following statements to be allowed within a transaction block: 1. Create database 2. Drop Database Is there a detailed reasoning behind disallowing the above statements as part of the design. Will appreciate it if someone can share on why postgre