Re: [GENERAL] Prepared statements with bind parameters for DDL

2015-02-11 Thread Tom Lane
Martijn van Oosterhout writes: > On Wed, Feb 11, 2015 at 02:22:10PM -0500, Tom Lane wrote: >> Nope. DDL commands generally don't have any support for evaluating >> expressions, which would be the context in which parameters would >> be useful. Nor have they got plans, which would be the requirem

Re: [GENERAL] Prepared statements with bind parameters for DDL

2015-02-11 Thread Martijn van Oosterhout
On Wed, Feb 11, 2015 at 02:22:10PM -0500, Tom Lane wrote: > deepak writes: > > I find that one can't have a prepared statement with bind parameters for a > > DDL statement, > > Nope. DDL commands generally don't have any support for evaluating > expressions, which would be the context in which p

Re: [GENERAL] Prepared statements with bind parameters for DDL

2015-02-11 Thread Tom Lane
deepak writes: > I find that one can't have a prepared statement with bind parameters for a > DDL statement, Nope. DDL commands generally don't have any support for evaluating expressions, which would be the context in which parameters would be useful. Nor have they got plans, which would be th

Re: [GENERAL] Prepared statements with bind parameters for DDL

2015-02-11 Thread Adrian Klaver
On 02/11/2015 09:42 AM, deepak wrote: Hi, I find that one can't have a prepared statement with bind parameters for a DDL statement, although I couldn't find the rationale for this restriction. Is this limitation due to the database design, or is it something that's imposed by the SQL standard a