Tatsuo Ishii san, a committer, proposed this to test extended query protocol.
Can it be included in Postgres core?
A toool to test programs by issuing frontend/backend protocol messages
https://github.com/tatsuo-ishii/pgproto
Regards
Takayuki Tsunakawa
On Tue, Aug 11, 2020 at 11:22 PM Tom Lane wrote:
> Andy Fan writes:
> > I want to write some test cases with extended query in core test system.
>
> Why? (That is, what is it you need to test exactly?)
>
>
Thanks for your attention. The background is I hacked exec_bind_message[1],
then I want
Thank you Ashutosh for your reply.
On Tue, Aug 11, 2020 at 9:06 PM Ashutosh Bapat
wrote:
> You could run PREPARE and EXECUTE as SQL commands from psql. Please
> take a look at the documentation of those two commands. I haven't
> looked at TAP infrastructure, but you could open a psql session to
Hi,
On 2020-08-11 11:22:49 -0400, Tom Lane wrote:
> I recall someone (Andres, possibly) speculating about building a tool
> specifically to exercise low-level protocol issues, but that hasn't
> been done either.
Yea, I mentioned the possibility, but didn't plan to work on it. I am
not a perl pers
Andy Fan writes:
> I want to write some test cases with extended query in core test system.
Why? (That is, what is it you need to test exactly?)
psql has no ability to issue extended queries AFAIR, so the normal
regression test scripts can't exercise this. We haven't built anything
for it in t
You could run PREPARE and EXECUTE as SQL commands from psql. Please
take a look at the documentation of those two commands. I haven't
looked at TAP infrastructure, but you could open a psql session to a
running server and send an arbitrary number of SQL queries through it.
Said that a server start
I want to write some test cases with extended query in core test system.
basically it looks like
PreparedStatement preparedStatement = conn.prepareStatement("select *
from bigtable");
preparedStatement.setFetchSize(4);
ResultSet rs = preparedStatement.executeQuery();
while(rs.next())
{
System