Running PostgreSQLDirect .NET Data Provider 2.10, i have a couple of issues, i guess bugs, while retrieving the schema of a database.
1) the generic GetSchemaTable function from the DataReader (inherited and overloaded from IDBDataReader i think). In this, some field of the DataTable Row are not filed properly: the 'is not null', and the 'key' filed are never set, whatever state the db column is in reality.
2) I then moved on to the GetSchema function of the PgSqlConnection which is, even if specific to postgres, better information wise, a lot more is accessible, great. The problem is that the columnlength of a column object is never set for fixed size char type field. I can understand that a text type give out -1 as len, but a char(100) should return 100 as it len, but still return -1. Interstingly enought, "fixed fixed" types do set their len field (and i dont needed as it is fixed
)Thanks for any help / feedback
Cheers,
J.