PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

PgSqlDataReader.GetSchemaTable and PgSqlConnection.GetSchema

Postby jef » Thu 14 Jul 2005 11:58

hi all,

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.
jef
 

Postby jef » Thu 14 Jul 2005 12:00

and i guess the issue 2 is fixed in 2.11 didn't read the release note ... will test that at least
jef
 

Postby Guest » Thu 14 Jul 2005 12:59

just tested, NOT fixed in 2.11 (full release, duno if it change something). The property which is a problem is:

"columnlength" from the "Columns" GetSchema method.

Tx for any information on this
Guest
 

Postby Yuri » Fri 22 Jul 2005 09:06

We got your request and now examines the problem.
As soon as we solve the problem, we'll let you know.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07

Postby Yuri » Fri 05 Aug 2005 11:56

We reproduced your problem and fixed it.
This fix will be included in the next PostgreSqlDirect .NET build. It will be available in a week.
Yuri
 
Posts: 140
Joined: Mon 08 Nov 2004 12:07


Return to dotConnect for PostgreSQL