[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-hackers
Subject:    Re: EXECUTE does not process parameters
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2018-04-30 23:43:43
Message-ID: 28928.1525131823 () sss ! pgh ! pa ! us
[Download RAW message or body]

Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> The SQL-level EXECUTE statement does not process parameters in its
> arguments.  So for example, the following does not work:
> ...
> It seems this needs some special treatment in transformStmt().  Any
> reason not to do that?

I have a vague recollection of having poked at this years ago and
found out that there were some interesting corner cases to worry about.
I think they had to do with parameters being passed through multiple
execution layers, but I don't remember for sure.  All I can say is
that this is probably trickier than it looks.

			regards, tom lane


[prev in list] [next in list] [prev in thread] [next in thread]