Allowing create database within transaction block

From: Hari Sankar <harisankars2003(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Allowing create database within transaction block
Date: 2021-02-08 19:01:36
Message-ID: CAKz7k7tx0S+eROWtTfnCPXpXYA35cx6=2kmox+Fb7coa8+1ZTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 postgres
does not allow these statements inside a transaction block.

Thank you

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniil Zakhlystov 2021-02-08 19:23:53 Re: libpq compression
Previous Message Bossart, Nathan 2021-02-08 18:59:45 Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM