Re: 9.5 Create Function Set From Current taken at creation time?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: 9.5 Create Function Set From Current taken at creation time?
Date: 2016-08-09 13:43:50
Message-ID: 20203.1470750230@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> Can we change the second sentence in the above quote to something like:

> SET FROM CURRENT is a convenience expression to capture the result of
> current_setting('setting name') at the time of the function's creation. [if
> more than just convenience an example of when this is useful would be nice].

"Convenience" normally means that there's some other way to get the same
result. I do not know of one, and I doubt we'd have introduced the
feature if there was.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message nicolas.david 2016-08-09 14:23:29 BUG #14285: Chinese locale and windows
Previous Message Andrew Gierth 2016-08-09 13:30:58 Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse