Kevin Grittner wrote:
> People have said that issuing SQL commands directly from a TAP test
> via DBD::Pg is not acceptable for a core feature, and (despite
> assertions to the contrary) I see no way to test this feature with
> existing testing mechanisms. The bigger set of work here, if we
> don't want this feature to go in without any testing scripts (which
> is not acceptable IMO), is to enhance the isolation tester or
> hybridize TAP testing with the isolation tester.
Is it possible to use the PostgresNode stuff to test this? If not,
perhaps if you restate what additional capabilities you need we could
look into adding them there. I suspect that what you need is the
ability to keep more than one session open and feed them commands;
perhaps we could have the framework have a function that opens a psql
process and returns a FD to which the test program can write, using the
IPC::Run stuff (start / pump / finish).
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services