Re: Restrict allowed database names? - Mailing list pgsql-general

From Tom Lane
Subject Re: Restrict allowed database names?
Date
Msg-id 24819.1269194553@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restrict allowed database names?  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
"Daniel Verite" <daniel@manitou-mail.org> writes:
>     Sergey Konoplev wrote:
>> What about PL/pgSQL wrapper function for CREATE DATABASE with database
>> name check and SECURITY DEFINER option.

> Not possible because CREATE DATABASE can't be executed within a function (nor
> within a transaction).

Note that the reasons why that's true are equally good reasons to not
allow triggers or any other user-added operations for CREATE DATABASE.

            regards, tom lane

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Restrict allowed database names?
Next
From: John Shott
Date:
Subject: Problems with "CREATE CAST"