Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: using 'ALTER ROLE' in a function
- From: Douglas McNaught <doug(at)mcnaught(dot)org>
- To: Lutz Broedel <lb(at)fggm(dot)uni-hannover(dot)de>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: using 'ALTER ROLE' in a function
- Date: Thu, 22 Mar 2007 11:33:18 -0400
- Message-id: <878xdpz41t(dot)fsf(at)suzuka(dot)mcnaught(dot)org>
Lutz Broedel <lb(at)fggm(dot)uni-hannover(dot)de> writes: > ERROR: Error »syntax error« at »$1« at character 13 > QUERY: ALTER ROLE $1 WITH ENCRYPTED PASSWORD $2 > > I have tried this in several ways and it seems, ALTER ROLE just does > not accept a parameter instead of name. Does anybody have a solution > for this? You probably need to build the query dynamically and use EXECUTE. -Doug
- References:
- using 'ALTER ROLE' in a function
- From: Lutz Broedel
- using 'ALTER ROLE' in a function
- Prev by Date: Re: Bug in CREATE/DROP TABLESPACE command
- Next by Date: Re: xpath_list() function
- Previous by thread: using 'ALTER ROLE' in a function
- Next by thread: Deadlock with REINDEX TABLE
- Indexes: