Re: [GENERAL] CREATE USER within function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Michal Taborsky <M(dot)Taborsky(at)sh(dot)cvut(dot)cz>, Bugs for PostgreSQL <pgsql-bugs(at)postgresql(dot)org>, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Subject: Re: [GENERAL] CREATE USER within function
Date: 2003-04-15 05:44:59
Message-ID: 5287.1050385499@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2003-04-15 22:01:13 Re: [GENERAL] CREATE USER within function
Previous Message Tatsuo Ishii 2003-04-15 02:25:09 Re: [HACKERS] Bug #943: Server-Encoding from EUC_TW to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-15 05:49:26 Re: [GENERAL] Problem about pgsql's column alias
Previous Message Tom Lane 2003-04-15 05:39:45 Re: Strange query optimization in 7.3.2