Thread: Re: [GENERAL] CREATE USER within function

Re: [GENERAL] CREATE USER within function

From
Bruce Momjian
Date:
Jan Wieck wrote:
> Tom Lane wrote:
> >
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Jan, would you take a look at this?  It is reproducable.  I see the
> > > query sending "CREATE USER $1 ..." in the server logs.
> >
> > Hardly requires much looking: utility statements don't take parameter
> > symbols, only literal constants.  The only way to do this from plpgsql
> > at the moment is with EXECUTE.
>
> We should add something to that extent to the FAQ :-)

Can we improve the error message reported to the user?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073