GetSchema Indexes 2.5 bug

GetSchema Indexes 2.5 bug

Postby Andrea Rocca » Tue 09 May 2006 17:17

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 ?

Andrea Rocca
Posts: 5
Joined: Fri 10 Mar 2006 15:50

Postby Alexey » Thu 11 May 2006 06:07

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.
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for PostgreSQL