Postgres Pro
Downloads
Home   >   mailing lists

BUG #2542: ALTER USER foo SET bar = func(baz) errors out - Mailing list pgsql-bugs

From David Fetter
Subject BUG #2542: ALTER USER foo SET bar = func(baz) errors out
Date
Msg-id 200607210140.k6L1eeX4070001@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2542
Logged by:          David Fetter
Email address:      david@fetter.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?

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2540: function upper(..) and operator 'like' problem
Next
From: Tom Lane
Date:
Subject: Re: BUG #2542: ALTER USER foo SET bar = func(baz) errors out