Still unclear about PQexecParams and "create view"

Started by Phil Endecottabout 19 years ago2 messagesgeneral
Jump to latest
#1Phil Endecott
spam_from_postgresql_general@chezphil.org

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Phil Endecott (#1)
Re: Still unclear about PQexecParams and "create view"

"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