Re: Privilege required for IF EXISTS event if the object already exists - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Privilege required for IF EXISTS event if the object already exists
Date
Msg-id CAKFQuwaWcAenxCTc0OzMm+u_JK_KoqerFCNthfNTDY2Y5f5s2w@mail.gmail.com
Whole thread Raw
In response to Re: Privilege required for IF EXISTS event if the object already exists  (Shay Rojansky <roji@roji.org>)
Responses Re: Privilege required for IF EXISTS event if the object already exists
List pgsql-hackers
On Wednesday, December 15, 2021, Shay Rojansky <roji@roji.org> wrote:
. Now, before creating tables, the ORM generates CREATE SCHEMA IF NOT EXISTS, to ensure that the schema exists before CREATE TABLE; that's reasonable general-purpose behavior.

If the user hasn’t specified they want the schema created it’s arguable that executing create schema anyway is reasonable.  The orm user should know whether they are expected/able to create the schema as part of their responsibilities and instruct the orm accordingly and expect it to only create what it has been explicitly directed to create.

David J.

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Next
From: Florian Koch
Date:
Subject: psql format output