Skip site navigation (1) Skip section navigation (2)

BUG #2542: ALTER USER foo SET bar = func(baz) errors out

From: "David Fetter" <david(at)fetter(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
Date: 2006-07-21 01:40:40
Message-ID: 200607210140.k6L1eeX4070001@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2542
Logged by:          David Fetter
Email address:      david(at)fetter(dot)org
PostgreSQL version: All
Operating system:   All
Description:        ALTER USER foo SET bar = func(baz) errors out
Details: 

foo=> ALTER USER foo SET search_path = current_setting('search_path');
ERROR:  syntax error at or near "(" at character 52
LINE 1: ...LTER USER foo SET search_path = current_setting('search_p...

is there some way to let the right hand side of SET be the (TEXT) output of
a function?

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-07-21 02:46:27
Subject: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out
Previous:From: Peter EisentrautDate: 2006-07-20 21:39:30
Subject: Re: BUG #2540: function upper(..) and operator 'like' problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group