Re: [GENERAL] Restrict allowed database names?

2010-03-22 Thread Adrian von Bidder
On Sunday 21 March 2010 02.01:27 Scott Mead wrote: > On Sat, Mar 20, 2010 at 5:24 PM, Adam Seering wrote: > > Hi, > > > >I'm trying to set up an internal general-purpose PostgreSQL > >server > > > > installation. I want most users with login access to the server to be > > able t

Re: [GENERAL] Restrict allowed database names?

2010-03-21 Thread Tom Lane
"Daniel Verite" 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 reas

Re: [GENERAL] Restrict allowed database names?

2010-03-21 Thread Sergey Konoplev
On 21 March 2010 20:43, Daniel Verite wrote: >        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 transacti

Re: [GENERAL] Restrict allowed database names?

2010-03-21 Thread Daniel Verite
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). Best regards, -- Daniel PostgreSQL-powered mail

Re: [GENERAL] Restrict allowed database names?

2010-03-21 Thread Sergey Konoplev
On 21 March 2010 00:24, Adam Seering wrote: > Hi, >        I'm trying to set up an internal general-purpose PostgreSQL server > installation.  I want most users with login access to the server to be able > to create databases, but only with names that follow a specified naming > convention (in

Re: [GENERAL] Restrict allowed database names?

2010-03-20 Thread Steve Atkins
On Mar 20, 2010, at 2:24 PM, Adam Seering wrote: > Hi, > I'm trying to set up an internal general-purpose PostgreSQL server > installation. I want most users with login access to the server to be able > to create databases, but only with names that follow a specified naming > convention

Re: [GENERAL] Restrict allowed database names?

2010-03-20 Thread Scott Mead
On Sat, Mar 20, 2010 at 5:24 PM, Adam Seering wrote: > Hi, >I'm trying to set up an internal general-purpose PostgreSQL server > installation. I want most users with login access to the server to be able > to create databases, but only with names that follow a specified naming > conventi

[GENERAL] Restrict allowed database names?

2010-03-20 Thread Adam Seering
Hi, I'm trying to set up an internal general-purpose PostgreSQL server installation. I want most users with login access to the server to be able to create databases, but only with names that follow a specified naming convention (in particular, approximately "is prefixed with the owner'

[GENERAL] Restrict allowed database names?

2010-03-20 Thread Adam Seering
Hi, I'm trying to set up an internal general-purpose PostgreSQL server installation. I want most users with login access to the server to be able to create databases, but only with names that follow a specified naming convention (in particular, approximately "is prefixed with the owner'