public void IsKeyComposite()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TEMP TABLE data (id1 INT, id2 INT, PRIMARY KEY (id1, id2))");
using (var cmd = new NpgsqlCommand("SELECT id1,id2 FROM data", conn))
using (var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly | CommandBehavior.KeyInfo))
{
var columns = reader.GetColumnSchema();
Assert.That(columns[0].IsKey, Is.True);
Assert.That(columns[1].IsKey, Is.True);
}
}
}