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

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

2015-02-11 Thread Tom Lane
deepak deepak...@gmail.com 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,

[GENERAL] Prepared statements with bind parameters for DDL

2015-02-11 Thread deepak
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 and/or the JDBC drivers? Please

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 deepak...@gmail.com 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

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

2015-02-11 Thread Tom Lane
Martijn van Oosterhout klep...@svana.org 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