Re: Privilege required for IF EXISTS event if the object already exists

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Privilege required for IF EXISTS event if the object already exists
Дата
Msg-id CAKFQuwaWcAenxCTc0OzMm+u_JK_KoqerFCNthfNTDY2Y5f5s2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Privilege required for IF EXISTS event if the object already exists  (Shay Rojansky <roji@roji.org>)
Ответы Re: Privilege required for IF EXISTS event if the object already exists  (Shay Rojansky <roji@roji.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Следующее
От: Florian Koch
Дата:
Сообщение: psql format output