public void IsAutoIncrementMetadataSupport()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TEMP TABLE data (id SERIAL PRIMARY KEY)");
var command = new NpgsqlCommand("SELECT * FROM data", conn);
using (var dr = command.ExecuteReader(CommandBehavior.KeyInfo))
{
var metadata = dr.GetSchemaTable();
Assert.That(metadata.Rows.Cast<DataRow>()
.Where(r => ((string)r["ColumnName"]).Contains("serial"))
.All(r => (bool)r["IsAutoIncrement"]));
}
}
}