Devart Forums

j use microsoft vb 2005 with PostgreSQLDirect.NET 2.5

PostgreSQL for windows 8.x

Using GetSchema("Indexes") with restrictions not work

example (mvarconnectionDB is a CoreLab.PostgreSql.PgSqlConnection:

Dim Dtl As System.Data.DataTable = Nothing
Dim Res(3) as String
Res(0) = Nothing 'IndexName
Res(1) = Nothing 'SchemaName
Res(2) = "Test" 'TableName
Res(3) = Nothing 'OID
Dtl = mvarConnectionDB.GetSchema("Indexes", Res)
Dtl.Rows return no rows

if j not use Res(2) = "Test" but Res(2)=nothing it work but return all indexes in database of all tables

The same problem persist in restrictions of Databases GetSchema setting a specific database name.

Another question is: how we can convert Row.Item("columns") in vb with a list of columns in the index or what is the way to read columns in an index ?

Thanks

This is a documentation bug. Restriction are applied in the following order:
0 - Schema name
1 - Table name
2 - Index name
3 - OID

Documentation will be adjusted as soon as possible.