Re: [GENERAL] SET prepared statement

2016-04-13 Thread Oliver Kohll
> On 13 Apr 2016, at 16:48, David G. Johnston > wrote: > > On Wed, Apr 13, 2016 at 8:38 AM, Oliver Kohll > wrote: > Hello, > > We currently use prepared statements for most of the work an app does, as an > SQL injection protection and for other reasons. > > Th

Re: [GENERAL] SET prepared statement

2016-04-13 Thread David G. Johnston
On Wed, Apr 13, 2016 at 8:38 AM, Oliver Kohll wrote: > Hello, > > We currently use prepared statements for most of the work an app does, as > an SQL injection protection and for other reasons. > > There's one statement which can't be prepared: > > SET LOCAL myprefix.mysetting = 'my setting value'

[GENERAL] SET prepared statement

2016-04-13 Thread Oliver Kohll
Hello, We currently use prepared statements for most of the work an app does, as an SQL injection protection and for other reasons. There's one statement which can't be prepared: SET LOCAL myprefix.mysetting = 'my setting value'; Ideally, I'd like to be able to do PREPARE test(text) as SET LO