public void FunctionTestTimestamptzParameterSupport()
{
/*
ExecuteNonQuery(@"INSERT INTO data (name) VALUES ('X')");
ExecuteNonQuery(@"CREATE OR REPLACE FUNCTION testtimestamptzparameter(timestamptz) returns refcursor as
$BODY$
declare ref refcursor;
begin
open ref for select * from data;
return ref;
end
$BODY$
language 'plpgsql' volatile called on null input security invoker;");
var connectionString = ConnectionString + ";enlist=true";
using (var scope = new TransactionScope())
{
using (var connection = new NpgsqlConnection(connectionString))
{
connection.Open();
var command = new NpgsqlCommand("testtimestamptzparameter", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new NpgsqlParameter("p1", NpgsqlDbType.TimestampTZ));
//NpgsqlDataReader dr = command.ExecuteReader();
//Int32 count = 0;
//while (dr.Read())
//count++;
var da = new NpgsqlDataAdapter(command);
var dt = new DataTable();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
}
}
*/
}