Thread: Still unclear about PQexecParams and "create view"

Dear All,

I'm still unsure about whether I am allowed to use PQexecParams to
execute a create view command with $n parameters; reading between the
lines of Peter Eisentraut's message I get the impression that this
isn't going to work.  So:

- Can anyone offer a list of which commands are compatible with
PQexecParams and which aren't?

- Is this likely to change any time soon?

- Would you agree that not giving an error message immediately is a bug?

- Since I have now changed all my code to use PQexecParams and binary
parameters, I think it is easiest for me to put a wrapper around it
that substitutes $ parameters before passing them to PQexec.  I'll post
the code when I have it working - but maybe someone has already done this?


Cheers,

Phil.

"Phil Endecott" <spam_from_postgresql_general@chezphil.org> writes:
> - Can anyone offer a list of which commands are compatible with
> PQexecParams and which aren't?

Plannable queries can take parameters: SELECT/INSERT/UPDATE/DELETE.
Utility commands (which is everything else) don't do any expression
evaluation and thus can't deal with parameters.

> - Is this likely to change any time soon?

No.

            regards, tom lane